topic Re: Excel Having Same Tables And Same Fields in App Development

Excel Having Same Tables And Same Fields

Naresh1 — Wed, 05 Feb 2020 05:16:25 GMT

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,

Re: Excel Having Same Tables And Same Fields

Vegar — Wed, 05 Feb 2020 06:15:26 GMT

Try something like this.

For each _folder in 'Jan', 'Feb', ..., 'Dec'

//Autoconcatenate

Load FieldA, FieldB, FieldC

From [LIB://DATA/$(_folder)/*.xlsx];