Build Data Table and get Information

Help
, ,
1

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
2

Try to use Filter Datatable activity.

Regards,
AK

3

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

4

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

1 Like
5

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