Skip rows from Datatable

studio

#1

Hi all!

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

Name Year Gender
Julian 1995 M
Laura 1987 F
Jose 2000 M

But the datatable that i get with Read Range activity is like this

|Table|
Julian
1995
M
Laura
1987
F
Jose
2000
M

So what i want is with the for each assign each value to a variable
Name = row.skip(1)
Year =row.skip(2)
Gender =row.skip(3)

How can I do this? If you can provide an example i’ll appreciate it!

Regards,
J.


#2

HI @Juramirez,

Please refer below xaml file.
Book1.xlsx (8.2 KB)
SkipRowFromTable.xaml (14.4 KB)

Regards,
Arivu