Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

Dynamic Mapping

Mukeshy12390
8 - Asteroid

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_NameProduct IDMappingSourceProduct price
Laptop111C:\Users\r650323\Desktop\mapping\[Mapping001.xlsx]Sheet1 
Laptop111C:\Users\r650323\Desktop\mapping\[Mapping001.xlsx]Sheet1 
Book222C:\Users\r650323\Desktop\mapping\[Mapping002.xlsx]Sheet1 
Book222C:\Users\r650323\Desktop\mapping\[Mapping002.xlsx]Sheet1 
1 REPLY 1
Mukeshy12390
8 - Asteroid

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

Labels