Icon

Gift Giving Time Difference Excel

Join 1st &2nd GiftsCalculate GapBetween 1st &2nd GiftsSet Empty 2nd GiftMonth = 0Produce Count of 2nd Gift MonthCount IDs w/ 2nd GiftClean FinalDataRemove IDs w/oSecond GiftCount All 1stGifts. No 2ndGifts = 0 If all IDsare included in 2ndGift table.Keeps Only 2nd Gift if Any(Assumes table is inchronological order for each ID.)Filter Timeframefor 1st Gift1st Gift2nd GiftJoiner Date&TimeDifference Missing Value GroupBy Bar Chart (Labs) Table Manipulator Row Filter Bar Chart (Labs) DuplicateRow Filter Date&Time-basedRow Filter Excel Reader Excel Reader Join 1st &2nd GiftsCalculate GapBetween 1st &2nd GiftsSet Empty 2nd GiftMonth = 0Produce Count of 2nd Gift MonthCount IDs w/ 2nd GiftClean FinalDataRemove IDs w/oSecond GiftCount All 1stGifts. No 2ndGifts = 0 If all IDsare included in 2ndGift table.Keeps Only 2nd Gift if Any(Assumes table is inchronological order for each ID.)Filter Timeframefor 1st Gift1st Gift2nd GiftJoiner Date&TimeDifference Missing Value GroupBy Bar Chart (Labs) Table Manipulator Row Filter Bar Chart (Labs) DuplicateRow Filter Date&Time-basedRow Filter Excel Reader Excel Reader

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: genef
Created at: 2023-03-23
On NodePit since: 2023-03-29
Last update: 2024-04-27
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!