Build Data Table and get Information

Hello together,

i am having the following DataTable which i buildCapture

my process will find a variable, which contains one of the letters in column1. What i want to do now is, to find the result from my variable (for example XCO) and bring out the information out of column2 into a new variable (in this case /CO)

Can somebody help me out here?

Thanks and Regards

1 Like

Try to use Filter Datatable activity.


We can use LOOKUP datatable activity where in the lookup datatable property panel mention these stuffs
Input value = yourvariablename.ToString
Where this variable will be holding the column1 value whose equivalent column2 value is to be found

Datatable - your datatable name
Lookup column name - “Column1”
Out Result - str_output
Target Columnname - “Column2”

So our out variable with be str_output of type string will hold that value we want

Cheers @Berto

Thanks a lot @Palaniyappan it worked like this.=)

1 Like

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