Weird excel headers output

[AlexCela]

Hi all, 

I am currently having a weird issue regarding building a weekly excel report via alteryx (which did not exist last week) 

Basically when outputting my data to excel, a lot of headers, starting from a precise fields, get printed correctly (the same title name in Alteryx and in Excel) but when clicking on the headers cell, the value is the same header but truncated or abbreviated, changing therefore the value of the headers in excel and making it impossible to update a weekly pivot table based on these headers... And oddly enough, among all these weird headers, one is working good, the "No DSM Qty" 

Here is some pictures

This is very weird haha. If you have any insights, it would be awesome thanks 🙂 

Cheers 
Alex

[danilang · Accepted solution]

Hi @AlexCela 

Here's one way you can go about it.

First make sure that the First Row Contains Data option is checked in the Input tool

Then the 2 sample tools separate the 1st row from the rest.  Use a data cleansing tool to remove the line breaks from the first row and then a dynamic rename to take the field names from the now cleaned 1st row.  Union this with the rest of the records byt position  and use an auto field to set the field types for the columns.  

Dan

[DiganP]

@AlexCela 

Try this! The real key is the highlighted field.

Attached is the workflow.

[AlexCela]

@DiganP @danilang  Thanks all for your inputs, it works 🙂