Created date and Modified date while updating tables

[Nandakishore]

hi ,

Iam using 'update,insert if new' kind of table updation in the workflow . the table contains created date and modified date columns . 

If the incoming line is new then created date need to be updated but not modified date , and for second time / so it need to update modified date but not created date . table has primary key . how this could be done in alteryx .

Thanks.

[DanielG]

@Nandakishore -- without knowing where your data actually lives (i.e. a SQL table versus a CSV file, as example) I created a simple concept of a process for you to look at.  Hope this helps.