Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Not applicable

Help with duplicate fields using joins

Hi guys,

I have two tables whrere am outer joining one with the other but the problem is it is giving a result like below where if a person belows to External it duplicates the record with an empty on but if they below to BSERVE then its fine

Source
BSERVE
INTERNAL

source IDITYPE
22External
22
34BSERVE
36BSERVE
37External
37

any ideas?

thanks

Community Browser