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

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?

@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

Hi @wdescalsota

inside the for each row

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

Regards

Hi @wdescalsota

Here is the workflow

Sequence.xaml (9.2 KB)

Regards
Gokul

image

It doesn’t seem to work

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

1 Like

@wdescalsota ,

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

image
Currently within it’s cope

image
This is the DT I am looping through

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

2 Likes

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