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.
Have you tried concatenating the tables by using the CONCATENATE (PrevTable) prefix?
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...