0

Difference in Filters

In Model, what is the difference between filtering on a table node and with a filter node?

1. Filter on the Table node: 

 2. Filter node after the month:

2 replies

null
    • Senior Director of Product
    • Ian_Macdonald
    • 3 mths ago
    • Reported - view

    Hi  ,

    The filter  on the Table block is pushed down into the initial SQL query that retrieves data from the database, whereas the Filter block filters data as it is moving through the data flow, independently from the initial query.

    Hope that helps.

    Ian

      • Daniel_Van_Wyk
      • 3 mths ago
      • Reported - view

      Hi  , 

      Thank you. This makes sense. 

Content aside

  • Status Answered
  • 3 mths agoLast active
  • 2Replies
  • 35Views
  • 2 Following