Hi, I'm new and am looking for a solution to insert row information from a second table based on cell value.
I have a small table that needs additional columns PersonID and Home created and filled in. The values are in a large second table that may contain zero, one or more lines that match with the given email address. The Home column always contains the same value for each PersonID. For all persons that are not found in the second table, I would need to fill in the PersonID with a sequence number, from e.g. 99990000 onwards.
Would KNIME support this or would I be better off manipulating in Excel? Or create a database?
File table1:
Mail address |
company |
job |
CleanFast |
Cleaner |
|
CleanFast |
Super |
|
Care&Share |
Nurse |
File table2 (large file)
PersonID |
Mail address |
company |
job |
home |
1234 |
Lean&Clean |
Assistant |
London |
|
1234 |
WeCleanIt |
Super |
London |
|
6789 |
Coddle |
Nurse |
Cardiff |
Looked for result:
PersonID |
Mail address |
company |
job |
home |
1234 |
Cleanfast |
Cleaner |
London |
|
99990001 |
CleanFast |
Super |
|
|
6789 |
Care&Share |
Nurse |
Cardiff |