how to create a loop over datatable

  • Last Post 08 January 2021 posted this 21 June 2020

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? 

Order By: Standard | Newest | Votes posted this 22 June 2020

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.

  • Liked by
  • posted this 05 January 2021

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.



Nitesh Raj

  • Liked by
Intellibot Support posted this 08 January 2021


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.