How to look for duplicates in a bundle from a Array aggregator

How To
,
1

My goal is to take the data from an Array Aggregator [Structure type Json] output bundle and compare LineID field. If LineID fields all match, I want it to return a number 0 [Zero], if LineID fields do not all match, I want it to return a number 1.

I have tried many modules and filters - I cannot figure out how to get Make to look at the bundle then the field in each collection.

image
image348Ă—633 19.1 KB

Any help would be appreciated.

3

Hey!! Welcome to the Make community!!

You could aggregate the relevant LineId (or other fields as well and use this:

{{if(length(deduplicate(map(4.array; “lineId”))) = 1; 0; 1)}}

“lineId” has to be the raw name of the field

image
image800Ă—222 12.8 KB

image
image786Ă—1230 81.8 KB

image

AND

image
image580Ă—590 34.7 KB

image

Benjamin

1 Like
4

Hi Benjamin, Thank you for the assistance. I am going to try this out and see how it goes! Appreciate the help.

1 Like
5

Hey sorry I didn’t explain

  • it extract lineID in a new array
  • it removes all duplicates
  • if length of the new array is 1 it means all other lineIDs were duplicate (same value)
1 Like