Hi,
I have a requirement to read a QVD, then select certain fields to include, and certain fields to aggregate.
Then, on a reload with the variables selected, it should spit out a QVD with the selected fields aggregated at the chosen level.
The bit that I'm having trouble with, is generalising it such that any QVD loaded will have the requisite number of variables generated such that they can be selected.
Also, once I have the variables, is there a clean way to iterate through them? I don't want to have big nested if statements, nor lots of individual if statements.
Is such a thing possible?