How to handle cross table for dynamic columns change
I have an excel file which gets updated with the latest months and future months data.
So when we move to next month, the future 12months data months will be updated as the column header in the excel.
So when we use the cross table in the script, we won't get the new future months updated as columns in the excel into the script to reload.
When we have data like this, when we move the next few months like 2019 Aug, 2019 Sep, 2019 Oct,.... and so on in the excel data. How do we handle this situation of getting the new columns (Months) into script in QlikView?