Icon

Week3 - Targets for DSB

For the third week of beginner month, we're going to be building on the skills that we've already learnt, as well as exploring new concepts. This weekmay feel a little more challenging, but I promise you're ready for it!Data Source Bank has some quarterly targets for the value of transactions that are being performed in-person and online. It's our job to compare thetransactions to these target figures. Transactions.CSVTarget.csvSpliting the Transcation Code Renaming the new colmunsSelect the bank codechanging values of online and in person date changingconverting string to datechanging numeric to quarter Group by QuartersPivot rows and columns BANK ="DSB"convert quartersQ1 into numerics 1Joining two tablesfind the differencebetween target and actual CSV Reader CSV Reader Cell Splitter Column Renamer Column Filter Rule Engine String Manipulation String to Date&Time Extract Date&TimeFields GroupBy Unpivot Row Splitter Rule Engine Joiner Math Formula For the third week of beginner month, we're going to be building on the skills that we've already learnt, as well as exploring new concepts. This weekmay feel a little more challenging, but I promise you're ready for it!Data Source Bank has some quarterly targets for the value of transactions that are being performed in-person and online. It's our job to compare thetransactions to these target figures. Transactions.CSVTarget.csvSpliting the Transcation Code Renaming the new colmunsSelect the bank codechanging values of online and in person date changingconverting string to datechanging numeric to quarter Group by QuartersPivot rows and columns BANK ="DSB"convert quartersQ1 into numerics 1Joining two tablesfind the differencebetween target and actual CSV Reader CSV Reader Cell Splitter Column Renamer Column Filter Rule Engine String Manipulation String to Date&Time Extract Date&TimeFields GroupBy Unpivot Row Splitter Rule Engine Joiner Math Formula

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: GIRI PRASATH
Created at: 2024-02-13
On NodePit since: 2024-02-13
Last update: 2024-11-21
Created with KNIME version: v5.2.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!