Hi, ive got a qlikview project that loads a table from a ODBC database, then that loaded table contains names of other tables.
So the main table is loaded on the report, after that the user chooses a table and does a partial reload, so the main table stays unchanged and he can now load any other sub table, my problem is, the user Loads subtable1, everything fine, when he now loads subtable 2 with different field names it will show subtable one and subtable2, what i want to do is Drop subtable1 when the user presses partial reload only.
My script is:
ODBC CONNECT TO QV (XUserId is ITJSCYdNTDdOGZVMTTLA, XPassword is MLbTHYVOODdeWTROTRFA);
Select * from qc_table;
Replace select * from $(var1);