column header split in two lines in same cell

[jdbustamantec]

Hi -- I'm using data extract from a public site and the columns look like this:

After running the workflow column headers just show the month and not the year:

How can I fix this issue? I would like the column headers to be Jan 2010 / Feb 2010 / etc

Thank you

 

 

[AngelosPachis · Accepted solution]

Hi @jdbustamantec , 

What's the input type for your workflow? Is it an Excel file where the data looks like those shown below?

If yes, what you can do is in your input file to click the option of reading the first column as data

 That will make your headers appear as data in row 1 and then you can extract that row and process it so you can parse the characters appearing in new lines and put them side by side.

Hope that helps,

Angelos

[jdbustamantec]

Hi Angelos -- The input type is an excel file that looks like the example you showed.

I'm trying to open the alteryx package you attached but I'm getting the following error and nothing happens when I click "ok". Any idea how to solve this? Thank you 

 

[atcodedog05]

Hi @jdbustamantec 

You should be able to open this version of @AngelosPachis workflow.

Hope this helps : )

[atcodedog05 · Accepted solution]

Hi @jdbustamantec 

My take on this

Make sure read it as first row contains data.

Workflow:

Hope this helps : )