topic Re: tables in binaryload in QlikView

tables in binaryload

Anonymous — Tue, 18 Nov 2014 05:35:01 GMT

Hi all,

How to join tables in Binary load ?

Re: tables in binaryload

SergeyMak — Tue, 18 Nov 2014 05:39:11 GMT

Hi,

Just use the table names which you can see in original application.

Just for example:

Left Join (Table1)

LOAD *

Resident Table2;

Re: tables in binaryload

jagan — Tue, 18 Nov 2014 05:45:58 GMT

Hi,

Try like this

Binary DocumentName.qvw;

// Now write the load statements below

Left Join(AlreadyExistsTableNameInBinaryLoad)

LOAD

FROM NewTableName;

Hope this helps you.

Regards,

jagan.

Re: tables in binaryload

Anonymous — Tue, 18 Nov 2014 05:50:12 GMT

thanq all

Re: tables in binaryload

Tue, 18 Nov 2014 05:51:05 GMT

you can join by the name of the table name used in the binary loaded application...

eg:

suppose in original application table name is : Sales

and in second application

Order:

Load OrderId,

Orderdate,

qty;

join

load * resident Sales;

Re: tables in binaryload

Anonymous — Tue, 18 Nov 2014 06:07:50 GMT

Thanks Bhawna gupta its working

Re: tables in binaryload

jagan — Tue, 18 Nov 2014 06:11:52 GMT

Hi,

If you got the answer please close this thread by giving Correct and Helpful answers to the useful posts.

Regards,

Jagan.

Re: tables in binaryload

Anonymous — Tue, 18 Nov 2014 06:28:24 GMT

hi all above links are working

Thank you all