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

2 files - source and Hierarchy (Vlookup or Find and Replace)

Arkouda
8 - Asteroid

Hi All

 

I have 2 files

 

1) Source file where I want to look up the name for the Entity Office Team codes to return the description - basically it''s a v lookup in Excel, put the file has multiple tabs to look up the information. I have tried find and replace and other items but can't seem to get the results. I have attached a sample for what I'm trying to archive

 

Source

 

COMPANYOFFICETEAMACCOUNT
2501RED10001684001006
2501RED10001684001006
2501RED10001684001006
2501RED10001684001006
2501RED10001684001006
2501RED10001684001006
2501RED10001684001006
2501RED10001684001006
2501RED10001684001006
2501RED10001684001006
2048WEI10001764001006
2048WEI10001764001006
2048WEI10001764001006
2048WEI10001764001006
2048WEI10001764001006
2048WEI10001764001006
 

Lookup Tables

 
Base Level CodeBase Level Alias
2048Test Entity
2501Test Entity 2
  
  
3 REPLIES 3
rbarco
7 - Meteor

Hi @Arkouda,

If you want to use find and replace tool remember that comparing fields must be strings. 

 

Find and replace.png

 

I've attached a solution based in your sample. 

 

 

Arkouda
8 - Asteroid

Hi Barco - thank you for getting back to me so quickly - I forgot to add my attachment where I have one source file and the multiple tab file for Vlookup

 

Is there a way (i'm sure there is) to look into each tab and pull the information?

 

Attached is a Source Test File and a Hierarchy file

rbarco
7 - Meteor

Hi @Arkouda ,

If there are only 3 sheets to import, the simplest way to achieve it is using the input tool 3 times. I've attached a solution for this. 
In case the are more sheets or these are totally different, you will need to create a macro. If this is the case, please check the follow link:
Import Multiple Excel Sheets 

 

If this solves your issue please mark the answer as correct, if not let me know!

 

Labels