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

[wdescalsota]

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 (Arpan)]

@wdescalsota

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 (pravin kumar)]

Hi @wdescalsota

inside the for each row

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

Regards

[Gokul001 (Gokul Balaji)]

Hi @wdescalsota

Here is the workflow

Sequence.xaml (9.2 KB)

Regards
Gokul

[wdescalsota]

It doesn’t seem to work

[Gokul001 (Gokul Balaji)]

Hi @wdescalsota

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 (Arpan)]

@wdescalsota ,

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

[wdescalsota]

Currently within it’s cope

[wdescalsota]

This is the DT I am looping through

[wdescalsota]

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