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?