Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
Use Concatenate keyword to merge all the data into one table.
or use Qualify statement
Thanks,
Singh
thanks Singh
concatenate is used for big size tables.
Not necessary for big size tables. In any case if the 2 tables with same columns, qlikview will automatically concatenate them into one.
Try using Qualify then.
Thanks,
Singh