Data cleansing issue (dynamic?)

[Pascal_R]

Hi Team,

I have the issue that certain column which are "blank" dont have a "0" which is needed for charts.

As you can see in attached screenshot I daily add a new column with data with the header as the actual date.

My issue is that the cleansing tool is not considering new added column the next day... is there a way to make it dynamic or anther workaround?

[JosephSerpis · Accepted solution]

Hi @Pascal_R you can use a multi-field tool to replace null or empty values with a 0 plus has the benefit of having the option of Dynamic or unkown fields so if tick that option and extra columns appear in your data it can account for this.