TABLES:
MAPPING LOAD * INLINE [
ID,TABLE
1,Table1
2,Table2
3,Table3
4,Table4
5,Table5
];
FOR A = 1 TO 5
let vTable = ApplyMap('TABLES',$(A));
'$(vTable)':
LOAD *;
SQL SELECT * FROM $(vTable);
Store $(vTable) into into $(vTable).QVD;
DROP TABLE $(vTable);
NEXT
I feel one can easily look up to for more and more aspects of this because its very convenient to look at the aspects of Qlik and throw light on more database operations.
ReplyDeleteQlik Rest Api Connection