Last tested: Jan 21, 2019
When you create an NDT (native derived table) that is
- based on an explore which is filtered by a field in a joined table from that explore
- filtered by a field in a different view than the NDT
the NDT will build as a nested with clause subquery, such as:
WITH NDT as (WITH filtered_table AS (select statement))
(SELECT from filtered_table)
SELECT from NDT
This is because the NDT relies on the explore (and all its joins and filters) from which it is sourced, and those tables must be built alongside the NDT for it to resolve.
This content is subject to limited support.