Icon

justknimeit-21

Challenge_21_Eating_Out
#1 Find the top 10 participants spending the highest amount of money on eating. #2 Find out whether the people who spend the mostmoney on eating are the same people who spend themost time eating. Total Route --> Average Route --> #1 Find the top 10 participants spending the highest amount of money on eating. #2 Find out whether the people who spend the mostmoney on eating are the same people who spend themost time eating. Readeating out.csvamount_spent =starting balance- ending balanceFilter purpose: "Eating"spent >= 0Convert checkinto Date&TimeTime diff between checkin& checkoutTotalamount_spent& time_spentper participantIDSelect top10eating spendersMaximumtime_spenteatingFiltermaximumtime_spentInner Joinfor max time spent= 65minShow outputfor Criteria #1(replaceable withWriter Nodes)Descending OrderHighest (top)Show outputfor Criteria #2(replaceable withWriter Nodes)count ofparticipantappend countparticipantTotalamount_spent& time_spentper participantIDVLOOKUPcount participantCalculateArithmeticAverageRenameto total_*Maximumtime_spenteatingFiltermaximumtime_spentSelect top10eating spenderson averageInner Joinfor max time spent= 20min on averageDescending OrderHighest (top)Renameto average_*Show outputfor Criteria #1(replaceable withWriter Nodes)Show outputfor Criteria #2(replaceable withWriter Nodes)Renameto average_*Renameto total_* CSV Reader Math Formula Rule-basedRow Filter String to Date&Time Date&TimeDifference GroupBy Top k Selector GroupBy ReferenceRow Filter Joiner Table View Sorter Table View GroupBy Column Expressions GroupBy Cell Replacer Math Formula(Multi Column) Column Rename GroupBy ReferenceRow Filter Top k Selector Joiner Sorter Column Rename Table View Table View Column Rename Column Rename #1 Find the top 10 participants spending the highest amount of money on eating. #2 Find out whether the people who spend the mostmoney on eating are the same people who spend themost time eating. Total Route --> Average Route --> #1 Find the top 10 participants spending the highest amount of money on eating. #2 Find out whether the people who spend the mostmoney on eating are the same people who spend themost time eating. Readeating out.csvamount_spent =starting balance- ending balanceFilter purpose: "Eating"spent >= 0Convert checkinto Date&TimeTime diff between checkin& checkoutTotalamount_spent& time_spentper participantIDSelect top10eating spendersMaximumtime_spenteatingFiltermaximumtime_spentInner Joinfor max time spent= 65minShow outputfor Criteria #1(replaceable withWriter Nodes)Descending OrderHighest (top)Show outputfor Criteria #2(replaceable withWriter Nodes)count ofparticipantappend countparticipantTotalamount_spent& time_spentper participantIDVLOOKUPcount participantCalculateArithmeticAverageRenameto total_*Maximumtime_spenteatingFiltermaximumtime_spentSelect top10eating spenderson averageInner Joinfor max time spent= 20min on averageDescending OrderHighest (top)Renameto average_*Show outputfor Criteria #1(replaceable withWriter Nodes)Show outputfor Criteria #2(replaceable withWriter Nodes)Renameto average_*Renameto total_* CSV Reader Math Formula Rule-basedRow Filter String to Date&Time Date&TimeDifference GroupBy Top k Selector GroupBy ReferenceRow Filter Joiner Table View Sorter Table View GroupBy Column Expressions GroupBy Cell Replacer Math Formula(Multi Column) Column Rename GroupBy ReferenceRow Filter Top k Selector Joiner Sorter Column Rename Table View Table View Column Rename 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: UserID
Created at: 2022-06-18
On NodePit since: 2022-08-21
Last update: 2024-12-23
Created with KNIME version: v4.5.2
Tags: justknimeit-21

Deploy, schedule, execute, and monitor your KNIME workflows locally, in the cloud or on-premises – with our brand new NodePit Runner.

Try NodePit Runner!