Create Array from Flattened Docs
I could really use some help. I have flattened documents and for each distinct
product-id value, I wish to create an array list of the variants that belong in
the product-id’s family. My desired r...
Forum Discussion
@JensDeveloper - Thank you, but if I do as you suggested it will create an issue with the insert statement, right? How I can pass “S” in the last mapper in both cases when I have data inserted or not inserted.
Why should it create an issue because then you only have the files with filed data to insert right ?
I can’t follow what your saying. You mean Succes after the last oracle insert? Or what do you mean?Thank you @JensDeveloper. I think option 2 might work for me. Could you suggest how to do it, please?
Hi @amit.saroha ,
Below is the attachement of the pipeline. It’s a file reader with csv parser and router. Only use the csv parser and router.
Explanation CSV parer:
uncheck the checkbox ‘ignore empty stream’ - check containts headers.Router explanation.
The first expression will return true if the input data is not empty ( it will output the input data to the first output view ), and the second expression will simply returntrueand will output the data on the second output view. With theFirst matchoption checked, only the first expression that returns true will be evaluated to the output even if there are more expressions that return true.CsvFile_Validation_V1.0_2022_07_07.slp (5.1 KB)
Regards
Jens
