Hey everyone,
Hopefully this will be a quick one. I'm trying to create a table with the reporting tools. I've got the headers that I want in the 'headers' input, and the data in the 'data' input. I tried unioning the two inputs together, but Alteryx switched the data type of the numbers to VW_String since the header information is a string. We need to have the numbers remain as double. Does anyone know how to get around this issue?
The 'test4' file is our ideal output.
Thanks!
Solved! Go to Solution.
@JordanJ Have you tried splitting up the headers and data into 2 streams and then union it back together?
This should keep the numeric data numeric. Attached is the workflow.
@DiganP Thanks for looking at this Digan! This was really close to working but when I tried copying your portion into my real workflow the column headers didn't quite line up with the data columns for some reason. When I opened the table in Excel the column headers were merged across two cells which caused things to be mislabeled.