Hi. Please see table below. I want to move the information for parts c and d from Field 2 to Field 1, replacing the existing information. From To PartField 1Field 2 PartField 1Field 2agnull agnullbhnull bhnullciX cXxdjX dXxeknull eknullflnull flnull Field 2 is then no longer required. I'm sure its simple!! Thanks

Replacing specific cells

Hi.

Please see table below. I want to move the information for parts c and d from Field 2 to Field 1, replacing the existing information.

	From			To

Part	Field 1	Field 2	Part	Field 1	Field 2
a	g	null	a	g	null
b	h	null	b	h	null
c	i	X	c	X	x
d	j	X	d	X	x
e	k	null	e	k	null
f	l	null	f	l	null

Field 2 is then no longer required. I'm sure its simple!!

Thanks

Common Use Cases

Accepted answers

G_SAND

Thanks, the second option looks like the one for me but I can't get it to work. The 'null' is a null that Alteryx has entered so appears as [Null] in a grey font.

How can I get the formula to 'equal' this null value?

I tried replacing the [Null] with zeros but again I couldn't get the formula to = 0.

Can you help?

Sorry if this is confusing.

mborriero

Try it now. I did put a text "null" instead of an empty field.

ReplaceValue.yxmd

G_SAND

That's great, thanks

All comments

mborriero

Find attached a workbook with two examples.

1 - Replace the value of the field1 with field2 if part=c or part=d

2 -Replace the value of the field1 with field2 if field2=null

ReplaceValue.yxmd

G_SAND

Thanks, the second option looks like the one for me but I can't get it to work. The 'null' is a null that Alteryx has entered so appears as [Null] in a grey font.