"Contains" or Partial Match lookup

Hellos,

I have a field which contains tonnes of Raw Material items such as 

7 Ply 4X4 Carton
36" Polybag
39" Polybag
Cow leather

I had like to categorise these items using a lookup table (excel/csv) , where I have can write down

Contains | Category
Carton  | Packaging
Polybag | Packaging
Cow | Raw Material
Sheet | Raw Material

• I believe this can be done using SQL lookup using LIKE , but that I am sure Team ETL will say is the slowest and should be avoided . 
• Maybe ,  this can also be done using Calculations , if I can read the content of a file & match , but Team ETL will say it's second slowest
• List can detailed with around 250+ items

 

250+ is a lot of items. 

I think the best option is to create a separate transformation for it 

Even if I create a transformation , how do I go about doing this?

I mean we will create a new transformation function for you 

 

FYI We have added two new transformations functions to the latest release

27/04/2024 6.4.2.34

 + Added: "Lookup RegEx" and "Lookup Contains" transformation functions   

www.etl-tools.com/wiki/advanced-etl-proc...ookups/lookup-regex/

www.etl-tools.com/wiki/advanced-etl-proc...ups/lookup-contains/