Hello, i have an excel input that returns multiple columns and multiple lines, i need to get the values of all lines from a specific column, but i don’t know how to do this. Can someone help me please?
1 Like
Hi @ViniciusCardoso .
There is a relatively new option which is “Read based on Column Name” which you could try. Name in field should be exactly the same as column name as a header in the Excel file.
If no column names are available, you can then read all columns and the remove the fields you do not wish to use in the flow with the Rename Field step.
Hope this helps
1 Like
Nice, thank you!
Now i have another question, is there a way to get the total lines from an excel input?
I need to save the total lines on a variable, like this:
1 Like
Hi! @ViniciusCardoso
You can use the Group By step after the Excel Input step. You can apply the COUNT aggregate function on any suitable column to get the number of lines in that column.
1 Like
