Extract data from data table


#1

Hello,

I would like to extract certain components from a data table (for instance, the position 2,2) and convert it to a string variable.

How could I do it?

Thanks a lot


#2

Use Getrow item and check @pal1910


#3

You’ll need to have a for each row activity, and for each row use an if statement to check you’re on the desired row. Then use a get row item and specify which row item you would like to retrieve. The output of the get row item activity can be the string variable you would like to end with. Example xaml:

Retrieve_Datatable_Item.xaml (8.9 KB)


#4

Thank you very very much.

Is it not possible to use the Get row item activity without using the For each row activity?

Thanks!
@KEntwistle


#5

Not that I know of, as I don’t think you can specify the datatable for the get row item activity in isolation.


#6

Get Row item is expecting a Datarow variable, you can for example access it using by index as follow

image

or even using dt.AsEnumerable via a linq expression

ex: dt.AsEnumerable().Where(Function(r) r("Id").toString = "25").first()

Cheers


#7

hi,

follow output data table activity in the below video.

thanks,
Karthik.