column header split in two lines in same cell

Question

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 Answer

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

atcodedog05 · Accepted Answer

Hi @jdbustamantec

My take on this

Make sure read it as first row contains data.

Workflow:

Hope this helps : )