I have a requirement to parameterize the value of createdDate field of my tsalesforce input manual query.
The createdDate should be as below for different iteration:
1 iteration: createdDate >= systemdate and createdDate < (systemdate-2== ie 10th dec 2018-2 days = 8th dec 2018)
2 iteration : 8th dec 2018 -2 = 6th dec 2018 ie createdDate >= 8th dec 2018 and createdDate <6th dec 2018
Any suggestions to achieve this will be a great help.
Thanks in advance.
Talend named a Leader.
Kickstart your first data integration and ETL projects.
Watch the recorded webinar!
Learn how to do cool things with Context Variables
Find out how to migrate from one database to another using the Dynamic schema
Pick up some tips and tricks with Context Variables