Skip to main content

I need to replace null values with 0 for 60+ fields, so to do it one by one is laborious and slows the flow considerably. A find-and-replace step that can apply to more than one field seems like it would be an intuitive feature--does anyone know if a more efficient method exists?

 

(Note: I understand that most discourage replacing nulls with 0 because of the additional space it takes and impact on speed/performance. However, there are several calculated fields in the Tableau workbook based on these fields where null values would not make sense, and I cannot display null values in the dashboards I am creating. If anyone knows a better solution to replacing nulls with 0s, I'm all ears!)

6 risposte
  1. 3 ago 2024, 05:57

    Hi @Nolan Miller​ ,

    No there is no such way where you can rename "null" across all fields when multiple are selected in prep.

    BUT

    You can try writing custom Python or R scripts if you have advanced scripting needs. I guess Tableau Prep will support scripting capabilities to automate the replacement of null values across multiple fields.

     

    Hope this helps you . You can Select it as best if you like my answer :)

0/9000