Replacing Empty Column with specific word

[SH_94]

Hi Community,

I had encountered the following issue : Empty cell in certain row and my action plan as below:

1. Identify certain column whether it is empty

2. If empty , replace with the certain words as shown in the example screenshot below.

[JosephSerpis · Accepted solution]

Hi @SH_94 I mocked up and approach to tackle this challenge which uses the formula tool and multi-row tool to update the empty values. Let me know what you think?

[Emil_Kos · Accepted solution]

Hi @SH_94,

I have prepared a simple solution for you:

In order to make those numbers, I have used a record id. 

You can remove the data cleansing tool. I just wasn't sure how to make an empty column.

[SH_94]

Hi @ JosephSerpis,

Could you share with me the workflow version 2019.13? As i am not using the latest alteryx.

[Emil_Kos]

Hi @SH_94,

You need to make a small change in the notepad:

I have amended my workflow for you.

[JosephSerpis]

Hi @SH_94 I've downgraded the workflow and attached to this post. This article will explain how I adjusted the workflow.

[SH_94]

Hi @ JosephSerpis,

Thanks a lot Joseph . Yes this is what i want. However, could you please explain on each function on the screenshot below as i want to modify it to fit into my alteryx.

Thank you.

[SH_94]

Hi @ Emil_Kos,

Thanks a lot for your great information. The workflow is very helpful for me to understand the logic to build up. 

[JosephSerpis]

Hi @SH_94 I annotated the tools so should help you understand the logic.

[SH_94]

Hi @ JosephSerpis,

May i know how can i edit or delete the words in the annotation ?