I have read the excel data using data reader and passed the data to data table using set table.
Now I need to create a loop over data table and read the data into variables.
How can we do this?
I have read the excel data using data reader and passed the data to data table using set table.
Now I need to create a loop over data table and read the data into variables.
How can we do this?
Hi Akhil,
You can iterate the data by using 'ForEach' Loop followed by 'GetListItem' Component and store the data into a variables.
Please find the GetListItem documentation for your reference
Please find the screenshot below for your reference.
Thanks & Regards,
Intellibot Support.
hi Team,
Understand that GetListItem will provide the value based on index and we can pass it to variable or forms, what if columns index of excel sheet is not fixed, i need to get the data based on column name, appreciate if you can provide the solution, thanks in advance.
Regards,
Nitesh Raj
Hi,
Apologies for the late response. If the column names position changes, you can try this and get data.
Please find the screenshots below for your reference.
Thanks & Regards,
Intellibot Support.