I need the column names to match for when I do a union, but the cross tab tool changes the name. I need to use the cross tab feature with autoconfigure union tool b/c it may add/remove columns each time the workflow is run.
Solved! Go to Solution.
Hey @jaygerbs can you attach the data in your workflow? As it's not zipped, this isn't included! Thanks :)
Hey @jaygerbs you'll need to either package the workflow (export - see screenshot below) and make sure the data file is contained, or just upload the Excel here. At the moment the Input Data tool just points to a location on your machine and so when you send it to others/upload here, when we go to use it we obviously can't connect/access that file. Packaging creates a zipped workflow with the Excel contained within as an asset.
@DataNath I got ya know, I think..... sorry!
Lovely, thanks @jaygerbs! How does this look?
Basically in the Cross-Tab, special characters (like spaces/# symbol) are replaced by underscore. Therefore, before the Cross-Tab we can create a lookup by doing these replacements ourselves. After the CT we then just look for the hyphen-replaced field names and replace them with our desired headers:
Hope this helps! Please let us know if you have any questions.
@DataNath thanks a bunch!