When I read a file with multiple columns, I want to select only some “mandatory” columns with information
So I have one excel reader where I can read the mandatory/ optional Columns:
Then I filter to select only the mandatory columns,
And I want this values as variables
The Idea now is read one file, but only select the mandatory columns
But I cannot see this option in flow variables in excel reader node
Do you know if this is possible?
I tried to do this using column filter, but I am not able to get the result that I want- one table with only the mandatory columns
I want to use this workflows for different files, and this is why I want to do this using variables, instead selecting the columns manually.
Thank you in advance!