Qlik Community

Qlik Education Discussions

Discussion Board for collaboration related to Qlik Education.

Highlighted
sakamsureshbabu
Contributor

load data

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

emp nodatesales amountqut
a

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

how i am load this data.

Tags (2)
2 Replies
Employee
Employee

Re: load data

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

MVP & Luminary
MVP & Luminary

Re: load data

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...


talk is cheap, supply exceeds demand