Dynamic Column Name Filter in a Loop

Hi there,

I have a huge table wi more than 3000 columns. The most of the Column names are like this pattern.

Part1.Something_else.xyz

• The “Part1” can be fife different Abbreviations

• “Something_else” is alphanumeric String

• “xyz” is also an alphanumeric String

Using fife Column Filter Nodes for the “Part1” is easy but now the “Something_else” part has between 20 and 80 different String that I don’t want to create up to 80 Column Filter Nodes 🤭

Which kind of Loop do I have to configurate? I tried the Column List Loop Start Nodes but I don’t understand the Flow Variable configuration.

The pattern I have created with a Table Ro to Variable Node an String Manipulation (Variable) Node. Do I have to create the “type” variable as well let’s say “Wildcard” and caseSensitiv = 0?

Sorry for my confusion

Regards,

Brotfahrer