Forum Discussion

jure_rak's avatar
jure_rak
Helper I
7 years ago
Solved

Changing multiple columns names

Hi all,

 

I have got data that have 12 columns for months with the abbreviated month name - Jan, Feb, Mar etc. Previously, I just did not bother and manually changed these to be 31.1.2019, 28.2.2019 etc., than did "unpivot columns".

 

But as I have more and more reports, this manual approach has become inefficient, would you be able to advice me how to automate this process?

 

Thanks,

 

Tips and Tricks
  • MattAllington's avatar
    MattAllington
    7 years ago

    Unpivot the columns first, then append “-2019” to the month names, then convert them to dates

3 Replies

  • MattAllington's avatar
    MattAllington
    Community Champion
    7 years ago

    Unpivot the columns first, then append “-2019” to the month names, then convert them to dates

    • jure_rak's avatar
      jure_rak
      Helper I
      7 years ago

      Sorry for my ignorance, the append "-2019", how could I do it? Still in the editor, I presume, right?

    • jure_rak's avatar
      jure_rak
      Helper I
      7 years ago

      Got it, -> Add Columns, Format, Add Suffix