Add current date to new row

user046467

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?

 

jaeW_at_Onyx

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

GrantSmith

Hi @user046467 

You'll want to look into a recursive dataflow where you can add the current timestamp when the dataflow runs (on Google Sheet update) and then append it to your output dataset.

 

ETL 2.0:

https://knowledge.domo.com/Prepare/DataFlow_Tips_and_Tricks/Creating_a_Recursive%2F%2FSnapshot_DataFlow_in_Magic_ETL_v2_(Beta)

 

ETL 1.0:

https://knowledge.domo.com/Prepare/DataFlow_Tips_and_Tricks/Creating_a_Recursive%2F%2FSnapshot_ETL_DataFlow 

 

 

jaeW_at_Onyx

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

GrantSmith

@jaeW_at_Onyx with the simpler option. I'd recommend his solution.

user046467

Thanks for your replies. I've to go for a recursive flow then.

As Google Sheets connector in Domo doesn't support append for whatever reason. Would've been much easier indeed.