how to create a loop over datatable

235 Views
Last Post 08 January 2021

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?

#Permalink
0
0
0

3 Comments

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.

#Permalink
1
0
0

Liked by

nitesh.raj@sc.com 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.

Regards,

Nitesh Raj