Hi All --
I built a workflow that pulls information from approximately 325 spreadsheet templates. Most of the templates have a single tab. However, some templates have multiple tabs of data with a third tab (or more) summerizing the data. This is causing me an issue as I am doubling up on some of my numbers.
What I noticed is that there is a field in the data tabs called Full VA? that doesn't exist in the summary tabs (see images below). The coordinates (using the @Joe_Mako Cleaning messy Excel Data method is Record 5 Name 1.
I am trying to figure out how to use information from spreadsheets that have a Full VA? at record 5 name 1 -- but keep hitting a dead end.
Thanks,
Seth
Summary tab
Data
Solved! Go to Solution.
Attached is your workflow edited and the missing macro so anyone else can open your original workflow.
Also attached is this alternate approach:
After the loading:
- Filter tools to grab the values of interest
- Join match up the field names and field values
- Cross Tab to create the normal data structure
- Join the two constructed data tables together
Is this what you are looking for?
I altered your solution to fit into my current workflow. This was awesome @Joe_Mako. Thank you!