Hello Everyone,
My issue in short that I am trying to compare two multi-value tokens, get only "the unique ones" left and assign on a field. Here is the story;
I have two CSV files coming into a folder. I use pattern matching (\d{10}) to receive ten-digit numbers from these files. Each file can have a different amount of these 10 digit numbers. For example, the first file might have 30 numbers and the second file might have 50 and sometimes they can come with hundreds. Sometimes they have the same amount of numbers too. Also, sometimes these CSV files have the exact same numbers on different rows, randomly. I am trying to create a workflow that will read and process all these 10 digit numbers from both files, compare all of them, delete any number that repeats itself and leave only the unique ones. You can find my workflow picture in attachment. I was hoping that Remove Duplicates token would work but this token still leaves the first value. I am trying to delete all repetitive values including the first value itself and leave just the unique ones. I am not sure how to configure that part.
Here is an example picture of those 10 digit numbers. Numbers in red are repetitive and numbers in white are unique. All red has to be deleted and only white should left.
Please help me with my issue. Thank you very much!