How to get specific value from for each row in data table CurrentRow?

wdescalsota · February 10, 2022, 7:09am

I have a data table I want to loop through in, used the for each row in data table.

In my current Row there’s a column for Name, Age and Address, how do I select the value from Age?

supermanPunch · February 10, 2022, 7:10am

You can do so in the following :

CurrentRow("Name")

or

CurrentRow("Name").ToString

Same method can be used to get the values of Age and Address

pravin_calvin · February 10, 2022, 7:11am

inside the for each row

Currentrow(“Age”).tostring will list all the age

Regards

Gokul001 · February 10, 2022, 7:11am

Here is the workflow

Regards
Gokul

wdescalsota · February 10, 2022, 7:14am

It doesn’t seem to work

Gokul001 · February 10, 2022, 7:15am

Use Read Range activity

Store the value in the Data Table → DT

Use For each Row in Data table

User Assign activity
LHS - Create an variable
RHS - CurrentRow(“Age”).ToString

Refer the Screenshot

supermanPunch · February 10, 2022, 7:16am

In Debug Mode, Please Make sure the Control is inside the For Each Row Activity for the CurrentRow to be used

wdescalsota · February 10, 2022, 7:18am

Currently within it’s cope

wdescalsota · February 10, 2022, 7:19am

This is the DT I am looping through

wdescalsota · February 10, 2022, 7:20am

Sorry, this is right, I didn’t put any activity within body so robot didn’t go in, this works, Thank you

system · February 13, 2022, 7:21am

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.