Loading
Salesforce から送信されるメールは、承認済ドメインからのみとなります続きを読む

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

公開日: Apr 28, 2025
説明

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.
    解決策
    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.
    その他のリソース

     
    ナレッジ記事番号

    001474189

     
    読み込み中
    Salesforce Help | Article