Missing Value

[Brain]

Hi,
I use Table View before to edit a report in PDF.
How to replace “?” by nothing to have an empty cell.

The column is Number and i do not want to change.
Thanks
Br

[tqAkshay95]

@Brain

You can use the missing value node to handle missing values.

It allows you to handle missing values in both string and number type columns.

Missing Value

[Brain]

I used Missing value. If I leave the column in “number” format, I can only replace it with a “value”, and what I want is an empty column without ?. If I transform the column to “String” format, I can replace the ? with an empty column, but the ones that contain numbers with decimals become numbers with interminable decimals again.

[tqAkshay95]

@Brain

I as per my Knowledge we can not number type missing value with empty.

You can set the fixed value to 0.

and consider a 0 value as a empty.