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

[Arun_Pondhe1 (Arun Pondhe)]

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

[Palaniyappan (Palaniyappan P)]

Hi
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

[lakshman (Ganta lakshman)]

@Arun_Pondhe1

Try below expression.

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

[Arun_Pondhe1 (Arun Pondhe)]

Thank you so much its work now as per requirement.

[Palaniyappan (Palaniyappan P)]

Awesome @Arun_Pondhe1