Filtering dates in Magic ETL

dr
dr Member
edited March 2023 in Datasets

Hi, 

I was wondering whether there's a way of using the filter in Magic ETL to filter the last two days. So essentially i have a huge table with dates since last year and I only want the rows that were added the last 2 days or the last week or so? Is there such a function or do I have to modify the field manually? 

Best Answer

  • Gimli
    Gimli Domo Employee
    Answer ✓

    Hello @dr,

    Sadly, this is something that we would not be able to do through magic ETL, currently. However, you can accomplish this in a SQL dataflow. If you would like help doing this you can email me at nolan.landefeld@domo.com and I can help you implement this. 

    **Say “Thanks" by clicking the thumbs up in the post that helped you.
    **Please mark the post that solves your problem by clicking on "Accept as Solution"

Answers

  • Gimli
    Gimli Domo Employee
    Answer ✓

    Hello @dr,

    Sadly, this is something that we would not be able to do through magic ETL, currently. However, you can accomplish this in a SQL dataflow. If you would like help doing this you can email me at nolan.landefeld@domo.com and I can help you implement this. 

    **Say “Thanks" by clicking the thumbs up in the post that helped you.
    **Please mark the post that solves your problem by clicking on "Accept as Solution"
  • kshah008
    kshah008 Contributor

    @dr, did ilikenno's reply help you out?