0

Sort and Filter a Modelled Data Source

Mica Phan

February 16, 2023 17:50

None

Follow

Hello, 

In a modelled data source, how would I:

1. Sort the entire table by date descending (not just the values in date column)
2. Filter the entire table by removing rows that has a Recipient Count is less than 10

So far, I can only do these functions on the column alone, not for the entire table. 

Thank you!

• Facebook
• Twitter
• LinkedIn

1 comment

• 
  Parker Selman February 16, 2023 20:16 Official comment

  Hi Mica, 
  
  Thanks for the post! 

  1. You'll need to insert a SORT function into each column in order to sort it in descending order. Specifically, for the date column, your function would looks like:

  SORT ( &Send Date , descending ) 

  Whereas all other columns would be set as: 

  SORT ( &Send Date, descending, &Column Name )

  2. In this case, each column will need to use a SELECT function where you include a condition such that recipient count is less than 10. For example:

  SELECT (&Mailing ID , &Recipient Count >= 10) 

  With all this in mind, the full function for the Mailing ID column, for example, would be:

  SORT( SELECT (&Send Date,  &Recipient Count >= 10) , descending , SELECT (&Mailing ID , &Recipient Count >= 10) )

  I hope this helps! Please let me know if you have any questions around this,

  Parker