I have 10 tables in Db (Year wise transactional data). I would like to load the all the tables dynamically. I was successfully exicute this operation in Qlikview, but it's not possible to me it in sense . can yopu please help me out as soon as possible.
my Qv code is below:
SELECT TABLE_NAME FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_NAME Like 'T_20%' AND TABLE_CATALOG='ABC' ;
TABLES: Load TABLE_NAME as T_Name Resident TABLE_1 Where mid(TABLE_NAME,3,5) > Year(Today())-5;
DROP Table TABLE_1 ;
FOR EACH file in FieldValueList('T_Name')
T_Name: SQL SELECT * FROM ABC.dbo.$(file);
STORE T_Name INTO $(VQVD)'xyz_'$(file).qvd(qvd) ; DROP TABLE T_Name;
