Icon

2024 -Week 1 - Prep Air's Flow Card

Problem At Preppin' Data we use a number of (mock) companies to look at the challenges they have with their data. For January, we're going tofocus on our own airline, Prep Air. The airline has introduced a new loyalty card called the Flow Card. We need to clean up a number ofdata sets to determine how well the card is doing. The first task is setting some context for later weeks by understanding how popular the Flow Card is. Our stakeholder would like two datasets about our passengers. One data set for card users and one data set for those who don't use the card. Importaing the fightdetails.csv throughcsv reader. Split the cell values from Flight details column using cell spliterdelimter => //remove the fligth details.Renaming the new columns date, filgthno, from and to desintation,price. changing the values in flow values column from 1 to yes & 0 to no. and convert the date column type fromstring to date type. Output Flight Details.csv Spliting the dataRenaming the columnspliting the data from desniationchanging the flowvalues0/1 to no and yesconvert string date column todate type spliting data based on flow varaible = Yes spliting data based on flow varaible = "No" CSV Reader Cell Splitter Column Renamer Cell Splitter Rule Engine String to Date&Time Row Filter Row Filter Problem At Preppin' Data we use a number of (mock) companies to look at the challenges they have with their data. For January, we're going tofocus on our own airline, Prep Air. The airline has introduced a new loyalty card called the Flow Card. We need to clean up a number ofdata sets to determine how well the card is doing. The first task is setting some context for later weeks by understanding how popular the Flow Card is. Our stakeholder would like two datasets about our passengers. One data set for card users and one data set for those who don't use the card. Importaing the fightdetails.csv throughcsv reader. Split the cell values from Flight details column using cell spliterdelimter => //remove the fligth details.Renaming the new columns date, filgthno, from and to desintation,price. changing the values in flow values column from 1 to yes & 0 to no. and convert the date column type fromstring to date type. Output Flight Details.csv Spliting the dataRenaming the columnspliting the data from desniationchanging the flowvalues0/1 to no and yesconvert string date column todate type spliting data based on flow varaible = Yes spliting data based on flow varaible = "No" CSV Reader Cell Splitter Column Renamer Cell Splitter Rule Engine String to Date&Time Row Filter Row Filter

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-09
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!