Skip to main content
Announcements
Qlik Community Office Hours, March 20th. Former Talend Community users, ask your questions live. SIGN UP
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Joining tables in qlik sense

I have such a hard time wrapping my mind around SQL and I don't know why...

So I have two tables with the same columns but different values. I want to join table1 with table2 on the column 'Country'.

As they are, table2 has all columns preceded by Sheet1-1. Ex. Sheet1-1.Country

It did that by default. Can you guys help please?

It's probably best to do resident joins.

2 Replies
tamilarasu
Champion
Champion

Hi Nicholas,

Could you post your script here? It will be helpful for us to provide you a better solution.

effinty2112
Master
Master

Hi Nicholas,

As Tamil said post some of your script and I'm sure you'll get some advice. Here's a question. If your two tables share the same fields then joining doesn't make much sense. Joining adds fields (columns) to a table. Concatenation, combining your tables row-wise, seems more natural in this case.

Cheers

Andrew