Import 2 Table and Join by only 1 field

[#1]

Hi,

i try to import two table in qlik from excel.

The 2 table have a lot of similar field/variables.  Like Name, Address.....

I want to join 2 tables only by ID_NUMEBER.

I 've also that problem when a itry to import 2 tables with the same structure but different data.

Qlik compact the 2 tables in 1.

Thank you

Marco

[nagaiank]

Try to use different field names for all fields except ID_NUMBER field.

Alternatively, add these lines before the LOAD in your script

QUALIFY *;

UNQUALIFY ID_NUMBER;