Hi Hina,
you can use directory browser snap to get list of file and then use sort snap to to get latest file and then use pipeline execute snap and pass the value of file name to child pipeline.
Hi Ajay,
I am getting error in pipeline execute. The _Path is not getting passed. Also, if we have multiple file, will they be processed through pipeline one at a time(latest first and so on)?
Please see attached the child pipeline which gives error
child pipeline below and child pipeline error, 3rd pic is of parent pipeline and 4th pic is pipeline execute where variable _Path is set and called in child pipeline
!
Also another 2 questions i have is
a) i tried to put mapper in parent pipeline and define $ye as Date.now().toLocaleDateString(‘{“format”:“yyyyMMdd”}’)
and then tried to pass in directory “file filter” column as Labor_FDC_${ye}.dat but ye is not substituted with 202003. Please can you help here.
b)Another ques is once, file data is loaded in table, we want to enter filename in table so that it is not processed again and then delete from local folder. how can we implement this.
Thanks in advance
Hi hina,
can you please enable “=” button or expression.
and retry to validate.
in directory browser itself you can specify filter condition .
Regards,
Ajay
Thanks Ajay, but still the Path variable is not getting passed in child pipeline.I have trie dusing both _Path and Path varaible in child pipeline
This seems to indicate that Path is not listed as a parameter in the Pipeline Properties dialog.
Can you verify that it exists?
