topic Re: load data in Qlik Learning Discussions

load data

sakamsureshbabu — Fri, 10 Oct 2014 06:53:19 GMT

i have 10 branch data,each branch have below table structher .

emp no	date	sales amount	qut
a

now i want to load this 10 tables i get synthetic loops.

how i am load this data.

Re: load data

Agis-Kalogiannis — Fri, 10 Oct 2014 08:02:36 GMT

Have you tried concatenating the tables by using the CONCATENATE (PrevTable) prefix?

Re: load data

Gysbert_Wassenaar — Fri, 10 Oct 2014 08:06:38 GMT

Make sure your tables have exactly the same number of fields with exactly the same case-sensitive field names. Or use the Concatenate keyword to force concatenation of the source data into one table.

T1:

LOAD * FROM table1;

concatenate(T1)

LOAD * FROM table2;

etc...