Lookup DataTable for multple columns

[samir (Samir Mohite)]

Hi @hsheoran,

This will help you in using Lookup Datatable activity.

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 …

But in this case, you need 2 lookup datatable activities.