โ03-20-2019 08:42 AM
Hello,
I am having issues structuring the API output i am working in. I have attached both the Source data and the JSON output structure expected in the attachment. I have attached the source file which is an extract of the SQL output. Typically my SQL output would be similar to the source i have attched.
I am trying to group the output by Transaction Header columns, Items as Array Object and Tenders as Array Object.
Source file name attached โ transactions_1.txt
Expected JSON Output format attached - > transactions_1_json.txt.
I have also attached the export of the pipeline i could get as far as possible.
Really appreciate any help offered.
Thanks
Aravind N
Transactions_1.txt (1.5 KB)
transactions_1_json.txt (1.8 KB)
Group_Hier.slp (18.1 KB)
Solved! Go to Solution.
โ03-25-2019 09:10 AM
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)
โ03-22-2019 01:37 PM
In you data, what is the thing which determines if it is an item or tender?
โ03-23-2019 09:15 PM
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)
โ03-25-2019 07:38 AM
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
โ03-25-2019 09:10 AM
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)