Solution 1
• exclude rows where marital-status is missing.
• On the remaining rows:
• extract rows where marital-status = "Never-married"
• extract rows where marital-status = "Divorced" AND 20 <= age <= 40 AND workclass
starts with "S"
• remove column "marital-status
• keep only column "marital-status"
• keep only String columns using a Column Filter node and then only column "marital-status"
using a Reference Column Filter node
To use this workflow in KNIME, download it from the below URL and open it in KNIME:
Download WorkflowDeploy, schedule, execute, and monitor your KNIME workflows locally, in the cloud or on-premises – with our brand new NodePit Runner.
Try NodePit Runner!