Excel output numbers stored as numbers in table with header

Question

I was wondering if alteryx is able to output table to excel looking like this:

Header1.1Header1.2Header1.3  STRINGSTRINGSTRING  Header2.1Header2.2Header2.3Header2.4Header2.5STRINGNUMBERSTRINGSTRINGSTRINGSTRINGNUMBERSTRINGSTRINGSTRING

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)

HomesickSurfer · Answer

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.

I2ufu5 · Answer

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.1Header1.2Header1.3Unwanted headerUnwanted headerSTRINGSTRINGSTRING  Header2.1Header2.2Header2.3Header2.4Header2.5STRINGNUMBERSTRINGSTRINGSTRINGSTRINGNUMBERSTRINGSTRINGSTRING

HomesickSurfer · Answer

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.

Mixed Format Fields Ouput.yxmd