Icon

Identification_​Test

Comp name + PC name + Alt namesin single columnMissing value ->"" Node 696ID_rowNode 732Node 1056Cleaning:* upperCase,*rename ("Unknown", "-")QuestionnaireCleaning(upper case, empty cells)Node 1078Parent Compif Comp is missingNode 1081Rows withcountriesSort bydecreasingdistanceRows withoutcountriesClosestManufacturerFacilityCountryRows withoutcountriesNode 1090Rows withoutcitiesRows withcountriesRows withcitiesClosestID Transitions(Manufacturer)ClosestManufacturerFacilityNameClosestManufacturerFacilityCountryClosestManufacturerFacilityCityDatabaseColumn Resorter Unpivoting Missing Value Column Filter Column Rename RowID Column Filter Column Rename String Manipulation(Multi Column) Table Creator String Manipulation(Multi Column) RowID Rule Engine Fuzzy AddressMatching Concatenate Missing Value Fuzzy AddressMatching Sorter ReferenceRow Filter Cell Replacer ReferenceRow Filter Column Filter ReferenceRow Filter Missing Value Missing Value Fuzzy AddressMatching Cell Replacer Cell Replacer Fuzzy AddressMatching Cell Replacer Cell Replacer Table Creator Comp name + PC name + Alt namesin single columnMissing value ->"" Node 696ID_rowNode 732Node 1056Cleaning:* upperCase,*rename ("Unknown", "-")QuestionnaireCleaning(upper case, empty cells)Node 1078Parent Compif Comp is missingNode 1081Rows withcountriesSort bydecreasingdistanceRows withoutcountriesClosestManufacturerFacilityCountryRows withoutcountriesNode 1090Rows withoutcitiesRows withcountriesRows withcitiesClosestID Transitions(Manufacturer)ClosestManufacturerFacilityNameClosestManufacturerFacilityCountryClosestManufacturerFacilityCityDatabaseColumn Resorter Unpivoting Missing Value Column Filter Column Rename RowID Column Filter Column Rename String Manipulation(Multi Column) Table Creator String Manipulation(Multi Column) RowID Rule Engine Fuzzy AddressMatching Concatenate Missing Value Fuzzy AddressMatching Sorter ReferenceRow Filter Cell Replacer ReferenceRow Filter Column Filter ReferenceRow Filter Missing Value Missing Value Fuzzy AddressMatching Cell Replacer Cell Replacer Fuzzy AddressMatching Cell Replacer Cell Replacer Table Creator

Nodes

Extensions

Links

Download

To use this workflow in KNIME, download it from the below URL and open it in KNIME:

Download Workflow
Created by: frederik.varlet
Created at: 2021-12-14
On NodePit since: 2022-02-06
Last update: 2024-04-27
Created with KNIME version: v4.5.0

Deploy, schedule, execute, and monitor your KNIME workflows locally, in the cloud or on-premises – with our brand new NodePit Runner.

Try NodePit Runner!