Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
sculptorlv
Creator III
Creator III

How to combine to LOAD together

I am looking syntax like LEFT JOIN for SQL queries...

I have to SQL Tables.

SQL_Table_1:

     SELECT

         ID,

          A,

          B,

          C

     FROM XXXXX;

SQL_Table_2:

     SELECT

         ID,

          E

     FROM YYYYY;

I need to get LOAD query from two RESIDENT tables: SQL_Table_1 and SQL_Table_2, in order to get: ID, A, B, C, E

Something like:

     LOAD

          A,B,C,ID

     RESIDENT SQL_Table_1

     LEFT JOIN

      LOAD

          E,ID

     RESIDENT SQL_Table_2

    

I can easily connect tables in SQL queries, but how can I do it in LOAD queries

1 Solution

Accepted Solutions
prma7799
Master III
Master III

Again you missed LOAD keyword before Agent_ID

View solution in original post

12 Replies
prma7799
Master III
Master III

ABC:    

LOAD

          A,B,C,ID

     RESIDENT SQL_Table_1

     LEFT JOIN (ABC)

XYZ:

      LOAD

          E,ID

     RESIDENT SQL_Table_2

or

ABC:    

LOAD

          A,B,C,ID

     RESIDENT SQL_Table_1

     LEFT Keep (ABC)

XYZ:

      LOAD

          E,ID

     RESIDENT SQL_Table_2

sculptorlv
Creator III
Creator III
Author

I have syntax error on LEFT JOIN or LEFT KEEP sentence after the first part

prma7799
Master III
Master III

What error your facing?

sculptorlv
Creator III
Creator III
Author

mistake.jpg

prma7799
Master III
Master III

after Agent_ID please close statement with ;(semicolon)

sculptorlv
Creator III
Creator III
Author

I tried

mistake.jpg

prma7799
Master III
Master III

Try this

TEST:

Left Join (.............)

LOAD

Agent_ID,

......

Resident .......

sculptorlv
Creator III
Creator III
Author

Much closer, but still something missing ..mistake.jpg

prma7799
Master III
Master III

TEST:

Left Join (Loda_budget_for_two_types)

LOAD  // remove from here....

Agent_ID,

......

Resident .......