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
Solved! Go to 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
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
My take on this
Make sure read it as first row contains data.
Workflow:
Hope this helps : )