This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
I am a new user exploring Alteryx and was wondering if the following scenario is possible as I could not find a way to google my situation.
I extract excel data from 5 different data source systems. Once extracted, I need to clean up and standardize the data (i.e. brand A = product category 1, etc.) and then combine all 5 sources into one master excel file and then load it into Tableau.
Within each of these files, I need to create lookup tables to standardize data across the 5 sources.
1. Product A = "Product Category 1"
2. Error Code 5 = "Confirmed"
3. United States = "North America"
4. USA = United States
5. Unitd Stats of America = United States (typo examples)
Is there a way to build in this VLOOKUP logic into Alteryx that way every time I extract data, the lookups for specific fields will be stored in Alteryx, so I can simply import updated files into Alteryx and not have to keep re-cleaning my files each time?
For example, I want to have excel equivalent lookup tables built into Alteryx, so if there are new entries that have not been documented before, I can just update and add new new lookup entries to the respective tables.
Take a look at the attached. I created some fake data and lookup tables and demonstrated how the left browse will show you the records that are missing in the lookup tables. You probably will have to have multiple lookup tables (so do I) unless you have a common key (like product number) that is in all of your tables.
Also, I demonstrated how you can join fields even if they don't have the same name (product num and product for instance).
Let me know if you have any other questions once you've had a look at the workflow.