I have a sequence in which i am using lookup range activity to look for particular value which is column A .
Now i want to modify that logic to look for combination of values…like Value1 from Col A + value 2 from col B…something like this
I am using excel and i will look for these values row wise.In same row…value1 and value2
Any leads on these @Palaniyappan @ppr @indra @loginerror @nisargkadam23 @RPAForEveryone @mvpmurali @sudheern
please share some sample data. As we do have multiple options we can better select the solution from the choice
I have this kind of excel data.
Where In logic i was already lookup for material column value.now i want to add two more columns in lookup activity to make the logic more reliable even if same material there in multiple rows.
Please advise me on this
Please consider using Filter Data Table activity.
This link shows information with images, how the Filter activity can be used to include multiple lookup columns using AND and/or OR combinations.
I hope this solves your query.
Hey @Satish_Ch!! Try this!
Im using this excel as Input.
I’m reading this data and storing it in the “dt_input” variable.
I will surround my Assign activity with “Try Catch” to simulate the “Lookup DataTable” activity. If no match is found, it returns -1.
We first perform a filter on the values to identify the match.
( From p In dt_input.Select()
Where p(0).ToString.Equals(val1) and p(1).ToString.Equals(val2)
Select p ).CopyToDatatable
If there is a corresponding line, let’s proceed with the assign of the Lookup value.
If there is no match, an error will be thrown. We will catch this error and assign the value “-1” to the Lookup variable.
Hope it helps!
This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.