Hi I am completely new to Alteryx so please bear with me. I have one file with a table that needs to be mapped to some unique IDs, this file 1 also has multiple tabs which will need to be used for some analyses like interest, dividends, PNL, and so on so ultimately they need to be retained, even though for alteryx purposes the other tabs would not be used. For file 2 I have a Mapping which identifies accounts in file 1 TB to unique IDs that I will later use in my analyses.
To get the TB mapped - I used input data from file 1 and file 2 and used a "find and replace" operator to map the TB; however, when i map this and output the data - I get a single file with a single tab - the original TB mapped with a new column to the right which shows the Unique IDs from File 2. Mission accomplished for mapping but now I've lost all my original file 1 extra tabs.
Also, this process would get repeated for multiple file 1's. So Instead of doing input filepath for just one file, I did a filepath by using *.xlsx so Alteryx could import multiple TBs at one time. So, I would like to learn how to update each file 1's TB tab rather than have 1 huge output with every TB mapped in one file.
I hope this makes sense. Please help if you have suggestions.