Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
I have 12 months folders, in every month folder having same tables and fields, i want to load all 12 months tables at a time into Qliksense, if it is not possible every month all tables will be load at a time, after loading tables i want only one table in data model
how can i do?
Regards,
Try something like this.
For each _folder in 'Jan', 'Feb', ..., 'Dec'
//Autoconcatenate
Load FieldA, FieldB, FieldC
From [LIB://DATA/$(_folder)/*.xlsx];
Next