topic Re: How to combine to LOAD together in QlikView

How to combine to LOAD together

sculptorlv — Wed, 25 Nov 2020 16:16:04 GMT

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

I have to SQL Tables.

SQL_Table_1:

SELECT

ID,

FROM XXXXX;

SQL_Table_2:

SELECT

ID,

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

Re: How to combine to LOAD together

prma7799 — Wed, 28 Feb 2018 11:50:28 GMT

ABC:

LOAD

A,B,C,ID

RESIDENT SQL_Table_1

LEFT JOIN (ABC)

XYZ:

LOAD

E,ID

RESIDENT SQL_Table_2

ABC:

LOAD

A,B,C,ID

RESIDENT SQL_Table_1

LEFT Keep (ABC)

XYZ:

LOAD

E,ID

RESIDENT SQL_Table_2

Re: How to combine to LOAD together

sculptorlv — Wed, 28 Feb 2018 11:54:20 GMT

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

Re: How to combine to LOAD together

prma7799 — Wed, 28 Feb 2018 12:29:41 GMT

What error your facing?

Re: How to combine to LOAD together

sculptorlv — Wed, 28 Feb 2018 12:32:11 GMT

Re: How to combine to LOAD together

prma7799 — Wed, 28 Feb 2018 12:34:31 GMT

after Agent_ID please close statement with ;(semicolon)

Re: How to combine to LOAD together

sculptorlv — Wed, 28 Feb 2018 12:36:49 GMT

I tried

Re: How to combine to LOAD together

prma7799 — Wed, 28 Feb 2018 12:40:03 GMT

Try this

TEST:

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

LOAD

Agent_ID,

......

Resident .......

Re: How to combine to LOAD together

sculptorlv — Wed, 28 Feb 2018 12:46:49 GMT

Much closer, but still something missing ..

Re: How to combine to LOAD together

prma7799 — Wed, 28 Feb 2018 12:55:18 GMT

TEST:

Left Join (Loda_budget_for_two_types)

LOAD // remove from here....

Agent_ID,

......

Resident .......

Re: How to combine to LOAD together

sculptorlv — Wed, 28 Feb 2018 12:59:04 GMT

not working

Re: How to combine to LOAD together

prma7799 — Wed, 28 Feb 2018 12:59:58 GMT

Again you missed LOAD keyword before Agent_ID

Re: How to combine to LOAD together

sculptorlv — Wed, 28 Feb 2018 13:11:00 GMT

Thank YOU VERY MUCH for your HELP and TIME!

Now it is working.