โ03-13-2020 12:08 PM
I want to get all files from yesterdayโs date from ftp and process them one by one. There can be only one file and can be multiple files but they need to be processed one at a time. I tried using mapper , to get yesterday value โDate.now().toLocaleDateString(โ{โformatโ:โyyyyMMddโ}โ)โ
and then use file poller, and write in file filter Labor_FDC_${ye}*.dat,
but it doesnโt work. Also at the end after load, i want to update file name in target table that it is processed ,so that it is not processed again.
โ03-16-2020 03:05 PM
If i hardcode value in child pipeline it works, but variable doesnโt work. Please see attached screenshot, first is
child pipeline set parameter and second is reading variable from file reader in child pipeline . Can you please check if syntax is fine. Thanks in advance.
โ03-16-2020 03:26 PM
Pipeline parameters only take string values, not field references.
To test this child pipeline by itself, set the Value in the Edit Pipeline dialog to the path value like sftp://xxx.xx.x.xx/abc.dat
โ03-17-2020 10:55 AM
Thanks . working fine now.