how to replicate the behaviour of .map() from Python in KNIME ?

KNIME Analytics Platform
1

Essentially, I have a working example of .map in python like the following:

image
image350×154 2.18 KB

Assume I have mapping_df and df as inputs already.

Thank you!

2

Hi,

without knowing exactly the structure of your tables I would say that the value lookup node is the right one.

Two input tables:

  • your table which is here named df as data table
  • the table called mapping df as dictionary

Lookup - Column from the Data Table: Column A
Key Column from the dictionary Table: Column B
Value Column from the dictionary table: Column C

3 Likes
4

Hey,

After further fiddling I understood what you meant. I needed to select that the Lookup column be replaced then it would provide me with a list of column to replace it with. Thanks for this it really made my workflow much much simpler.

2 Likes