Skip to content

    • Datasets

    Datasets

    Filtering dates in Magic ETL

    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

    • 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

    • 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"
    • Contributor

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

    Welcome!

    It looks like you're new here. Members get access to exclusive content, events, rewards, and more. Sign in or register to get started.
    Sign In

    Welcome!

    It looks like you're new here. Members get access to exclusive content, events, rewards, and more. Sign in or register to get started.
    Sign In

    Quick Links

    Categories