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.

  • February 23, 2023
  • 2 replies
  • 24 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

2 replies

Forum|alt.badge.img+14
  • Level 8
  • Answer
  • February 24, 2023

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.