Icon

ETL_​homework

ETL Workflow 2 ETL Workflow 1 Data Input Data Transform Data Output Data Transform Data Input Data Output ETL Workflow 3 Data Transform Data Output Data Input Read AdventureWorks_Products.csv Fact CheckExtract Product Names and SubcategoriesCategorize forCategoryNameGroup CategoriesCategorize forProductCategoryKeyJoin them(ProductSubcategoryKey)Store Resultsin Outputs FolderStore results in Power BIWrite theResultConnectPHYO userand etlhomework dbSelect the Input FileAccessGoogle SheetConfigureGoogle APIExtract Product Names and SubcategoriesCategorize forProductCategoryKeyCategorize forCategoryNameJoin them(ProductSubcategoryKey)Group CategoriesProduct SubCategory KeyProduct KeyFact CheckRead Github RawAdventureWorks_Products.csvConnectPHYO userand etlhomework dbWrite theResultStore results in Power BIStore Resultsin Outputs FolderConnectPHYO userand etlhomework dbStore Resultsin Outputs FolderCategorize forCategoryNameGroup CategoriesCategorize forProductCategoryKeyStore results in Power BIWrite theResultJoin them(ProductSubcategoryKey)Extract Product Names and SubcategoriesCSV Reader CSV Reader GroupBy Rule Engine GroupBy Rule Engine Joiner (deprecated) CSV Writer MISSING Sendto Power BI DB Writer MySQL Connector Google SheetsReader Google SheetsConnection Google Authentication(API Key) GroupBy Rule Engine Rule Engine Joiner (deprecated) GroupBy String To Number Rule-basedRow Filter CSV Reader MySQL Connector DB Writer MISSING Sendto Power BI CSV Writer MySQL Connector CSV Writer Rule Engine GroupBy Rule Engine MISSING Sendto Power BI DB Writer Joiner (deprecated) GroupBy ETL Workflow 2 ETL Workflow 1 Data Input Data Transform Data Output Data Transform Data Input Data Output ETL Workflow 3 Data Transform Data Output Data Input Read AdventureWorks_Products.csv Fact CheckExtract Product Names and SubcategoriesCategorize forCategoryNameGroup CategoriesCategorize forProductCategoryKeyJoin them(ProductSubcategoryKey)Store Resultsin Outputs FolderStore results in Power BIWrite theResultConnectPHYO userand etlhomework dbSelect the Input FileAccessGoogle SheetConfigureGoogle APIExtract Product Names and SubcategoriesCategorize forProductCategoryKeyCategorize forCategoryNameJoin them(ProductSubcategoryKey)Group CategoriesProduct SubCategory KeyProduct KeyFact CheckRead Github RawAdventureWorks_Products.csvConnectPHYO userand etlhomework dbWrite theResultStore results in Power BIStore Resultsin Outputs FolderConnectPHYO userand etlhomework dbStore Resultsin Outputs FolderCategorize forCategoryNameGroup CategoriesCategorize forProductCategoryKeyStore results in Power BIWrite theResultJoin them(ProductSubcategoryKey)Extract Product Names and SubcategoriesCSV Reader CSV Reader GroupBy Rule Engine GroupBy Rule Engine Joiner (deprecated) CSV Writer MISSING Sendto Power BI DB Writer MySQL Connector Google SheetsReader Google SheetsConnection Google Authentication(API Key) GroupBy Rule Engine Rule Engine Joiner (deprecated) GroupBy String To Number Rule-basedRow Filter CSV Reader MySQL Connector DB Writer MISSING Sendto Power BI CSV Writer MySQL Connector CSV Writer Rule Engine GroupBy Rule Engine MISSING Sendto Power BI DB Writer Joiner (deprecated) GroupBy

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: edi
Created at: 2020-12-28
On NodePit since: 2021-01-16
Last update: 2024-11-17
Created with KNIME version: v4.4.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!