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
Thank you, I solved it before the reply and I came to say it's done. I didn't know much about APIs and now I understand that I should've gone through the documentation first to understand how I can handle the data. I solved it by adding a query parameter like in the picture.
Also, thank you for suggesting the training workshop. Have a good weekend!
