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
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 |
Solved! Go to 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
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,