Hello KNIMErs, My input data is simple: ID and input columns. Input column contains strings separated with ‘/’. Number of separators varies between rows and input datasets. Strings ‘abc’ and ‘xyz’ should be treated as predefined list of important strings and the list should be easy to identify and update in the workflow. Outcome should be the new column with one of four entries: ABC for input containing one or more ‘abc’ XYZ for input containing one or more ‘xyz’ ABC, XYZ for input containing one or more ‘abc’ and one or more ‘xyz’ empty field for other cases. This is sample dataset containing input and output data: ID Input Expected output 1a dhj / xyz / fri XYZ 2b akr / sdj 3c fre 4d jft / kyo / xyz / ccc XYZ 5e lws / abc / djf / mew / yqa ABC 6f ugh / xyz / abc ABC, XYZ I’ve thought this should be quite easy to do, however I’m still searching for a solution. So far, I’ve tried loop, string manipulation (multiple column), cell splitter with no success. Would you be able to support? Thank you in advance, Kaz

Check content and apend column

ipazin July 6, 2023, 1:32pm 4

you can make use of Subset Matcher node. Take a look here:

Br,
Ivan

1 Like