Add current date to new row


My input file is from Google sheets containing sales. But they don't have a datestamp.

I tried adding it with a constant in an ETL but the next day it overwrites all dates again with the current date. Is there a way to prevent this?


There should be an easy solution but I can't see it. Anyone who can help me?


Best Answer

  • jaeW_at_Onyx
    jaeW_at_Onyx Coach
    Answer ✓

    add current_date() as a column in your google sheet, then set up your connector to do an APPEND instead of a REPLACE.  (it's under the scheduling tab).  ... or do a recursive dataflow if you must ?


    More information about recursive dataflows than you ever wanted to know:

    Jae Wilson
    Check out my 🎥 Domo Training YouTube Channel 👨‍💻

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