Filter column if column name starts with 1267038...

#1

Hi KNIMER,

I have an excel with a lot of different unecessary columns. Is there an opportunity to filter the columns that it shows me just the columns if they start with 1267038**

and by the way is there also en opportunity to read a .xlsb-file?

Thank you in advance

Br Alex :slight_smile:

0 Likes

#2

Hi @Alex1990

For the column filter use the Column Filter node and select the WildCard Regex Selection


And for the .xlsb file the Tika Parser node may do the job.

gr. Hans

3 Likes