cleansing data tool

Hi Community,

I have a table some are nulls and some are 0, I want to place null data with a dash - , as if replace the null with 0 will confuse with the original 0 data, but dash - is not numerical.

A table like this, fill blanks with dash and keep the 0.

Output

Accepted answers

All comments

ShankerV

Hi @Xiaorui

You can overcome the issue with the Multi field formula.

Like below is the example.

Many thanks

Shanker V

ShankerV

Hi @Xiaorui

I have mocked the data's to show how the output works.

Output:

Input:

Feel free to mark the solution of the post which helped to resolve the issue, so similar issues faced by other community members in future can be helpful to refer the solution.

Many thanks

Shanker V

binu_acs

@Xiaorui One way of doing this with the Multi-Field formula, the problem is all your data will be changed to string type

convert_to_string_011123.yxmd

Xiaorui

Hi Shanker,

Thanks for your answer, the thing is in this way the numerical data would change to Strings, but I need to keep them as numerical.

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703