How to rename and load dynamically changed number of the columns with the same name ?

[aidalj28]

Hello,

I have data like this:

I have multiple columns with the same name, and also the number of these columns changes every month. How can I load those columns and give them names like Column1, Column2..? Since I dont know how many such columns I have, I cannot explicitly write that. I think I should have loop over number of columns and then dynamically rename them.

Can someone help me?

Thanks!

[Dalton_Ruer · Accepted solution]

Consider doing a CROSS TABLE so that you end up creating a ROW for each country and month in your table and the value of the cell becomes a Value field. That way you can use the Month as a Dimension for things like line charts for trending and it would be flexible and handle 3 months or 30 months. 

See here for example: https://help.qlik.com/en-US/sense/February2021/Subsystems/Hub/Content/Sense_Hub/LoadData/work-with-c...