Joining tables in qlik sense

[Anonymous]

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.

[tamilarasu]

Hi Nicholas,

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

[effinty2112]

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