Forum Discussion

Annu2847_A's avatar
Annu2847_A
New Member
2 years ago

Changing Header Row Every Year

Each Year will get a new File with the New Year-Month as a header Row.    How to Unpivot the data.  Sample Data :   Key Jan-23 Feb-23 Mar-23 Apr-23 AA1 454 46 67 778 AA2 54 123 ...
Need Help
Annu2847_A's avatar
Annu2847_A
New Member
2 years ago

Thanks wdx223_Daniel / for the Response.   

The Above I have already tried but,  But I feel this doesn't work when another file comes in into  same dataset.  for another Year.  

If you see below i have exported 2 year of Data,  but even if i will make first row as header , In the Header Row will have year 2023,  But same will get unpivoted.   Even Year 2024 Data will get unpivoted with 2023 only.  

That's where i am facing the issue. in the same dataset every year , i have add the files, But Header Row has to be changed every year.   

 

 

JP_Wisco's avatar
JP_Wisco
Helper I
2 years ago

It looks like you are combining files from multiple years. You will want to apply the unpivot recommended by wdx223_Daniel to your sample transformation query. You can then hop back into your main query after the files are combined and repivot or transform however you need.