Using AsEnumberable do the Lookup Activity


i have three excel file as my input, Data and Output. i tried do the AsEnumberable function do the lookup activity as to be done…

Files are attached.
Input file.
Input .xlsx (8.5 KB)

Standard Data to lookup.
Data.xlsx (7.6 KB)

Finaly output what i need on the attachment. done by vlookup functions in excel.
Output.xlsx (10.0 KB)

Any idea about this please ping me. as soon as possible.



When you are using a LOOKUP DATATABLE activity it can be used within a for each row loop without use of any AsEnumerable

Did we try that as it is way more easier and simple

For example have a view on this

Cheers @Shyam_Pragash