02-28-2024 08:29 AM - edited 02-28-2024 08:31 AM
Hi,
I have 2 input streams, i used inner join and fetched the matching data, also to capture the unmatched data i used- Unmatched data to error view option.
I am able to find the get the unmatched/additional records from the left path. How can i get the similar records of the right path.
Below is the input i used. Want to get unmatched record from input-2
Input-1
02-28-2024 08:47 AM
@kumar25 - I suggest you use Outer join type and use a Router to see which records matched based on missing key values
02-28-2024 10:58 PM
Thanks @koryknick
02-29-2024 04:49 AM - edited 03-01-2024 02:39 AM
Hi @kumar25 ,
If both input streams are array you can use below script which outputs all the unmatched object in $['input-2']
$['Input-2'].filter((a,b,c)=> ($['Input-1'].find((x,y,z)=> x['team'] == a['team']) || null) instanceof Null)
Thanks,
EmEm