Forum Discussion
Note that you are combining ALL of the Excel files found in the directory into a single CSV file. Is that really your intention here?
You’ll need to move part of the pipeline into a child pipeline and pass the file name as a parameter to the child. I’m going to guess you probably don’t want to combine all of the Excel files into one file, but rather have one CSV file per input file. Using a child pipeline will fix that issue as well.
So, I would move the “Read XLSX” and following snaps into the child pipeline and add a filename
parameter. Then you can place a PipelineExecute snap after the Filter to kick off the child and pass down the file name from document output by the Box Directory Browser.
Thanks for the quick reply.
No, the mask applied picks up only one file. I understand that I might need to handle multiple files in future, but that’s unrelated to my question here.
Just to clarify what you’re saying here, the only way to accomplish this is with a Child Pipeline and a PipelineExecute Snap. There is no way to pass the variable “up” into the Pipeline’s “session”.
Is that correct?
JSON Splitter snap already set to Include scalar parents.
In the mapper I have Expression: $['wd:employee']['wd:first_name'] and Target path: first_name, but what is happening is that it only outputs the arrays that only contain one (the first one only) nested array in employee. It does not create the desired output of like in the example, two data arrays.