Hi,
I'm interested in using Alteryx Designer to solve in extracting "specific text" and generate into a new column
as I'm very new here, I would like to ask for any suggestion, utilizing alteryx tools to accomplish this task. Here is the example of my text data:
Raw Text (Before Extracted) | Manufacturer (After Extracted) | Manucfacturer (Replace Duplicates) |
| METHOD : CERTIFICATE_REQUIREMENT : (IF ANY)_ | - | - |
| METHOD : CERTIFICATE_REQUIREMENT : (IF ANY)_ | - | - |
| METHOD : CERTIFICATE_REQUIREMENT : (IF ANY)_ | - | - |
| .... Description:_Manufacturer:_Manufacturer Part No:_Vendor/Supplier:… | - | - |
| Modifiers: Parts_HEADER CHARACTERISTICS_Manufacturer:_Classification/service:_... | - | - |
| ...Modifiers: Parts_HEADER CHARACTERISTICS_Manufacturer:_Classification/service:_... | - | - |
| Manufacturer: AB_Manufacturer Part Number: … | AB | AB |
| ...Modifiers: Parts_HEADER CHARACTERISTICS_Manufacturer:EB_Classification/service: … | EB | EB |
| Noun: Compressors_Modifiers: Parts_HEADER CHARACTERISTICS_Manufacturer: NANI_Classification/service: … | NANI | NANI |
| Noun: Compressors_Modifiers: Parts_HEADER CHARACTERISTICS_Manufacturer:_Classification/service: … | - | - |
| Classification/service: OFF GAS COMPRESSOR_Part Name : GASKET OILCOOLER:A... | - | - |
| Manufacturer: EQ_Part Name: GASKET NON-ASBESTOS_... | EQ | EQ |
| Manufacturer :MIK_Classification/service:OFF GAS COMPRESSOR_... | MIK | MIK |
| Manufacturer :HOR_Classification/service:OFF GAS COMPRESSOR_... | HOR | HOR |
| Manufacturer :MJU_Classification/service:OFF GAS COMPRESSOR_Vendor/Supplier :... | MJU | MJU |
| Noun: Compressors_Modifiers: Parts_HEADER CHARACTERISTICS_Manufacturer: ATL_Classification/service: ... | ATL | ATL |
| Manufacturer :ATL LIMITED_Manufacturer Part Number : 1613126813_Classification/service:DIAPHRAGM_... | ATL LIMITED | ATL |
| Noun: Compressors_Modifiers: Parts_HEADER CHARACTERISTICS_Manufacturer: TBW_Classification/service: REFRIGERATOR_Model:_... | TBW | TBW |
| Manufacturer :FACE_Classification/service:OIL FILTERS_Part Name : FILTER CARTRIDGE 15 MICRON_Part Number/Position Number :PP-614-D10B-NC_... | FACE | FACE |
| Manufacturer: GARL | GARL | GARL |
| Noun: Compressors_Modifiers: Parts_HEADER CHARACTERISTICS_Manufacturer: C-5400_Classification/service: … | C-5400 | C-5400 |
| Noun: Compressors_Modifiers: Parts_HEADER CHARACTERISTICS_Manufacturer: GARL 3000_Classification/service: … | GARL 3000 | GARL |
| Manufacturer: VIK_Manufacturer Part Number: … | VIK | VIK |
Highly Appreciate all coming suggestion,
Bordin W.
