Icon

TestWorkflow

In Database Processing & Storage (ELT mode and not ETL) Storage Reading the input fileInput file (in AWS Storage/locally)Assume local path if convenientCreate the staging table from CSV dataConnection to the DatabaseFilter for US recordsFilter for non-US recordsWrite to target table 1Write to target table 2Capture the file name into a columnGenerate current date & timestampas Last_Updated_dttmAssociate date time stamp with all the recordsKeep required columns onlyKeep required columns onlyCreate the measure ActiveCleanup column names CSV Reader Create File Name DB Writer Microsoft SQLServer Connector DB Row Filter DB Row Filter DB ConnectionTable Writer DB ConnectionTable Writer Variable toTable Column Create Date&TimeRange Cross Joiner DB Column Filter DB Column Filter DB Query DB Column Rename In Database Processing & Storage (ELT mode and not ETL) Storage Reading the input fileInput file (in AWS Storage/locally)Assume local path if convenientCreate the staging table from CSV dataConnection to the DatabaseFilter for US recordsFilter for non-US recordsWrite to target table 1Write to target table 2Capture the file name into a columnGenerate current date & timestampas Last_Updated_dttmAssociate date time stamp with all the recordsKeep required columns onlyKeep required columns onlyCreate the measure ActiveCleanup column names CSV Reader Create File Name DB Writer Microsoft SQLServer Connector DB Row Filter DB Row Filter DB ConnectionTable Writer DB ConnectionTable Writer Variable toTable Column Create Date&TimeRange Cross Joiner DB Column Filter DB Column Filter DB Query DB Column Rename

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: parth
Created at: 2020-06-05
On NodePit since: 2021-08-31
Last update: 2024-04-28
Created with KNIME version: v4.0.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!