Name is required.
Email address is required.
Invalid email address
Answer is required.
Exceeding max length of 5KB

Filtering table using dynamic dates

Is it possible to filter a table in a transformation job using a dynamic date e.g. -2days ago from the runtime?

I have tried putting "${dt.now().add("days", -2)}" into the value for the filter component but I get "Check properties for unmatched parenthesis, quotes or illegal characters"

Thanks,

1 Community Answers

Matillion Agent  

Damian Chan —

Hello Christopher,

You can try using a Python Component in an Orchestration job to set a variable with your desired date and then pass that variable into your Transformation job where you can then reference that variable.

Best Regards,
Damian

Post Your Community Answer

To add an answer please login