https://community.qlik.com/t5/Talend-Studio/Added-data-field-to-every-row/m-p/2357078#M122459 <P>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.</P> Mon, 26 Jul 2021 19:39:56 GMT brama 2021-07-26T19:39:56Z https://community.qlik.com/t5/Talend-Studio/Added-data-field-to-every-row/m-p/2357077#M122458 <P>Hi, </P><P></P><P></P><P>Pretty new to Talend so sorry is this is a basic question.</P><P></P><P></P><P>I am extracting data from Salesforce using tSalesforceInput and then aim to load into Snowflake using tDBOutput. I will extracting the data daily. </P><P></P><P></P><P>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. </P><P></P><P></P><P>Is there a good way to do this?</P><P></P><P></P><P>Thanks</P><P>John</P> Fri, 15 Nov 2024 23:55:16 GMT https://community.qlik.com/t5/Talend-Studio/Added-data-field-to-every-row/m-p/2357077#M122458 JSlatorMHC 2024-11-15T23:55:16Z https://community.qlik.com/t5/Talend-Studio/Added-data-field-to-every-row/m-p/2357078#M122459 <P>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.</P> Mon, 26 Jul 2021 19:39:56 GMT https://community.qlik.com/t5/Talend-Studio/Added-data-field-to-every-row/m-p/2357078#M122459 brama 2021-07-26T19:39:56Z