Compare columns and grab next cell

[samir (Samir Mohite)]

Hi @Robert_Wennberg,

@Robert_Wennberg

needs to be compared to see if the value in dt1 exists in dt2, and if it does grab the cell to the left of said cell and use that value to do a google search.

You can use LookUp DataTable activity in for each row.

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 …