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

[DiganP]

@AlexCela Have you tried using the reporting tools, specifically the table tool? It will help you set proper formatting for the dataset. You can use the render tool to write back out to a excel file. 

You can right click -> Open example on the table tool if you need help getting started!

[AlexCela]

Thanks @DiganP , I will try if the problem persists 🙂 

Also, just to add more ideas about this issues, actually my headers are not truncated, but the words are separated in more words by an alter + enter. See attached photo 

Any new ideas to why that maybe? 🙂

[DiganP]

@AlexCela Do you have an example file/workflow that does this? I would love to take a look at it.

[danilang]

Hi @AlexCela 

How is your data coming in to your workflow?  Are the line breaks in the column headers (Alt-Enter) in the input file/Query?  Are you building up the column names through a crosstab?

Dan   

[AlexCela]

@danilang actually you are right, it is the case, and even with an apostrophy. See attached screen shots. Don't know why it used to work then without issues the previous weeks haha

[danilang]

@AlexCela 

In that case you can use a formula or a Regex tool in Alteryx to replace the line breaks(\n, in regex) with spaces.

Dan

[AlexCela]

@danilang thanks a lot, I will try tomorrow, I ll keep you posted 🙂

[DiganP]

@AlexCela The formula tool function would be the replace function. You can also use the data cleansing function to do the same functionality.

If you just want to make changes to the header of the column, you can use the dynamic rename tool with the regex formula to make the change as well.

[AlexCela]

Hi @DiganP @danilang , so I tried with the data cleansing tool and also the dynamic rename to replace the '/n' with blanks with the regex tool, and it still doesnt work. The value inside the cell (which is printed corrected correctly) is still presenting line breaks. 

You can see the issue I think while looking at the column names inside alteryx when choosing with field to apply the formula to, it will only make appear 'Rpt' instead of the full name. 

Here attached is a sample data with just two headers and one of the little workflows that I tried to use. Would be awesome if you find the solution 🙂 Thanks again 

Alex