Add current date to new row

user046467 · November 2020

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 · November 2020

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 · November 2020

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

GrantSmith · November 2020

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

user046467 · November 2020

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.

Add current date to new row

Best Answer

Answers

Categories