Hi Team,
I have created an excel that is static and used just for the headers
The static excel file looks like this -
Car | Bus | Airplane | Bus |
Note that there are repetitions and spaces within these headers
I load the headers using an input tool and add a field info, record ID, cross tab and then a union tool. Which adds a row with my header to the results.. I then remove the Alteryx header from the final output and output to a csv from row 1 (I do this because there are multiple 'Bus' and I don't want Bus2 and Bus to be part of the headers).
But when doing this the spaces and other changes do not take effect and the output is not accurate
Please help and advise other ways to accurately copy and paste headers into my final file
Is there another way to add this static file to row one of my sheet while keeping the same format?
Solved! Go to Solution.
Hi @henrygeorge,
here is a workflow doing what you described, I don't have any error when I open it in the end. Tell me if it works also for you.
Hi @henrygeorge
Can you not just use a Text Input tool for your headers, but put them in the 1st line of data, like this
Field1 | Field2 | Field3 | Field4 |
Car | Bus | Airplane | Bus |
Then generate your data as well without headers and union them. This way, your spaces are maintained. You then write the CSV with 1st row contains headers unchecked. Example attached.