I’m new to Knime. I’m sure it can do what I want, but I don’t know the tools/techniques that will get me there. Any tips are appreciated…
I have a google sheet with 4 columns (ID, Org, Start date, End date).
There can be multiple rows per ID - each row is the start and end of a member’s participation in an Org. A member can change Orgs more than once and sometimes be a part of two Orgs. (And there may be blank rows, which I could remove beforehand if necessary, but would be happy to handle in my workflow.) Sample data is below.
What I’d like to do is read through the rows and check per member (ID):
- Are there any gaps in participation? (End date does not match the following Start date for the same ID)
- Which members (IDs) are in more than one Org? (One ID has more than one Org without end dates.)
Basically, I need a method for reading through the list and looking at the date values within the same ID group and distinguishing among the Orgs within that group as well. Should I transpose? Should I do a self-join? A loop? Some other clever trick?
|ID|Org|Start date|End date|