Merge Header with Second row to create custom header

Question

Hi,

I have a dataset which has month and year in two separate rows. Below is how it comes to us.

Any way to combine the header with the month row and arrive at Header in MMM-YY text format?

This would really be helpful for me. I have tried different approaches but they don't seem to be working for me.

RaviP · Answer

I took a similar approach to @KarolinaRoza 's.

I checked the 'First Row Contains Data' and used my workflow. Hope this helps as well.

Ravi

MergeHeaderandRows.yxmd

KarolinaRoza · Answer

Hi @PKoya,

I propose my solution. I think it should work despite the year which you are having in first row.

Let me know if it works for you.

Karolina

columns rename.yxmd

Emil_Kos · Answer

Hi @PKoya,

There is a problem with the headers that have only 2021 in the header. As you are not allowed to have the same headers in Alteryx.

Maybe alternatively you just can add the year number by hand?

2021 rename.yxmd