How can I use data from excel a and Excel b ?

KNIME Extensions
1

Excel A (total 2 rows)
Department code , Department, Department phone, Department point of contact
01 insurance 888-11-1111 manager
02 vehicle 999-111-111 super manager

Excel B (600 rows)
employee name, employee id, employe department code
john 1111 01
peter 22333 02
parker 3333 01
jim 4444 02

I want to create ouput result in excel with employee name, employee id, eployee department code, department phone, department point of contact. How can use department code values from from excel a ?

2

… use a join:

-Philipp

1 Like
3

Thank you…! it worked.

4

yepp it works) thank u)

5

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