If condition - add to collection another row

Hello every one,

I’m trying to do something and i’m struggling.

I try to do that :

Condition : Correct (Correct is a variable on a previous assign but anyway)

Add to collection
I would like to put in the collection a previous row and i know his index

Anyone can help me please ? Thank you ! :slight_smile:

Previous row means would like to insert a Datarow
Kindly elaborate the scenario a bit more pls
Cheers @BaptisteC

1 Like

Thank you for your reply @Palaniyappan,

I explain you,

I’m working in a data table. I put a for each activity and a several condition.

The first If is to know the row which contain a specify substring and i put his index as variable.

Second if, if row(“Column3”) contain a specify substring and row(“Column3”)(index +1) with same Substring <> row(“Column3”).contain(“String”) i put an assign “Correct”

Third if, if correct, add to a collection the row with the index found in the first if.

Feel free to ask me if you want more. Thank you for your help

If we have stored that index in a int32 variable then we can add that to items property in ADD TO COLLECTION like this variablename-1 and also the collection property with the list or array variable name you have

Make sure that type argument property is set as int32

Cheers @BaptisteC

1 Like

For my information, why you put “-1” ?

I have another request, if i want to remove a specify item in a collection. I know that i can use Remove From Collection but i don’t know how it works…

I specify like that : “F0,B7,1000 140819FRT3ORDLIV”

Can you help me ?