Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Not applicable

Join

Hy,

i have a problem with a 'inner join' from two table,

my script looks like this:

LOAD * ;

SQL SELECT *

FROM PANTH01.THIP.ORD_SRV

inner join (ORD_SVR_ATV) SELECT * FROM PANTH01.THIP.ORD_SRV_ATV

ON (ORD_SRV.ID_AZIENDA = ORD_SRV_ATV.ID_AZIENDA)

AND (ORD_SRV.N_AZIENDA = ORD_SRV_ATV.N_AZIENDA);

6 Replies
oknotsen
Honored Contributor III

Re: Join

I would suggest to load both tables one-by-one into Qlik. On the 2nd table you call for an INNER JOIN.

TableOne:

LOAD * ;

SQL SELECT *

FROM PANTH01.THIP.ORD_SRV;

TableTwo:

INNER JOIN(TableOne)

LOAD * ;

SQL SELECT *

FROM PANTH01.THIP.ORD_SRV_ATV;

May you live in interesting times!

Re: Join

Is this an alerady existing sql-query which worked within the database or a new one? What are the problems?

- Marcus

Not applicable

Re: Join

thank you,

but I've already tried that and the resulting table is empty.

so I simulated the same command with two conditions in sql and I have a populated table.

reddys310
Honored Contributor II

Re: Join

Hi Giorgio,

Is the SQL query working in the Database?

Thanks,

Sangram.

oknotsen
Honored Contributor III

Re: Join

Do the key fields have (exactly) the same name? Keeping Case Sensitivity in mind.

May you live in interesting times!
Not applicable

Re: Join

yes