Loading

Using ISNULL() In The Calculated Field To Apply Cleaning Process May Significantly Delay The Flow Preview Display in Tableau Prep

Date de publication: Apr 28, 2025
Description

Heavy use of ISNULL() in nested calculations of calculated fields to apply cleaning operations could cause significant delays in the flow preview display in Tableau Prep.
 

    User-added image

    Cause

    Filter by calculation is useful for filtering out certain characters or values, but replacing a fixed dummy value for every null value can be very "expensive". 
    When in interactive mode, the more ISNULL functions and IF statements you bring into Prep Builder, the more the flow will be computed. While there are no limitations on using functions in the Prep Builder, but there are considerations to optimize performance.
    Résolution
    Workaround:
    If the original data contains a large number of NULL values, please consider using a DB-side function (such as custom SQL) to replace the fixed dummy values before filtering the data.
    Ressources supplémentaires

     
    Numéro d’article de la base de connaissances

    001474189

     
    Chargement
    Salesforce Help | Article