Icon

Week1

Total Values of Transactions by each bankTotal Values of Transactions by each bank Total Values by Bank and Customer Code 2023: Week 1 The Data Source BankJanuary 04, 2023 Created by: Carl AllchinWelcome to a New Year of Preppin' Data. These are weekly exercises to help you learn and develop data preparation skills. Wepublish the challenges on a Wednesday and share a solution the following Tuesday. You can take the challenges whenever youwant and we love to see your solutions. With data preparation, there is never just one way to complete the tasks so sharing yoursolutions will help others learn too. Share on Twitter, LinkedIn, the Tableau Forums or wherever you want to too. Tag Jenny Martin,Tom Prowse or myself or just use the #PreppinData to share your solutions. The challenges are designed for learning Tableau Prep but we have a broad community who complete the challenges in R, Python,SQL, DBT, EasyMorph and many other tools. We love seeing people learn new tools so feel free to use whatever tools you want tocomplete the challenges. A New Year means we start afresh so January's challenges will be focused on beginners. We will use different techniques eachweek to help you develop your skills. In February, we will set the challenges at an intermediate level and then in March we will dosome advanced challenges. January's challenges will have links to useful videos and blogposts to help you learn a technique if it isnew to you. Total Values by Bank and Customer Code Data Source Bank.csvSpliting the transcation code.renaming thecolumn to bank code.selecting need columnBank code and total values values by bank and customer code changing values of online and in person Node 8converting string to datechanging numeric week to dayTotal values by bank and customers CSV Reader Cell Splitter Column Renamer Column Splitter GroupBy GroupBy Rule Engine String Manipulation String to Date&Time Extract Date&TimeFields GroupBy Total Values of Transactions by each bankTotal Values of Transactions by each bank Total Values by Bank and Customer Code 2023: Week 1 The Data Source BankJanuary 04, 2023 Created by: Carl AllchinWelcome to a New Year of Preppin' Data. These are weekly exercises to help you learn and develop data preparation skills. Wepublish the challenges on a Wednesday and share a solution the following Tuesday. You can take the challenges whenever youwant and we love to see your solutions. With data preparation, there is never just one way to complete the tasks so sharing yoursolutions will help others learn too. Share on Twitter, LinkedIn, the Tableau Forums or wherever you want to too. Tag Jenny Martin,Tom Prowse or myself or just use the #PreppinData to share your solutions. The challenges are designed for learning Tableau Prep but we have a broad community who complete the challenges in R, Python,SQL, DBT, EasyMorph and many other tools. We love seeing people learn new tools so feel free to use whatever tools you want tocomplete the challenges. A New Year means we start afresh so January's challenges will be focused on beginners. We will use different techniques eachweek to help you develop your skills. In February, we will set the challenges at an intermediate level and then in March we will dosome advanced challenges. January's challenges will have links to useful videos and blogposts to help you learn a technique if it isnew to you. Total Values by Bank and Customer Code Data Source Bank.csvSpliting the transcation code.renaming thecolumn to bank code.selecting need columnBank code and total values values by bank and customer code changing values of online and in person Node 8converting string to datechanging numeric week to dayTotal values by bank and customers CSV Reader Cell Splitter Column Renamer Column Splitter GroupBy GroupBy Rule Engine String Manipulation String to Date&Time Extract Date&TimeFields 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: GIRI PRASATH
Created at: 2024-02-08
On NodePit since: 2024-02-09
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!