I’m reading an excel file with Read Range activity and as result it gives me a data table. My excel has 3 columns and 3 rows but when I read this with Read Range activity, the resultant table is of 1 column per 9 rows. What I want is with a For Each activity skip each 1,2 and 3 rows (corresponding to the number of columns in my excel file) and assign it to a new variable (I want a variable for each existing column in Excel file so for each For each cycle i’ll get inside my variables the values corresponding to the row in the Excel File).
My excel is like this
But the datatable that i get with Read Range activity is like this
So what i want is with the for each assign each value to a variable
Name = row.skip(1)
How can I do this? If you can provide an example i’ll appreciate it!