Issue (or bug) with mapper snap
Hello,
I have found something like bug. I cannot understand the strange result of the following pipeline.
When I run validation of this pipeline, I see following results.
As expected count...
Forum Discussion
Please find the attached 2 pipelines.
Parent pipeline will extract the source data, will pass to the child, and the child pipeline will write the file with the Id in the filename.
BR,
Spiro
This pipleine does what you want I think. I put the inoput data in the CSV generator at the beginning, and the output of the join give the data you need.
Take a look.Group_test_2019_03_23 (1).slp (23.7 KB)
Thanks for the Solution. The Solution is almost what i need except the "Transaction_id should be displayed at the header level only. “The tenders” child array also displays the “TRANSACTION_ID” attribute which i don’t want to display at the tenders level.
I tried removing by having empty expression variable for “transactiod_id” in the “Remove groupBy tenders” Snap but didn’t work. It would be really helpful if this is sorted.
Thanks
Add a line in the mapper “Remove GroupBy” to remove that:
Updated pipeline: Group_test_2019_03_25.slp (23.8 KB)
Updated Output: Join.txt (2.6 KB)
receipt_no,item_id,quantity,item_total,item_gross,item_tax are item attributes grouped for each transaction_id.
media_id,media_no,media_value are tenders attributes grouped for each transaction_id
