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!)
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 :)