Unioning Two Data Types

[JordanJ]

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!

[DiganP]

 @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.

[CharlieS · Accepted solution]

I've attached another example for your review. 

[JordanJ]

@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.