Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
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

0 Replies