EXCEL READER- TRANSFORMATION TAB- COLUMN SELECTION VARIABLE

Hi all!
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!

Hi @Mariaper

I think you are looking for the ColumnReference Splitter/Filter. See this example
reference_column_filter.knwf (28.3 KB)


gr. Hans

3 Likes

Thank you! yes! This was exactly what I was looking for!!!

2 Likes