topic Re: data loading in QlikView

data loading

sakamsureshbabu — Fri, 10 Oct 2014 06:50:21 GMT

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.

Re: data loading

phaneendra_kunc — Fri, 10 Oct 2014 06:56:48 GMT

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);

Re: data loading

sakamsureshbabu — Fri, 10 Oct 2014 07:02:00 GMT

thanks Mr Phaneendra

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

Re: data loading

jagan — Fri, 10 Oct 2014 07:03:59 GMT

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.

Re: data loading

phaneendra_kunc — Fri, 10 Oct 2014 07:04:19 GMT

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.

Re: data loading

salto — Fri, 10 Oct 2014 08:01:04 GMT

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.