Pipeline To Output one File per Date
I need to get Distinct update_dt and write one file per date from a oracle table sufixing the filename with date value. can you provide a sample pipeline which has similar functionality
I have crea...
Forum Discussion
Hey welcome to the community, GV2019.
I’d recommend that you consider using a PipeExec instead of the deprecated ForEach snap. The basic idea is to have a pipe parameter that is passed into your second pipeline, which can be used for setting the file name. The document will also be passed in, which can be used to do the query. This makes it a little easier so you don’t have to plumb the update_dt through to the FileWriter.
Here’s a simple example that shows how to pass a parameter and use it in the a child pipeline. The pass-param-pipeline will pass in a document and set a pipeline parameter on use-param-example, which takes the document and writes it out using the update_dt field. Hope this is helpful.
pass-param-pipeline_2019_10_28.slp (4.2 KB)
use-param-example_2019_10_28.slp (4.8 KB)
