I’ll also add a few more helpful things.
To store items from a particular row, like in a For each for example, you really only need to use either an Assign activity (my preferred method) or the Get row item activity.
You just need the column index or column name.
For Get row item, you need to fill out these properties:
You can put row in the Row property, then use either the Index or the Name of the column to extract a particular item and store in the Value property
If you want to use an Assign activity, then you can set it up like this:
variable = row("columnname").ToString
variable = row(index).ToString
And you can also do some manipulation to the value if needed within the same Assign activity.
Get the .IndexOf() of the row during the For each is only beneficial if you would like to skip to that item at the start of the For each, in the event you exit out to a Catch then reenter that For each again. Or you can use that number for analytics to store the index that is being processed. However, you can’t really use that index for extracting items of a particular row.
Hope that bit of info is helpful.