Verification of cell replacer

[Jeff]

Hi,

Trying to learn how to use cell replacer node.

Let’s assume t1 is:
c1
a
b
ccc

Let’s assume t2 is:
c1 c2
ccc c

Using cell replacer I configure it as:
Target: c1
Input: c1
Output: c2
Append new column: unchecked
Input: checked

When executes it results in t1:
c1
a
b
c

Just as I expect… now let’s expand a bit.

Let’s assume t1:
c1 c2
a 1
b 2
c 999

t2:
c1 c2
a 1
b 2
c 3

What I need to do is replace the 999 with the value of 3.

Can cell replacer node do this?

Thanks,
Jeff

[ScottF]

Hi @Jeff -

Moving this to the main Analytics Platform forum for better visibility.

[ScottF]

And in this case, I think I would use a Joiner node on the c1 fields, then a subsequent Rule Engine node to deal with updating the “999” values.

[ipazin]

Hi there @Jeff,

and what about option Append new column followed by Column Filter to remove c2 column?

Br,
Ivan