How i can filter vlaues based on Uinque value from other column

In my scenario, I want to fetch another column based on “Place” Column cell value for AKOLA 01

1 Like

Yah that can be done with LOOKUP DATATABLE activity
Where the sequence would b ike this
—use READ TANGE activity and get the output with a variable of type datatable named dt
—now use a for each row activity and pass the variable dt as input
—inside the loop use a LOOKUP DATATABLE activity
Where mention these in the property panel
Input - “AKOLA 01”
Datatable - dt
Lookup column name - “Place”
Out Result - str_output
Target column name - “yourcolumnname which you need as a output value”

So followed by this use a WRITE LINE activity and mention as str_output.ToString will be our output value

Cheers @Arun_Pondhe1


Try below expression.

     newDT = inputDT.Select("Place = 'AKOLA 01'").CopyToDataTable

Thank you so much its work now as per requirement.

Awesome @Arun_Pondhe1

1 Like

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