help

[userid128223]

Table A  -- Has mix of 3 & 6 digit zip codes

code	City
ABC123	Name1
ABD321	Name2
ABE	Name3
ABC	Name4
ABD	Name5

Table B   -- has all 6 digit

Code	City
ABC123	Name1
ABD323	Name7
ABE456	Name3
ABC784	Name4
ABD223	Name5

Need Solution:

I need to do inner join between A & B where first all 6 digit are matched once match are found you filter them from second inner join where match will be performed on first 3 digit code. final results will be combination of both matches.

[pamaxeed]

Refcode is the field created previously in the script (see first inner join part)...it is simply comparing this field with the code field of the current load statement and negate it if the condition is met.

Plz refer to the Qlikview Help...

Regards,

Patric

[userid128223]

thx. got it. appreciate your help.