Icon

Deals

etl Intranet Projects

etl Intranet Projects

There has been no description set for this workflow's metadata.

Owner *change based onoffice Value List of Clients List of Principals List of Branches List of Currencies Organising the table List of Owner and Office Slash duplicates Slash duplicates Combining with existing Intranet suppliers on Zendesk Blanks Date and time Stage Source Note Principal Deal name Testing how to match deals with company contacts 2018-2022 data (extracted on 09/03/22) Cancelled projects(2018-2022)Closed projects(2018-2022)Contract projects(2018-2022)Lost projects(2018-2022)Quotation projects(2018-2022)ClosedCancelledLostContractCombine all filesQuotationDeal nameDeal valueQuotedDeal note 3Expected contractdatesystem dateTime fieldsDeal source 1dateUnqualifiedDeal note 2Deal note 1Remove commasempty "-" stringsSet all empty strings to "-"Numerically order rowsEmpty "" strings for Expected contractRemove blank columnSwitch places of fieldsMake Jorrit ownerWonOrganise rownumbersRemove duplicatesFocus on clientsOrganise therow numberingNode 107Node 108Node 109Node 115Node 120Node 122Node 123Node 128Node 129Node 130Node 131Remove duplicatesFocus on clientsOrganise therow numberingNode 136Node 137Node 138Node 139Node 140Node 146Node 147Node 148Node 149Node 151Node 153Node 154Node 155Node 157Node 158Node 159Node 160Node 161Node 162Node 163Node 164Node 165QuotedCombine all files CSV Reader CSV Reader CSV Reader CSV Reader CSV Reader CSV Reader CSV Reader CSV Reader CSV Reader Concatenate CSV Reader Column Aggregator Column Aggregator String Replacer String Manipulation String Manipulation String to Date&Time ConstantValue Column String to Date&Time String Replacer Column Aggregator Missing Value Cell Splitter String Manipulation(Multi Column) Missing Value RowID String Manipulation(Multi Column) Column Filter Table Manipulator Missing Value String Replacer RowID DuplicateRow Filter Column Filter RowID DuplicateRow Filter Column Aggregator Ungroup DuplicateRow Filter DuplicateRow Filter Cell Splitter Column Filter Column Filter String Manipulation(Multi Column) Column Filter DuplicateRow Filter DuplicateRow Filter Column Filter RowID Cell Splitter Column Filter CSV Reader Joiner Row Filter Concatenate Column Filter Column Rename Column Filter GroupBy CSV Reader Joiner Column Filter DuplicateRow Filter RowID CSV Writer Table Manipulator Table Manipulator CSV Reader Joiner DuplicateRow Filter CSV Writer String Replacer Concatenate Owner *change based onoffice Value List of Clients List of Principals List of Branches List of Currencies Organising the table List of Owner and Office Slash duplicates Slash duplicates Combining with existing Intranet suppliers on Zendesk Blanks Date and time Stage Source Note Principal Deal name Testing how to match deals with company contacts 2018-2022 data (extracted on 09/03/22) Cancelled projects(2018-2022)Closed projects(2018-2022)Contract projects(2018-2022)Lost projects(2018-2022)Quotation projects(2018-2022)ClosedCancelledLostContractCombine all filesQuotationDeal nameDeal valueQuotedDeal note 3Expected contractdatesystem dateTime fieldsDeal source 1dateUnqualifiedDeal note 2Deal note 1Remove commasempty "-" stringsSet all empty strings to "-"Numerically order rowsEmpty "" strings for Expected contractRemove blank columnSwitch places of fieldsMake Jorrit ownerWonOrganise rownumbersRemove duplicatesFocus on clientsOrganise therow numberingNode 107Node 108Node 109Node 115Node 120Node 122Node 123Node 128Node 129Node 130Node 131Remove duplicatesFocus on clientsOrganise therow numberingNode 136Node 137Node 138Node 139Node 140Node 146Node 147Node 148Node 149Node 151Node 153Node 154Node 155Node 157Node 158Node 159Node 160Node 161Node 162Node 163Node 164Node 165QuotedCombine all files CSV Reader CSV Reader CSV Reader CSV Reader CSV Reader CSV Reader CSV Reader CSV Reader CSV Reader Concatenate CSV Reader Column Aggregator Column Aggregator String Replacer String Manipulation String Manipulation String to Date&Time ConstantValue Column String to Date&Time String Replacer Column Aggregator Missing Value Cell Splitter String Manipulation(Multi Column) Missing Value RowID String Manipulation(Multi Column) Column Filter Table Manipulator Missing Value String Replacer RowID DuplicateRow Filter Column Filter RowID DuplicateRow Filter Column Aggregator Ungroup DuplicateRow Filter DuplicateRow Filter Cell Splitter Column Filter Column Filter String Manipulation(Multi Column) Column Filter DuplicateRow Filter DuplicateRow Filter Column Filter RowID Cell Splitter Column Filter CSV Reader Joiner Row Filter Concatenate Column Filter Column Rename Column Filter GroupBy CSV Reader Joiner Column Filter DuplicateRow Filter RowID CSV Writer Table Manipulator Table Manipulator CSV Reader Joiner DuplicateRow Filter CSV Writer String Replacer Concatenate

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: JulioSantos
Created at: 2022-01-19
On NodePit since: 2022-03-26
Last update: 2024-04-27
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!