Skip to main content
Solved

Hi team is that possible to create a filter like this in an extraction filter statement? I need to create a filter that allows extracting the data of the last 15 days every time is running.

  • Feb 23, 2023 4:58 PM UTC
  • 2 replies
  • 139 views

andres.naran12
Level 8
Forum|alt.badge.img+10

image

Best answer by rio.cinco12

Hi, AFAIK - this is not possible, we have created workaround for this similar requirement. This might work for you. First create a table and every run you need to insert the latest date you need. and then create a parameter in extraction that reference the table.

 

image 

image 

Hope that helps,

Rio

View original

2 replies

Forum|alt.badge.img+14
  • Level 8
  • Answer
  • Feb 24, 2023 7:57 AM UTC

Hi, AFAIK - this is not possible, we have created workaround for this similar requirement. This might work for you. First create a table and every run you need to insert the latest date you need. and then create a parameter in extraction that reference the table.

 

image 

image 

Hope that helps,

Rio


andres.naran12
Level 8
Forum|alt.badge.img+10

Hi, AFAIK - this is not possible, we have created workaround for this similar requirement. This might work for you. First create a table and every run you need to insert the latest date you need. and then create a parameter in extraction that reference the table.

 

image 

image 

Hope that helps,

Rio

Thanks Rio!, I think this solution works.