Icon

02_​ETL_​Basics

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 toa one-row summary description for each one of the customers.For more information see the workflow metadata. Find it here: View -> Description Move from a series ofcontracts to a one-rowsummary for eachcustomer. Extract only some customers 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 DateTimeformat dd.MM.yyyy File Reader Column Filter GroupBy GroupBy Sorter Joiner Row Filter Row Filter Row Filter Row Filter Concatenate CSV Writer String to Date&Time The goal of this workflow is to move from a series of contracts with different customers in different countries toa one-row summary description for each one of the customers.For more information see the workflow metadata. Find it here: View -> Description Move from a series ofcontracts to a one-rowsummary for eachcustomer. Extract only some customers 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 DateTimeformat dd.MM.yyyy File Reader Column Filter GroupBy GroupBy Sorter Joiner Row Filter Row Filter Row Filter Row Filter Concatenate CSV Writer String to Date&Time

Nodes

Extensions

Links