How do I add the current date to new rows that get appended by a recursive dataflow?

tsplucky

Hello, currently I have the standard recursive flow set up in the magic ETL, which tile and where in the recursive dataflow should I add to get the current date of when a new row gets added to the dataset?

brycec

You can use the Utility > Add formula tile to achieve this. Put it just before your append tile on the line coming from your new data. Name the column, something like snapshot date, then put the formula as CURRENT_DATE().