I have a table containing multiple columns, many of which the names do not change (are static). The table contains columns headed as month and year. These headings will change throughout the year, previous months will drop in the data and new months will be added.
Example data (my table actually contains a lot more fields):
|
Active Project?
|
Project Manager ID
|
Project Manager Name
|
Billable Project?
|
ID
|
Name
|
Priority
|
Feb-21
|
Mar-21
|
Apr-21
|
May-21
|
Jun-21
|
Jul-21
|
Aug-21
|
Sep-21
|
Oct-21
|
Nov-21
|
Dec-21
|
Jan-22
|
Feb-22
|
Mar-22
|
|
Yes
|
123456
|
Bloggs, Fred
|
Yes
|
904797
|
Project Name
|
SCP only
|
0.00
|
0.00
|
0.00
|
0.00
|
0.00
|
0.00
|
0.00
|
0.00
|
0.00
|
0.00
|
17.00
|
21.00
|
0.00
|
0.00
|
I would like to be able to load these "month-year" fields dynamically, in QlikView, so I don't have to amend the script every time old months are dropped and new months are added. Is this possible? Any help would be greatly appreciated. Thanks in advance.
