How to get unique key values from json array?

[RafiNewman]

hi,

i have a json input that contains list of values that may repeat and i would like to parse it and build a list of unique keys. simple text , one key per row.

i don’t success to do it. can someone assist

this is a sample input:

{“result”:
[{“ident”:“key1”},{“ident”:“key1”},{“ident”:“key2”},{“ident”:“key3”},{“ident”:“key1”},{“ident”:“key3”},{“ident”:“key2”},{“ident”:“key1”},{“ident”:“key3”}],
“next_key”:1707052288}

the final result should be (order is not important):

key1
key2
key3

[RBalani]

Hey @RafiNewman, If you want to obtain unique values in text format separated by newline, you can achieve this by using the DISTINCT function in the iterator. For text formatting, use the TEXT AGGREGATOR and got to advance setting and select ‘Row Separator’ as ‘New Row’.

Your final output will be like this.

[RafiNewman]

thank you very much, it was very helpful