edit the data list - write industry information with word comparison

[ipazin]

Hi there @umutcankurt,

you can try following. Split your column using Cell Splitter based on space char. Each new column compare to sector description and if match found replace it with sector name, if no match replace it with missing value. Then use Column Aggregator on all those columns with Set aggregation method to eliminate duplicates. Follow it with Split Collection Column node and add proper names to your columns.

Also you can look at this topic for more ideas and try to adopt workflow from it:

row filter

I have 2 tables and each has one column, I want to filter out rows in the first table in which column value contains any value in column of the second table. Example: Table 1 Rowid Column 1 this is the first row 2 this is the second row 3 this is the third row … n this is the nth row Table 2 Rowid column 1 second 2 fifth my desired result will be without row 2, 5. any suggestions to handle this?…

Br,
Ivan