Icon

Contacts

Food and Pharma suppliers, person contacts, first file sent by Belarus office Kulfold suppliers, first file sent by Holimex Belfold suppliers, first file sent by Holimex Relevant columns Industry Website Owner Phone and fax List of Countries Country Phone and fax Owner Industry Website List of Industries (English) Company Name List of Company Names Company Country Company Type List of Titles List of Titles Company type Company Name, Country, Type, Website All fields All fields Company Name, Country, Type, Website CompanyName Duplicates Combining with existing contacts on Zendesk Combining with existing contacts on Zendesk Industry Person name*7 contacts wererandomly placed in 1of 2 industries Contacts from file folders, first files sent by Poland office Organise columns Owner Person contacts, first file of Czech Republic office Person name*several duplicateswere removed Company name Organise*it appears there isone companycontact Address Website Person name Company name Person phone Remarks Organise Person title Matching Intranet with Polish company contacts E-mail List of Titles List of Industries (English) Anuga Food Makers Anuga Food Supplier Anuga Food Maker Anuga Food Suppliers Anuga Food # Contacts without ownerRemoving irrelevantcolumnsFrom acronymto full nameAdd "+" toPhone and FaxRemove "-"Remove "/"Matching withtemplateNode 172Node 174Node 179Remove "-"Node 181Node 182Splitting contactswith severalownersNode 187Node 188Filtering out irrelevantcolumnsFrom acronymto full nameAdd "+" toPhone and FaxRemove commas Külföld Matching withtemplateRemove "/"Node 196Node 197Organise therow numberingRemove duplicatesFocus on clientsNode 203Node 204Contacts without ownerBelföldNode 220Node 222Node 223Remove commasNode 234Node 235Node 236Node 237Node 238Node 239Translate to EnglishNode 246Node 247Focus on clientsOrganise therow numberingRemove duplicatesRemove commasNode 252Node 253Fields for sampleNode 255Node 256Focus on clientsRemove duplicatesOrganise therow numberingNode 260Node 261Node 263Node 267Node 268Node 269Node 270Node 271Remove emailsNode 275Node 276Node 277Node 278Node 279Node 280Remove emailsRemove duplicatesOrganise therow numberingFocus on clientsRemove duplicatesFocus on clientsOrganise therow numberingFields for sampleNode 289Node 291Node 292Node 293Node 294Node 295Node 300Node 301Node 302Node 303Node 310Node 311Node 312Node 313Node 314Food Pharma FoodPharmaNode 364Node 366Node 368Node 369seedsUnilever-Bydgoszczdla zwierzątcukier,sóloleje spożporcelanachemia gosp.farmacja i kosmalkoholepasta do zębówuczelnieorganiz.,instyt.chem min -różnenapoje-paletyzacjaautomat.,masz.i innesosy,majon,dipy,musztarcoffee,teadodatki spoż.sojowe dried fruits&vegskrobia mięso wędlżelatynawarzywa,owocetytońróżne prod.spoż.Kanonpanierkapet foodRybyfirmy inż proj doradzpakowanie,opakow.farby,oleje,smaryconfe.;zioła przypr bakalie itpbrowarysweetsopakowaniaprzetwórstwo warzyw,owocówfrozen productsprod.żywności liofiliz.smarnabiał mleko w proszkuNode 435Node 436Node 437Node 438Node 439Node 440Node 441Node 442Node 443Node 444Node 445Node 446Node 447Node 448Node 449Node 450Node 451Node 452Node 453Node 454Node 455Node 456Node 457Node 458Node 459Node 460Node 461Node 462Node 463Node 464Node 465Node 466Node 467Node 468Node 469Node 470Node 471Node 472Node 473Node 474Node 475Node 476Addresses databaseand General database files*mix of leads and person contacts*mix of both (un)marked former employeesNode 478Node 479Node 481Node 486Node 487Node 488Node 489Node 490Node 492Node 493Node 494Node 496Node 497Node 498Node 499Node 500Node 501Node 502Node 503Node 504Node 505Node 506Node 507Node 508Node 509Node 510Node 511Node 512Node 513Node 514Node 515Node 516Node 517Node 518Node 519Node 520Node 521Node 522Node 523Node 524Node 525Node 526Node 527Node 528biogazownieCBD hempchemia budowlanachemia gospodarczachemia-bazacukierkoksownie, hutykopalnie surowców mineralnychlista uczestnikówloading armsNovasep różneolejeproducenci farbproducenci szkłaróżne produktytransport na wodórNode 545Node 546Node 547Node 548Node 549Node 550Node 551Node 553Node 554Node 555Node 556Node 557Node 558Node 560Node 561Chemistry file*mix of both(un)markedformer employeesNode 578Node 579Node 580Node 581Node 583Node 584Node 585Node 586Node 587Node 588Node 589Node 590Node 591Node 592Node 593Node 594Node 595Node 596Node 597Node 598Node 599Node 600Node 601Node 602Node 603Node 604Node 605Node 606Node 607Node 608Node 609Node 610Node 611Node 612Node 613Node 614Node 615Node 616Newsletters*match email with email from main datasetNode 619Node 620Node 621Node 622Node 623Node 624Node 625Node 626Node 627Node 628Node 629Node 630Node 631Node 632Node 633Node 634Node 635Node 636Node 637Node 638Node 639Node 640Node 641Node 642Node 643Node 644Node 645Node 646Node 647Node 648Node 649Node 650Node 651Node 652Node 653Node 654Node 655WebsiteE-mailNode 658Node 659Focus on clientsOrganise therow numberingRemove duplicatesNode 663Node 664Organise therow numberingFocus on clientsRemove duplicatesNode 668Node 669Node 670Node 672Node 673Node 674Node 675Node 676Node 677Node 678Node 679Node 680Node 681Node 682Node 683Node 684Node 686Node 687Node 688Node 689Node 690Node 691Node 693Node 694Node 695Node 696Node 697Node 698Node 699Node 700Missing Value Table Manipulator String Replace(Dictionary) String Manipulation(Multi Column) String Manipulation(Multi Column) String Manipulation(Multi Column) Table Manipulator String Manipulation Cell Splitter String Manipulation(Multi Column) String Manipulation(Multi Column) String Manipulation(Multi Column) String Manipulation(Multi Column) Cell Splitter Regex Split String Manipulation(Multi Column) Table Manipulator String Replace(Dictionary) String Manipulation(Multi Column) Cell Splitter CSV Reader Table Manipulator String Manipulation(Multi Column) Case Converter Column Filter RowID DuplicateRow Filter Column Filter String Replace(Dictionary) String Manipulation Missing Value CSV Reader Cell Splitter String Manipulation String Manipulation Cell Splitter String Manipulation(Multi Column) String Manipulation(Multi Column) Column Filter String Manipulation(Multi Column) Case Converter String Manipulation(Multi Column) Table Manipulator Cell Splitter Table Manipulator Column Filter RowID DuplicateRow Filter Cell Splitter String Replace(Dictionary) String Manipulation Table Manipulator ConstantValue Column Cell Splitter Column Filter DuplicateRow Filter RowID String Manipulation CSV Writer ConstantValue Column Rule Engine String Replace(Dictionary) GroupBy Row Filter String Manipulation Rule Engine Cell Splitter Column Filter Cell Splitter String Manipulation String Manipulation Column Filter Rule Engine DuplicateRow Filter RowID Column Filter DuplicateRow Filter Column Filter RowID Table Manipulator GroupBy CSV Writer Cell Splitter Missing Value String Manipulation CSV Reader RowID RowID ReferenceRow Filter CSV Reader Joiner Column Filter Rule Engine Column Filter CSV Writer CSV Reader CSV Reader ConstantValue Column ConstantValue Column Concatenate Table Manipulator RowID DuplicateRow Filter Excel Reader Excel Reader Excel Reader Excel Reader Excel Reader Excel Reader Excel Reader Excel Reader Excel Reader Excel Reader Excel Reader Excel Reader Excel Reader Excel Reader Excel Reader Excel Reader Excel Reader Excel Reader Excel Reader Excel Reader Excel Reader Excel Reader Excel Reader Excel Reader Excel Reader Excel Reader Excel Reader Excel Reader Excel Reader Excel Reader Excel Reader Excel Reader Excel Reader Excel Reader Excel Reader Excel Reader Excel Reader Excel Reader Excel Reader Excel Reader CSV Reader CSV Reader Table Manipulator Table Manipulator Table Manipulator Table Manipulator Table Manipulator Table Manipulator Table Manipulator Table Manipulator Table Manipulator Table Manipulator Table Manipulator Table Manipulator Table Manipulator Table Manipulator Table Manipulator Table Manipulator Table Manipulator Table Manipulator Table Manipulator Table Manipulator Table Manipulator Table Manipulator Table Manipulator Table Manipulator Table Manipulator Table Manipulator Table Manipulator Table Manipulator Table Manipulator Table Manipulator Table Manipulator Table Manipulator Table Manipulator Table Manipulator Table Manipulator Table Manipulator Table Manipulator Table Manipulator Table Manipulator Table Manipulator Table Manipulator Table Manipulator Concatenate Table Manipulator Excel Reader Table Manipulator ConstantValue Column ConstantValue Column ConstantValue Column ConstantValue Column ConstantValue Column ConstantValue Column ConstantValue Column ConstantValue Column ConstantValue Column ConstantValue Column ConstantValue Column ConstantValue Column ConstantValue Column ConstantValue Column ConstantValue Column ConstantValue Column ConstantValue Column ConstantValue Column ConstantValue Column ConstantValue Column ConstantValue Column ConstantValue Column ConstantValue Column ConstantValue Column ConstantValue Column ConstantValue Column ConstantValue Column ConstantValue Column ConstantValue Column ConstantValue Column ConstantValue Column ConstantValue Column ConstantValue Column ConstantValue Column ConstantValue Column ConstantValue Column ConstantValue Column ConstantValue Column ConstantValue Column ConstantValue Column ConstantValue Column Excel Reader Excel Reader Excel Reader Excel Reader Excel Reader Excel Reader Excel Reader Excel Reader Excel Reader Excel Reader Excel Reader Excel Reader Excel Reader Excel Reader Excel Reader Excel Reader ConstantValue Column ConstantValue Column ConstantValue Column ConstantValue Column ConstantValue Column ConstantValue Column ConstantValue Column ConstantValue Column ConstantValue Column ConstantValue Column ConstantValue Column ConstantValue Column ConstantValue Column ConstantValue Column Table Manipulator Concatenate Table Manipulator Table Manipulator Table Manipulator Table Manipulator Table Manipulator Table Manipulator Table Manipulator Table Manipulator Table Manipulator Table Manipulator Table Manipulator Table Manipulator Table Manipulator Table Manipulator Excel Reader Table Manipulator ConstantValue Column Excel Reader Table Manipulator Excel Reader Excel Reader Excel Reader Excel Reader Excel Reader Table Manipulator Table Manipulator Table Manipulator Table Manipulator Table Manipulator Excel Reader Table Manipulator String Manipulation ConstantValue Column ConstantValue Column ConstantValue Column ConstantValue Column ConstantValue Column ConstantValue Column Concatenate Column Aggregator String Manipulation Table Manipulator ConstantValue Column ConstantValue Column Excel Reader Table Manipulator Column Aggregator DuplicateRow Filter Cell Splitter Cell Splitter String Manipulation Column Aggregator Cell Splitter Cell Splitter Column Aggregator Table Manipulator String Manipulation String Manipulation Missing Value Rule Engine Column Aggregator String Manipulation String Manipulation Cell Splitter Cell Splitter Table Manipulator Table Manipulator Cell Splitter Table Manipulator Cell Splitter Column Filter Cell Splitter Cell Splitter Table Manipulator Column Aggregator Table Manipulator Column Filter Column Filter Remove Empty Rows Remove Empty Rows Column Filter RowID DuplicateRow Filter GroupBy GroupBy RowID Column Filter DuplicateRow Filter Column Filter Table Manipulator Row Filter String Manipulation Missing Value Row Filter ConstantValue Column Column Filter Column Filter Table Manipulator Row Filter Missing Value ConstantValue Column Table Manipulator Cell Splitter Missing Value Cell Splitter Table Manipulator Column Aggregator Concatenate Concatenate Excel Writer String Replacer Missing Value Missing Value String Replace(Dictionary) Row Filter String Replace(Dictionary) Row Filter Excel Writer Food and Pharma suppliers, person contacts, first file sent by Belarus office Kulfold suppliers, first file sent by Holimex Belfold suppliers, first file sent by Holimex Relevant columns Industry Website Owner Phone and fax List of Countries Country Phone and fax Owner Industry Website List of Industries (English) Company Name List of Company Names Company Country Company Type List of Titles List of Titles Company type Company Name, Country, Type, Website All fields All fields Company Name, Country, Type, Website CompanyName Duplicates Combining with existing contacts on Zendesk Combining with existing contacts on Zendesk Industry Person name*7 contacts wererandomly placed in 1of 2 industries Contacts from file folders, first files sent by Poland office Organise columns Owner Person contacts, first file of Czech Republic office Person name*several duplicateswere removed Company name Organise*it appears there isone companycontact Address Website Person name Company name Person phone Remarks Organise Person title Matching Intranet with Polish company contacts E-mail List of Titles List of Industries (English) Anuga Food Makers Anuga Food Supplier Anuga Food Maker Anuga Food Suppliers Anuga Food # Contacts without ownerRemoving irrelevantcolumnsFrom acronymto full nameAdd "+" toPhone and FaxRemove "-"Remove "/"Matching withtemplateNode 172Node 174Node 179Remove "-"Node 181Node 182Splitting contactswith severalownersNode 187Node 188Filtering out irrelevantcolumnsFrom acronymto full nameAdd "+" toPhone and FaxRemove commas Külföld Matching withtemplateRemove "/"Node 196Node 197Organise therow numberingRemove duplicatesFocus on clientsNode 203Node 204Contacts without ownerBelföldNode 220Node 222Node 223Remove commasNode 234Node 235Node 236Node 237Node 238Node 239Translate to EnglishNode 246Node 247Focus on clientsOrganise therow numberingRemove duplicatesRemove commasNode 252Node 253Fields for sampleNode 255Node 256Focus on clientsRemove duplicatesOrganise therow numberingNode 260Node 261Node 263Node 267Node 268Node 269Node 270Node 271Remove emailsNode 275Node 276Node 277Node 278Node 279Node 280Remove emailsRemove duplicatesOrganise therow numberingFocus on clientsRemove duplicatesFocus on clientsOrganise therow numberingFields for sampleNode 289Node 291Node 292Node 293Node 294Node 295Node 300Node 301Node 302Node 303Node 310Node 311Node 312Node 313Node 314Food Pharma FoodPharmaNode 364Node 366Node 368Node 369seedsUnilever-Bydgoszczdla zwierzątcukier,sóloleje spożporcelanachemia gosp.farmacja i kosmalkoholepasta do zębówuczelnieorganiz.,instyt.chem min -różnenapoje-paletyzacjaautomat.,masz.i innesosy,majon,dipy,musztarcoffee,teadodatki spoż.sojowe dried fruits&vegskrobia mięso wędlżelatynawarzywa,owocetytońróżne prod.spoż.Kanonpanierkapet foodRybyfirmy inż proj doradzpakowanie,opakow.farby,oleje,smaryconfe.;zioła przypr bakalie itpbrowarysweetsopakowaniaprzetwórstwo warzyw,owocówfrozen productsprod.żywności liofiliz.smarnabiał mleko w proszkuNode 435Node 436Node 437Node 438Node 439Node 440Node 441Node 442Node 443Node 444Node 445Node 446Node 447Node 448Node 449Node 450Node 451Node 452Node 453Node 454Node 455Node 456Node 457Node 458Node 459Node 460Node 461Node 462Node 463Node 464Node 465Node 466Node 467Node 468Node 469Node 470Node 471Node 472Node 473Node 474Node 475Node 476Addresses databaseand General database files*mix of leads and person contacts*mix of both (un)marked former employeesNode 478Node 479Node 481Node 486Node 487Node 488Node 489Node 490Node 492Node 493Node 494Node 496Node 497Node 498Node 499Node 500Node 501Node 502Node 503Node 504Node 505Node 506Node 507Node 508Node 509Node 510Node 511Node 512Node 513Node 514Node 515Node 516Node 517Node 518Node 519Node 520Node 521Node 522Node 523Node 524Node 525Node 526Node 527Node 528biogazownieCBD hempchemia budowlanachemia gospodarczachemia-bazacukierkoksownie, hutykopalnie surowców mineralnychlista uczestnikówloading armsNovasep różneolejeproducenci farbproducenci szkłaróżne produktytransport na wodórNode 545Node 546Node 547Node 548Node 549Node 550Node 551Node 553Node 554Node 555Node 556Node 557Node 558Node 560Node 561Chemistry file*mix of both(un)markedformer employeesNode 578Node 579Node 580Node 581Node 583Node 584Node 585Node 586Node 587Node 588Node 589Node 590Node 591Node 592Node 593Node 594Node 595Node 596Node 597Node 598Node 599Node 600Node 601Node 602Node 603Node 604Node 605Node 606Node 607Node 608Node 609Node 610Node 611Node 612Node 613Node 614Node 615Node 616Newsletters*match email with email from main datasetNode 619Node 620Node 621Node 622Node 623Node 624Node 625Node 626Node 627Node 628Node 629Node 630Node 631Node 632Node 633Node 634Node 635Node 636Node 637Node 638Node 639Node 640Node 641Node 642Node 643Node 644Node 645Node 646Node 647Node 648Node 649Node 650Node 651Node 652Node 653Node 654Node 655WebsiteE-mailNode 658Node 659Focus on clientsOrganise therow numberingRemove duplicatesNode 663Node 664Organise therow numberingFocus on clientsRemove duplicatesNode 668Node 669Node 670Node 672Node 673Node 674Node 675Node 676Node 677Node 678Node 679Node 680Node 681Node 682Node 683Node 684Node 686Node 687Node 688Node 689Node 690Node 691Node 693Node 694Node 695Node 696Node 697Node 698Node 699Node 700Missing Value Table Manipulator String Replace(Dictionary) String Manipulation(Multi Column) String Manipulation(Multi Column) String Manipulation(Multi Column) Table Manipulator String Manipulation Cell Splitter String Manipulation(Multi Column) String Manipulation(Multi Column) String Manipulation(Multi Column) String Manipulation(Multi Column) Cell Splitter Regex Split String Manipulation(Multi Column) Table Manipulator String Replace(Dictionary) String Manipulation(Multi Column) Cell Splitter CSV Reader Table Manipulator String Manipulation(Multi Column) Case Converter Column Filter RowID DuplicateRow Filter Column Filter String Replace(Dictionary) String Manipulation Missing Value CSV Reader Cell Splitter String Manipulation String Manipulation Cell Splitter String Manipulation(Multi Column) String Manipulation(Multi Column) Column Filter String Manipulation(Multi Column) Case Converter String Manipulation(Multi Column) Table Manipulator Cell Splitter Table Manipulator Column Filter RowID DuplicateRow Filter Cell Splitter String Replace(Dictionary) String Manipulation Table Manipulator ConstantValue Column Cell Splitter Column Filter DuplicateRow Filter RowID String Manipulation CSV Writer ConstantValue Column Rule Engine String Replace(Dictionary) GroupBy Row Filter String Manipulation Rule Engine Cell Splitter Column Filter Cell Splitter String Manipulation String Manipulation Column Filter Rule Engine DuplicateRow Filter RowID Column Filter DuplicateRow Filter Column Filter RowID Table Manipulator GroupBy CSV Writer Cell Splitter Missing Value String Manipulation CSV Reader RowID RowID ReferenceRow Filter CSV Reader Joiner Column Filter Rule Engine Column Filter CSV Writer CSV Reader CSV Reader ConstantValue Column ConstantValue Column Concatenate Table Manipulator RowID DuplicateRow Filter Excel Reader Excel Reader Excel Reader Excel Reader Excel Reader Excel Reader Excel Reader Excel Reader Excel Reader Excel Reader Excel Reader Excel Reader Excel Reader Excel Reader Excel Reader Excel Reader Excel Reader Excel Reader Excel Reader Excel Reader Excel Reader Excel Reader Excel Reader Excel Reader Excel Reader Excel Reader Excel Reader Excel Reader Excel Reader Excel Reader Excel Reader Excel Reader Excel Reader Excel Reader Excel Reader Excel Reader Excel Reader Excel Reader Excel Reader Excel Reader CSV Reader CSV Reader Table Manipulator Table Manipulator Table Manipulator Table Manipulator Table Manipulator Table Manipulator Table Manipulator Table Manipulator Table Manipulator Table Manipulator Table Manipulator Table Manipulator Table Manipulator Table Manipulator Table Manipulator Table Manipulator Table Manipulator Table Manipulator Table Manipulator Table Manipulator Table Manipulator Table Manipulator Table Manipulator Table Manipulator Table Manipulator Table Manipulator Table Manipulator Table Manipulator Table Manipulator Table Manipulator Table Manipulator Table Manipulator Table Manipulator Table Manipulator Table Manipulator Table Manipulator Table Manipulator Table Manipulator Table Manipulator Table Manipulator Table Manipulator Table Manipulator Concatenate Table Manipulator Excel Reader Table Manipulator ConstantValue Column ConstantValue Column ConstantValue Column ConstantValue Column ConstantValue Column ConstantValue Column ConstantValue Column ConstantValue Column ConstantValue Column ConstantValue Column ConstantValue Column ConstantValue Column ConstantValue Column ConstantValue Column ConstantValue Column ConstantValue Column ConstantValue Column ConstantValue Column ConstantValue Column ConstantValue Column ConstantValue Column ConstantValue Column ConstantValue Column ConstantValue Column ConstantValue Column ConstantValue Column ConstantValue Column ConstantValue Column ConstantValue Column ConstantValue Column ConstantValue Column ConstantValue Column ConstantValue Column ConstantValue Column ConstantValue Column ConstantValue Column ConstantValue Column ConstantValue Column ConstantValue Column ConstantValue Column ConstantValue Column Excel Reader Excel Reader Excel Reader Excel Reader Excel Reader Excel Reader Excel Reader Excel Reader Excel Reader Excel Reader Excel Reader Excel Reader Excel Reader Excel Reader Excel Reader Excel Reader ConstantValue Column ConstantValue Column ConstantValue Column ConstantValue Column ConstantValue Column ConstantValue Column ConstantValue Column ConstantValue Column ConstantValue Column ConstantValue Column ConstantValue Column ConstantValue Column ConstantValue Column ConstantValue Column Table Manipulator Concatenate Table Manipulator Table Manipulator Table Manipulator Table Manipulator Table Manipulator Table Manipulator Table Manipulator Table Manipulator Table Manipulator Table Manipulator Table Manipulator Table Manipulator Table Manipulator Table Manipulator Excel Reader Table Manipulator ConstantValue Column Excel Reader Table Manipulator Excel Reader Excel Reader Excel Reader Excel Reader Excel Reader Table Manipulator Table Manipulator Table Manipulator Table Manipulator Table Manipulator Excel Reader Table Manipulator String Manipulation ConstantValue Column ConstantValue Column ConstantValue Column ConstantValue Column ConstantValue Column ConstantValue Column Concatenate Column Aggregator String Manipulation Table Manipulator ConstantValue Column ConstantValue Column Excel Reader Table Manipulator Column Aggregator DuplicateRow Filter Cell Splitter Cell Splitter String Manipulation Column Aggregator Cell Splitter Cell Splitter Column Aggregator Table Manipulator String Manipulation String Manipulation Missing Value Rule Engine Column Aggregator String Manipulation String Manipulation Cell Splitter Cell Splitter Table Manipulator Table Manipulator Cell Splitter Table Manipulator Cell Splitter Column Filter Cell Splitter Cell Splitter Table Manipulator Column Aggregator Table Manipulator Column Filter Column Filter Remove Empty Rows Remove Empty Rows Column Filter RowID DuplicateRow Filter GroupBy GroupBy RowID Column Filter DuplicateRow Filter Column Filter Table Manipulator Row Filter String Manipulation Missing Value Row Filter ConstantValue Column Column Filter Column Filter Table Manipulator Row Filter Missing Value ConstantValue Column Table Manipulator Cell Splitter Missing Value Cell Splitter Table Manipulator Column Aggregator Concatenate Concatenate Excel Writer String Replacer Missing Value Missing Value String Replace(Dictionary) Row Filter String Replace(Dictionary) Row Filter Excel Writer

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: NadavGeron
Created at: 2022-03-09
On NodePit since: 2022-03-26
Last update: 2024-04-18
Created with KNIME version: v4.5.2

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

Try NodePit Runner!