Added data field to every row

[JSlatorMHC]

Hi,

Pretty new to Talend so sorry is this is a basic question.

I am extracting data from Salesforce using tSalesforceInput and then aim to load into Snowflake using tDBOutput. I will extracting the data daily.

Prior to loading into Snowflake i need to add a column and populate todays date into every row. This is so we can do some historical trend reporting.

Is there a good way to do this?

Thanks

John

[brama · Accepted solution]

Use tmap, add additional column with date datatype and then assign current date function in derivation of the field and send to output. Remember current date function here will return​ time in talend server.