How to assign a value from one column of Data Table to a variable by checking another column value

[samir (Samir Mohite)]

HI @Rohit_Gorilla,

Pls check this, might help you.

Facing issue while extracting data from data table

Hi @AryanSingh You can use Lookup DataTable activity here, you have max bill month stored in “LastMonth” variable. So parameters of lookup datatable should be, Input :- Datatable —> datatable variable Lookup Value —> LastMonth variable Lookup Column :- ColumnName —> “Bill Month” Output :- CellValue —> create system.double variable here(to store Actual balance amt) Target Column :- ColumnName —> “Actual Balance Amt” So that’s how you’ll get actual balance amt value in cellValue …