Lookup DataTable

Help Activities
, ,
1

In the Lookup Datatable can we take multiple columns as input ?

2

Hi @Ritaman_Baral

“Lookup Data Table,” you can only specify a single column as the input for the lookup. The activity allows you to search for a value in a specified column of a DataTable and retrieve a corresponding value from another column in the same row.

If you need to perform a lookup based on multiple columns, you can concatenate the values of the desired columns into a single string and then use that concatenated string as the input for the lookup. This approach assumes that the concatenated value uniquely identifies each row in the DataTable.

Thanks!!

3

No. But you can use Filter Datatable and designate multiple columns. The output datatable will contain the row(s) with the matching values.

4

@Ritaman_Baral
Lookup Data Table uses a single row
You can use a For Each Row in Data Table
If activity:
row(YourColumn1).ToString.Equals(“Whatever”) AND row(YourColumn2).ToString.Equals(“Whatever”)
If True:
index = dt.Rows.IndexOf(row)

Regards

5

@Ritaman_Baral

If you need the row number where it is matching or so you can use find/replace activity instead then it will look irrespective of the column

Cheers