Replacing specific cells

[G_SAND]

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

[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

[G_SAND · Accepted solution]

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 · Accepted solution]

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

[G_SAND · Accepted solution]

That's great, thanks

[Ajayi29]

I have a similar problem: 

Source table

ID           Field 1                  Field 2                  Field 3

1234      0.25                      0.47                      0.78      

1235      0.36                      0.29                      1.29

1236      1.29                      1.68                      1.47

I want to correct my source table with an adjustment table (below) that contains the correct values for the fields in the table above.

Adjustment  table

ID           Field 1                  Field 2                  Field 3

1234      1.25                      2.47                      0.99      

1235      3.36                      2.29                      2.89

1236      1.29                      1.68                      1.47

I want to do this for over 80,000 rows.

Any thoughts, will be appreciated.