load data

[sakamsureshbabu]

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.

[Agis-Kalogiannis]

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

[Gysbert_Wassenaar]

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