Help with distinct values

How To
,
1

Hi,
I am fetching values from a google sheet. Some values are redundant. In my case they are

  • IBAN1
  • IBAN1
  • IBAN1
  • IBAN2
  • IBAN2

I want to use only the values IBAN1 and IBAN2 once, but I cannot solve this.

Really looking forward to reading from you,
Simon

2

Hi @Simon3

You can add all values to an array and use the duplicate function.

image
image467×186 10.5 KB

image
image193×117 1.87 KB

3

If the values are in different bundles, you can simply use an array aggregator and group by that columns value.

Hope this helps! Let me know if there are any further questions or issues.

— @samliew