Lookup DataTable for multple columns

[hsheoran]

Hi , I want to use lookup datatable activity as
I need to fetch the result value on the basis of lookup in two columns.

Any lead would be helpful.
Thanks
Hanish

[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, https://activities.uipath.com/docs/lookup-data-table 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 h…

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

[hsheoran]

Thanks @samir .I am already familiar with lookup datatable activity. Just wanted to know if there is any activity for lookup for more than column. Thank you for the support.

Regards
Hanish

[avejr748 (Ave Salvante Jr)]

Hi @hsheoran, I’ve had similar experince/use case with what you are trying to do. I have a need to lookup my data table but need to match two column values and then output the value of a third column. Though I have not found an activity to achieve this, I have found a way that works and just wanted to share.

What I did is filter my datatable using the first column I would like to match and then output it to a temporary datatable. Next I lookup this temporary datatable using the second column I would like to match and then output the value of the third column. Might not be so elegant but at least I get the result I need. I hope this can help you too…