Cross Tab Tool Changes Column Name (it removes " #"), but I need it!

[jaygerbs]

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.

[DataNath]

Hey @jaygerbs can you attach the data in your workflow? As it's not zipped, this isn't included! Thanks :)

[jaygerbs]

@DataNath 

[DataNath]

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.

[jaygerbs]

@DataNath I got ya know, I think.....  sorry!

[DataNath · Accepted solution]

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.

[jaygerbs]

@DataNath thanks a bunch!