data loading

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

[phaneendra_kunc]

If all of them are with same structure you can concatenate.. Usually if column names are same they will automatically concatenate.

Load empno, date, sales amount,qut from xyz.qvd (qvd);

Concatenate

Load empno, date, sales amount,qut from abc.qvd (qvd);

[sakamsureshbabu]

thanks Mr Phaneendra

u says first convert all branch data into qvd after Concatenate we using.

[jagan]

Hi,

Try like this

Data:

LOAD

*,

'Brach1' AS Branch

FROM Branch1;

Concatenate(Data)

LOAD

*,

'Brach2' AS Branch

FROM Branch2;

'

'

'

'

'

Concatenate(Data)

LOAD

*,

'Brach10' AS Branch

FROM Branch10;

Hope this helps you.

Regards,

Jagan.

[phaneendra_kunc]

You don't need to convert to qvd. If yours is a simple sql you can add this load statement and add concatenate for the second load.

[salto]

Hello,

as suggested before, concatenate all tables into one (which should be automatically done in the load script if all fields have the same name). That will avoid loops and synthetic keys.