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.
Try Talend Cloud free for 30 days.
Introduction to Talend Open Studio for Data Integration.
Practical steps to developing your data integration strategy.
Create systems and workflow to manage clean data ingestion and data transformation.