I have 2 sources, so 2 fields with the name 'code'. I need to compare them so I added a 'flag' into the sources: 'Source 1' as Flag and 'source 2' as Flag.
I need to find the codes who only have 'source 1'. So they are missing in source 2.
All those codes have 2 sources in this example: source 1 and 2.
I only need the codes with source 1 (and not source 2).
load script example (basic):
load
code as 'check code'
Source 1 as Flag
From source 1
load
code as 'Check code'
Source 2 as Flag
From source 2
If I filter on dimension 'Flag' on 'source 1' and select a code, then I remove the filter 'source 1' (so only the code filter left), then there are 2 sources: source 1 and source 2.. Those are the codes I DON'T need..