Please help the new user,
I’m trying to find out the difference of addition of new options / deletion of options from the table.
Table.1 Represents the data of User ID , their designation and their roles.
According to designation Roles are represented.
Table .2 Represents data User ID, according to
KNIME.xlsx (14.8 KB)
user ID the Designations are given and Roles(numbers of roles assigned) are presented. Roles are detailed shows in Table 1.
Table.3 I want the output in table 3 format, In the Table 3 I want to get solution of, the difference of Role ID with each User ID(some users are same designations but assigned with additional or deletion or mismatched Role ID. I want to get the Difference/ Addition / Deletion/ Other.
I’m sharing the Excel sheet of it and Kindly hoping for the solution ASAP with workflow.
Thanks!