Answered

How to filter empty rows from an array?

(0) Share

Report

Posted on by carudev

Hi guys! 😄

I have these lines that I drew from a .csv and they always come with these " " empty at the end, and this is breaking my flow. Does anyone know how to filter or remove them?

Thank u!

Categories:

Building flows

I have the same question (0)

All responses (4)

Answers (1)

tom_riha 10,187 Most Valuable Professional on at

Like (1)

Report
Copy link

Link copied!
Hello @carudev ,

if it's always exactly 1 empty item in the array at the end, I'd use the take(...) expression to take from the array only lenght-1 number of items.

like this, but I'm not sure about the dynamic content format, you might need to replace it: take(outputs('Matriz_do_filtro'),sub(length(outputs('Matriz_do_filtro')),1))

Was this reply helpful? Yes No
Verified answer

carudev 98 on at

Like (7)

Report
Copy link

Link copied!

HI guys!
I found a very simple solution. I managed to solve it like this: using empty (item ()) is equal to false.
@equals(empty(item()), false)

Just look at the exits, It worked really well:
I hope this may help you guys, thanks! 😄

Was this reply helpful? Yes No
LoongWang on at

Like (0)

Report
Copy link

Link copied!

what's the format for rows?

Was this reply helpful? Yes No
Fabio_Levy 12 on at

Like (0)

Report
Copy link

Link copied!

The element she used is called "Filter Array" / "Matriz do Filtro" (in PT-BR).

It works quite well. Thanks!

Was this reply helpful? Yes No