Please can you help me with the expression I need to write in an assign activity to get the first row from my data table.
It has two columns so I want to get the data from both columns.
I can see that ExtractDataTable.Rows(0).Item(0) would extract the 1st row and first column value (e.g “baked beans”. How do I modify this expression to get the value from the second column as well? (e,g “baked beans 24p”
Thinking about it, how would I do this so the two values remain in separate columns so I can paste them in to an excel file as two columns?