Replace "0" by blank in .xlsx output

Hi,

I have a workflow with many 0 (= zeros), the data type for these columns are "Double".

I want to ouput my file in .xlsx (basic Excel format) but I want all the 0 replaced by a blank.
I want to keep the data type as a number and not a string.

Do you have and advice on how to do it?
And what would be the most efficient way if I have 150+ columns and many rows?

Thanks a lot for your help,

Best regards,

Axis

Output

Accepted answers

Emil_Kos

Hi @Axis,

Null with work for you?

Please check if this solution work as you expected:

The output:

Good Luck!

Null.yxmd

Emil_Kos

Hi @marcusblackhill,

good point with the multi field formula. I forgot that there are plenty of columns to work with.

I proposed using null option as I am not sure you can make double field blank.

All comments

Emil_Kos

Hi @Axis,

Null with work for you?

Please check if this solution work as you expected:

The output:

Good Luck!

Null.yxmd

marcusblackhill

Hey @Axis!

So, to you do that you just need to create a formula in formula tool like:

IIF([field]=0,"",[field])

That way will work for all rows of the field! Now, if you need to do it for many columns as well, you can use the multi-field formula tool, there you can point the columns you want to point the formula and even to select new unknown columns as well.

Hope that help!

Emil_Kos

Hi @marcusblackhill,

good point with the multi field formula. I forgot that there are plenty of columns to work with.

I proposed using null option as I am not sure you can make double field blank.

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15867

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703