How to convert the null value from the specific field.

[yosukewatanabe]

Hi,

I am attempting to converto Null value to specific fields value.
Though I had watched the discussion as following, I couldn't convert the field's data

https://community.alteryx.com/t5/Data-Preparation-Blending/Multi-Field-Tool-with-dynamic-fieldnames-...

What I'd like to do is to convert it to data in another field if particular field contains Null value.

For example, in the 2nd line of the table, convert the value of Field_4(null) into the value of r_Avg_Field_4.

Field_1	Field_2	Field_3	Field_4	Field_5	Field_6	r_Avg_Field_3	r_Avg_Field_4	r_Avg_Field_5	r_Avg_Field_6
T0000001	2017/1/1 0:01	80830	62311	623367	915	51662	51113	4639646	513
T0000002	2017/1/1 0:02	50517	[Null]	3731778	816	51662	51113	4639646	513
T0000003	2017/1/1 0:03	8972	77389	6925659	[Null]	51662	51113	4639646	513
T0000004	2017/1/1 0:04	71445	21157	[Null]	342	51662	51113	4639646	513
T0000005	2017/1/1 0:05	830	5178	8704327	596	51662	51113	4639646	513

[ThizViz]

What you are looking for can be accomplished with a formula tool, with this formula:

IF ISNULL([Col1]) THEN [Col2] ELSE [Col1] ENDIF

See if that works for you.

[jgo · Accepted solution]

Hi @yosukewatanabe,

Take a look at the attached workflow. It does require some transformation of the data table in order to create a dynamic process, but it's all put back together at the end.

Hope this helps!

Best,

Jimmy

[yosukewatanabe]

Thank you for your answer.

I had tried the workflow which you uploaded. And I could convert the null value to average value.

best regards,