Unioning Two Data Types

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!

test4.xlsx

New Workflow2.yxmd

Datasets

Reporting

Accepted answers

CharlieS

I've attached another example for your review.

20191028-MultiTableExcel.yxmd

All comments

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.

Workflow V2.yxmd

CharlieS

I've attached another example for your review.

20191028-MultiTableExcel.yxmd

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.

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15867

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703