Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
See why BI users voted Qlik #1 in 11 categories. GET REPORT
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
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
Highlighted
Master III
Master III

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;

Don't allow Perfection to be the enemy of Good Enough.
May you live in interesting times!
Highlighted
MVP & Luminary
MVP & Luminary

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

- Marcus

Highlighted
Not applicable

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.

Highlighted
Master II
Master II

Hi Giorgio,

Is the SQL query working in the Database?

Thanks,

Sangram.

Highlighted
Master III
Master III

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

Don't allow Perfection to be the enemy of Good Enough.
May you live in interesting times!
Highlighted
Not applicable

yes