how to create a loop over datatable

  • 142 Views
  • Last Post 1 weeks ago
akhil@mittalsoftwarelabs.com 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
support@intellibot.io 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
  • admin@repcat.cat
nitesh.raj@sc.com posted this 2 weeks ago

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

  • Liked by
  • vasu.manchala@cognine.com
Intellibot Support posted this 1 weeks ago

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.

Close