Lookup and derive a dummy variable with lookup contents.

I want to iterate through a list of codes in a lookup file, and use the contents of each row of the code file as a lookup string in a string variable of a second input file, then generate a dummy (one-hot) variable for that code as a new variable for all rows in the second input file. How do I do that?

Hi @dataminer_1,

if I understood correctly, you want to label the input according to some lookup values?

image

In KNIME, this can be achieved with a simple joining operation as in the following workflow:

Hope this helps and let me know if this answers your question!
Cheers, Lukas

2 Likes

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