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 Budapest / Portland, OR 🟤
    Accepted 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

Answers