Table Name | Set | Cumulative Set | Change | Added | Joining |
---|---|---|---|---|---|

Table 1 | A,B,C | A,B,C | TRUE | A,B,C | ? |

Table 2 | B,C,D | A,B,C,D | TRUE | D | B,C |

Table 3 | A,B,D | A,B,C,D | FALSE | ? | ? |

Table 4 | E,F | A,B,C,D,E,F | TRUE | E,F | ? |

Let’s say we were given Table Name, Set and we want to calculate: Cumulative Set, Change,Added and Joining. How would you go about that?

Cumulative Set adds anything to the SET that doesn’t exist.

Change is to measure if anything was added or not.

Added tells us what is added.

Joining tells us what is all the keys that exist in current set and previous cumulative set. (If Change is false this is null)

Why I ask I am not sure how programmatic global variables work in Knime.