Icon

ciullajn Date and Time and Database Custom Data

John CiullaExercise 5 Task 1: Convert a string column to Date&Time1. Read the travel advisories data by executing the provided CSV Reader node2. Convert the Accessed column in the travel advisory data from string to Date&Time NO DATA WITH DATE OR TIME PROVIDED Task 2: Extract year from timestamps1. Read the life expectancy data by executing the provided Excel Reader node2. Extract the year of accessing the data into a separate column NO DATA WITH DATE OR TIME PROVIDED Task 3: Manipulate data in databaseNOTHING TO JOIN TABLES ON3. Calculate the number of rows (countries) in the database table4. Filter the table to latitude above 05. Filter by City airports.csvNumber of CountriesLatitude above 0Group by City CSV Reader GroupBy Row Filter GroupBy John CiullaExercise 5 Task 1: Convert a string column to Date&Time1. Read the travel advisories data by executing the provided CSV Reader node2. Convert the Accessed column in the travel advisory data from string to Date&Time NO DATA WITH DATE OR TIME PROVIDED Task 2: Extract year from timestamps1. Read the life expectancy data by executing the provided Excel Reader node2. Extract the year of accessing the data into a separate column NO DATA WITH DATE OR TIME PROVIDED Task 3: Manipulate data in databaseNOTHING TO JOIN TABLES ON3. Calculate the number of rows (countries) in the database table4. Filter the table to latitude above 05. Filter by City airports.csvNumber of CountriesLatitude above 0Group by City CSV Reader GroupBy Row Filter 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: John
Created at: 2023-05-16
On NodePit since: 2023-05-17
Last update: 2024-11-21
Created with KNIME version: v4.7.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!