SQL Server - Execute Snap
A statement like this works fine in SQL Server. How can I get something like this to work in the SQL Server - Execute Snap? There has to be a syntax issue that I have. Any help is appreciated.
D...
Forum Discussion
Use this script, it groups all inputs into single array:
execute : function () {
this.log.info("Executing Transform Script");
var groupByN = new ArrayList();
var wrapper = {};
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.
var inDoc = this.input.next();
groupByN.add(inDoc);
wrapper = {"Data": groupByN};
}
catch (err) {
var errDoc = new LinkedHashMap();
errDoc.put("error", err);
this.log.error(err);
this.error.write(errDoc);
}
}
this.output.write(wrapper);
this.log.info("Script executed");
}
I tested it with ultra task and it seems it works.
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 help
