Searching for column names in the data from another column

[gonhaddock]

Hello @Startide

@Startide

Basically I want to search for dscpref_ces: dcsapp.url (and the others) in another column and display something when it matches (see the table a few comments up).

What you are describing here is a wildcard validation exercise. Please check the following topic for some insights:

Filter rows using list of words with wildcards

Hi, I have a file with about 2M rows and several columns. 1 column contains the description of items: e.g. “T-shirt made from recycled cotton”, or “laptop computer year 2019” or “salad bowl made from glass and iron”. I want to keep only rows that are of interest to me, so I created a list of “words to remove” and I want to remove all rows that contain 1 or more of these words. The item descriptions are very long and can differ slightly so I used “table creator” nodes where each row contains w…

BR