Icon

02_​ETL_​Basics-edited

Example Workflow for ETL Basics Operations
The goal of this workflow is to move from a series of contracts with different customers in different countries to a one-row summary description for eachone of the customers.For more information see the workflow metadata. Find it here: View -> Description Move from a series of contractsto a one-row summary for eachcustomer. Extract only some customers (combine OR and AND filters) sales records 2008-2011excludecolumn "card"For each customer:- total sum of amount- countries active in- customer since ...- time in days between first and last purchasefind which customersare active in which countrysort byascending dateinner join of original datawith aggregationson Cust_IDcountry = *Germany*country = *USA*1000 < sum(amount) < 2000sum(amount) > 5000write to CSV fileconvert dates from String to DateTime- append new columnNode 33 File Reader Column Filter GroupBy GroupBy Sorter Joiner Row Filter Row Filter Row Filter Row Filter Concatenate CSV Writer(deprecated) String to Date&Time Extract TableDimension The goal of this workflow is to move from a series of contracts with different customers in different countries to a one-row summary description for eachone of the customers.For more information see the workflow metadata. Find it here: View -> Description Move from a series of contractsto a one-row summary for eachcustomer. Extract only some customers (combine OR and AND filters) sales records 2008-2011excludecolumn "card"For each customer:- total sum of amount- countries active in- customer since ...- time in days between first and last purchasefind which customersare active in which countrysort byascending dateinner join of original datawith aggregationson Cust_IDcountry = *Germany*country = *USA*1000 < sum(amount) < 2000sum(amount) > 5000write to CSV fileconvert dates from String to DateTime- append new columnNode 33 File Reader Column Filter GroupBy GroupBy Sorter Joiner Row Filter Row Filter Row Filter Row Filter Concatenate CSV Writer(deprecated) String to Date&Time Extract TableDimension

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: rosy
Created at: 2017-01-31
On NodePit since: 2020-12-14
Last update: 2024-05-02
Created with KNIME version: v4.3.0
Tags: ETLKNIMEdata manipulation

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

Try NodePit Runner!