Hi All,
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;
NEXT file
DROP TABLE TABLES ;
Regards
Praveen
