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?


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


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