Cell replacer not working properly

[Karlygash]

Good Day Knimers

I m trying to use cell replacer node for lookup case and I found that the value does not change:

Output:

Configuration:

Lookup Table:

Can you help me to solve this issue

Thanks

[ipazin]

Hello @Karlygash,

that’s weird. Is there possibility you can share workflow?

Br,
Ivan

[Karlygash]

hi @ipazin
thanks for your reply, I found an error from source file itself
It has duplicates

How does cell replacer behave in such cases?

[ipazin]

Hello @Karlygash,

these things you can find in Node description:
“If there are duplicates in the lookup column in the dictionary table, the last occurrence (bottom most row) defines the replacement pair.”

Also you’ll get a warning in Console like:
WARN Cell Replacer 0:194 Duplicate search key "value"

You can use Duplicate Row Filter node to remove duplicates but that is only possible if there’s logic like leave always last or first entry. Without it you’ll have to do it manually.

Br,
Ivan

[Karlygash]

@ipazin thanks a lot