A quick question. How do you change the format of data in KNIME? I’ve done this in alteryx but not sure how to approach it in KNIME. For example my input is this:
I want each appointment and event attended (respectively) to count for “1” irrespective of the total. So even if a student has attended 5 events I want it to equate to “1” because we’re interested understanding the number of students who attended an event/appointment - not how many they attended in total.
Therefore, I want my output to be this:
You can use a RuleEngine node for this.
You can make a formula in the rule engine node:
$Appointment attended$ >=1 => 1
TRUE => 0
You can do the same for the events.
This is exactly what I’m looking for! But what if I have two columns and I want it to be that irrespective of the number of students who attended an “appointment” and “appointment drop-in” I want only to count for 1? Does that makes sense?
Well something like this:
$Appointment attended$ = 0 AND $Appointment drop-in$ =0 => 0
TRUE => 1
Could you upload an example of this scenario? I.e upload a sample Excel file with your data.
Thank you so much! This worked so well!
This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.