thilkip
New Contributor
Joined 5 years ago
User Profile
User Widgets
Contributions
Re: Merge multiple documents to an array in ultra pipeline
bojanvelevski: Hello Bojan Thank you for your time and help. We did validate the script in ultra task and saw the same behavior like earlier. We will test the other approach using Formatter snap and let you know. Thank you again3.2KViews0likes1CommentRe: Merge multiple documents to an array in ultra pipeline
Thanks. but please see below, 40 documents went in and 0 out. if we put the write inside the while loop, it will write 40 documents in this case but we need the 40th document as the final result. if there is a way to take the last document, that will also help2.4KViews0likes0CommentsRe: Merge multiple documents to an array in ultra pipeline
We tried with script as below. it works in design mode but not when we call ultra tasks. When we call ultra tasks the script snap doesnt provide any output execute : function () { this.log.info(“Executing Transform Script”); var outDoc = new LinkedHashMap(); var inDoc=null; var items = new ArrayList(); var i=0; while (this.input.hasNext()) { try { // Read the next input document, store it a new LinkedHashMap, and write this as an output document. // We must use a serializable Java type liked LinkedHashMap for each output instead of a native // JavaScript object so that downstream Snaps like Copy can process it correctly. inDoc = this.input.next(); i=i+1; items.add(inDoc); outDoc.put("index", i); if ((!this.input.hasNext()) || (this.input.hasNext()==false)) { outDoc.put("data", items); this.output.write(inDoc, outDoc); } } catch (err) { var errDoc = new LinkedHashMap(); errDoc.put("error", err); this.log.error(err); this.error.write(errDoc); } } this.log.info("Script executed");3.6KViews0likes0CommentsMerge multiple documents to an array in ultra pipeline
We need to merge multiple documents to single array and looking for help. Since it is ultra task, we are running out of options… Input data: [ {“Record”: “1”}, {“Record”: “2”}, {“Record”: “5”}, {“Record”: “4”}, {“Record”: “6”} ] Expected Output: [ “response”: [{“Record”: “1”}, {“Record”: “2”}, {“Record”: “5”}, {“Record”: “4”}, {“Record”: “6”}] ]16KViews0likes25Comments