Hi,
I have a number of Tables, let call them:
Each of these tables has different columns but they do all share a common key called pkey(inventive I know).
So I want to populate the columns in a TableBox depending on which TableName I've selected from a list.
Obviously i'm using vbscript to try and do this, I've seen a number of example with dynamic expressions and dimensions but nothing with dynamic tables and columns.
My problems are(one of my many):
- If I have the Table name in a var can I extract a list of it's columns. So Table1.A, Table1.B, Table1.pkey?
- Is a table in qlik an object type in the model? If so can I load it using a variable name
Cheers
Jamie
