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:

    https://www.youtube.com/watch?v=JNQFZCj8JcQ

    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"

Answers