joining table based on where conditions

[Qlikuser09]

Joinoutput:

Load 

Field1, field 2 

resident [Table1]

Inner join 

Load 

field 3,

Field 4

resident [Table 2]

where field1=field3;

This is not working for me

[mato32188]

Hi @Qlikuser09 ,

try this one:

noconcatenate

Joinoutput:

Load 

Field1, field 2 

resident [Table1]

Inner join 

Load 

field 3 as field1,

Field 4

resident [Table 2];

br

m