assigning IDs (from table) to persons

Dear KNIMErs,

I am still fighting with the use case I described in this post (split by regex)

Now I seem to have a different problem, let me explain:

I extended the list I used in the other question by an employee ID because this pretty much matches what my original file looks like:

The thing I need to achieve now is that in my example the first entry in the name column gets assigned the first Employee ID from column B.

The result should look like this:

I tried it with the Unpivot Node as described by @Kathrin in the original post and then created a helper column the String Manipulation Node to create a unique value I used then for duplicate deletion utilizing the Row Filter Node.

But somehow it doesn’t work for the Employee ID’s.

The basic “rule” I want to implement in KNIME is this:

  • the first name in column A gets assigned the first ID in column B
  • the second name in column A gets assigned the second ID in column B
  • the third name in column A gets assigned the third ID in column B

… and so on…

Thanks a lot in advance.

list-of-names_v2.xlsx (12.6 KB)

Good Morning @kowisoft,

I adjusted the workflow from your last post and added a new branch for the Employee ID.

I also fixed a little inconsistency in your data table and removed the space between the “,” and “Vader” in row 3, so that your previously introduced rule for the names applies.

Please let me know in case of any questions :slight_smile:
Kathrin

7 Likes

This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.