Dynamic Mapping

[Mukeshy12390]

Hi All - 

Is there any way we can do lookup on the basis of field value.

in below example one basis of proudct and mapping source we need to perform lookup.

Mapping source has two field ProductID and Product Price

the reason I'm looking for Dynamic solution because mapping source could increase in future like 30 different files.

Product_Name	Product ID	MappingSource	Product price
Laptop	111	C:\Users\r650323\Desktop\mapping\[Mapping001.xlsx]Sheet1
Laptop	111	C:\Users\r650323\Desktop\mapping\[Mapping001.xlsx]Sheet1
Book	222	C:\Users\r650323\Desktop\mapping\[Mapping002.xlsx]Sheet1
Book	222	C:\Users\r650323\Desktop\mapping\[Mapping002.xlsx]Sheet1

[Mukeshy12390 · Accepted solution]

Done...

here is the solution -  I have created one Batch Macro to console all mapping file into one sheet and then "Find and Replce" tool to look.

also if anyone has different solution please post would love to try.

Regards,

Mukesh Y