I was wondering if alteryx is able to output table to excel looking like this:
Header1.1 | Header1.2 | Header1.3 | ||
STRING | STRING | STRING | ||
Header2.1 | Header2.2 | Header2.3 | Header2.4 | Header2.5 |
STRING | NUMBER | STRING | STRING | STRING |
STRING | NUMBER | STRING | STRING | STRING |
Where values under Header2.2 are stored as numbers and excel recognizes them as numbers (currently they are strings cause whole column needs to be string type)
Hi @I2ufu5
You need to split your data into 2 tables then define the field type of the secoind table to number, union, layout, render...
Workflow attached. Hope you like it and accept as solution.
Unfortunately this doesn't solve my problem. Reporting tools create messy formatted table with all columns having a text header. I need something looking exactly like the table from first post when I open it in excel.
Header1.1 | Header1.2 | Header1.3 | Unwanted header | Unwanted header |
STRING | STRING | STRING | ||
Header2.1 | Header2.2 | Header2.3 | Header2.4 | Header2.5 |
STRING | NUMBER | STRING | STRING | STRING |
STRING | NUMBER | STRING | STRING | STRING |
As far as i know, you can't output fields without field names.
You may want to consider appending your data starting at Row3 to a template with the initial header and string data in Rows1-2.