Hello Community,
I would like to query in a flow how many different values are in a column in excel.
Is there a function via "Filter Array" and "Compose" to give me the number of different values in a column?
Thanks in advance.
Many greetings
Patrick
Hi @PatrickSched ,
I made a sample for you.
[
{
"1": 2
},
{
"2": 2
},
{
"3": 2
},
{
"4": 1
},
{
"5": 1
}
]
Best Regards,
Wearsky
I have "I" numbers in the template. Some occur several times, some not at all or only once or twice. I would like to query how many different values occur in the column "I".
Michael E. Gernaey
497
Super User 2025 Season 2
David_MA
436
Super User 2025 Season 2
Riyaz_riz11
244
Super User 2025 Season 2