Skip to main content
Announcements
Introducing Qlik Answers: A plug-and-play, Generative AI powered RAG solution. READ ALL ABOUT IT!
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

tables in binaryload

Hi all,

How to join tables in Binary load ?

1 Solution

Accepted Solutions
Not applicable
Author

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;

View solution in original post

7 Replies
SergeyMak
Partner Ambassador
Partner Ambassador

Hi,

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

Just for example:

Left Join (Table1)

LOAD *

Resident Table2;

Regards,
Sergey
jagan
Luminary Alumni
Luminary Alumni

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.

Anonymous
Not applicable
Author

thanq all

Not applicable
Author

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;

Anonymous
Not applicable
Author

Thanks Bhawna gupta its working

jagan
Luminary Alumni
Luminary Alumni

Hi,

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

Regards,

Jagan.

Anonymous
Not applicable
Author

hi all above links are working

Thank you all