In my scenario, I want to fetch another column based on “Place” Column cell value for AKOLA 01
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
Try below expression.
newDT = inputDT.Select("Place = 'AKOLA 01'").CopyToDataTable
Thank you so much its work now as per requirement.
This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.