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

tsplucky
tsplucky Member
in Magic ETL

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?

Tagged:

Best Answer

  • brycec
    brycec Contributor
    edited February 3 Answer ✓

    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().

    Was this comment helpful? Click Agree or Like below.
    Did this comment solve your problem? Accept it as the solution!

Answers

  • brycec
    brycec Contributor
    edited February 3 Answer ✓

    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().

    Was this comment helpful? Click Agree or Like below.
    Did this comment solve your problem? Accept it as the solution!

Categories