[{"id":"6742c88da1a644fa","type":"debug","z":"4cf88ab4c1f8b45f","name":"debug 958","active":true,"tosidebar":true,"console":false,"tostatus":false,"complete":"true","targetType":"full","statusVal":"","statusType":"auto","x":1310,"y":1880,"wires":[]},{"id":"799017cb4a7c807f","type":"inject","z":"4cf88ab4c1f8b45f","name":"","props":[{"p":"payload"},{"p":"topic","vt":"str"}],"repeat":"","crontab":"","once":false,"onceDelay":0.1,"topic":"","payload":"","payloadType":"date","x":320,"y":1900,"wires":[["6873eee80b578ff1"]]},{"id":"6873eee80b578ff1","type":"luxmsbi-datagate","z":"4cf88ab4c1f8b45f","name":"","source":"ch","chunkSize":"222","sqlQuery":"describe table (\nselect * FROM test.product_pivot\n)","x":560,"y":1900,"wires":[["0ea2a88482c13531"]]},{"id":"b322ee2834ae27b8","type":"inject","z":"4cf88ab4c1f8b45f","name":"","props":[{"p":"payload"},{"p":"topic","vt":"str"}],"repeat":"","crontab":"","once":false,"onceDelay":0.1,"topic":"","payload":"","payloadType":"date","x":320,"y":1980,"wires":[["343e978dbfb14468"]]},{"id":"343e978dbfb14468","type":"luxmsbi-datagate","z":"4cf88ab4c1f8b45f","name":"","source":"ch","chunkSize":"2222","sqlQuery":"describe table (\nselect * FROM test.product_pivot\n)","x":560,"y":1980,"wires":[["991ae7fa719c1f92"]]},{"id":"0ea2a88482c13531","type":"function","z":"4cf88ab4c1f8b45f","name":"function 245","func":"\nreturn msg;","outputs":1,"noerr":0,"initialize":"","finalize":"","libs":[],"x":790,"y":1900,"wires":[["411bf83ee4e8c98e","29950f5a430b97f4"]]},{"id":"411bf83ee4e8c98e","type":"join","z":"4cf88ab4c1f8b45f","name":"","mode":"custom","build":"array","property":"payload","propertyType":"msg","key":"topic","joiner":"\\n","joinerType":"str","accumulate":false,"timeout":"","count":"","reduceRight":false,"reduceExp":"","reduceInit":"","reduceInitType":"num","reduceFixup":"","x":1130,"y":1900,"wires":[["6742c88da1a644fa"]]},{"id":"991ae7fa719c1f92","type":"function","z":"4cf88ab4c1f8b45f","name":"function 246","func":"\nreturn msg;","outputs":1,"noerr":0,"initialize":"","finalize":"","libs":[],"x":790,"y":1980,"wires":[["411bf83ee4e8c98e","46ba5961789507a6"]]},{"id":"efb132f3cbc34423","type":"inject","z":"4cf88ab4c1f8b45f","name":"","props":[{"p":"payload"},{"p":"topic","vt":"str"}],"repeat":"","crontab":"","once":false,"onceDelay":0.1,"topic":"","payload":"","payloadType":"date","x":320,"y":2040,"wires":[["9a50b15f37277338"]]},{"id":"9a50b15f37277338","type":"luxmsbi-datagate","z":"4cf88ab4c1f8b45f","name":"","source":"ch","chunkSize":"2222","sqlQuery":"describe table (\nselect * FROM test.product_pivot\n)","x":560,"y":2040,"wires":[["f66047a1b0d32952"]]},{"id":"f66047a1b0d32952","type":"function","z":"4cf88ab4c1f8b45f","name":"function 247","func":"msg.complete=0;\n\nreturn msg;","outputs":1,"noerr":0,"initialize":"","finalize":"","libs":[],"x":790,"y":2040,"wires":[["411bf83ee4e8c98e","61019cd17ac75459"]]},{"id":"715ae02.ffcb82","type":"function","z":"4cf88ab4c1f8b45f","name":"Wait for all tasks to finish","func":"context.data = context.data || new Object();\nlet msg2; // Declare msg2 variable\n\nswitch (msg.topic) {\n case \"task1\":\n context.data.task1 = msg.payload;\n msg = null;\n break;\n case \"task2\":\n context.data.task2 = msg.payload;\n msg = null;\n break;\n case \"task3\":\n context.data.task3 = msg.payload;\n msg = null;\n break;\n default:\n msg = null;\n break;\n}\n\nif (context.data.task1 != null && context.data.task2 != null && context.data.task3 != null) {\n msg2 = new Object();\n msg2 = context.data;\n context.data = null;\n return msg2;\n} else {\n return msg;\n}\n","outputs":1,"noerr":0,"initialize":"","finalize":"","libs":[],"x":1170,"y":2260,"wires":[["1db3a013.cd5468"]]},{"id":"1db3a013.cd5468","type":"debug","z":"4cf88ab4c1f8b45f","name":"","active":true,"console":"false","complete":"true","x":1377,"y":2259,"wires":[]},{"id":"68458f8e3f63d36c","type":"luxmsbi-datagate","z":"4cf88ab4c1f8b45f","name":"","source":"ch","chunkSize":"15","sqlQuery":"describe table (\nselect * FROM test.product_pivot\n)","x":520,"y":2160,"wires":[["706ed1ec2a101e3e"]]},{"id":"00e3396d170a71e5","type":"inject","z":"4cf88ab4c1f8b45f","name":"","props":[{"p":"payload"},{"p":"topic","vt":"str"}],"repeat":"","crontab":"","once":false,"onceDelay":0.1,"topic":"","payload":"","payloadType":"date","x":320,"y":2160,"wires":[["68458f8e3f63d36c"]]},{"id":"6dd5b672076db65f","type":"luxmsbi-datagate","z":"4cf88ab4c1f8b45f","name":"","source":"ch","chunkSize":"20","sqlQuery":"describe table (\nselect * FROM test.product_pivot\n)","x":520,"y":2260,"wires":[["65755a0c7c823ce1"]]},{"id":"9aba7a3d56a765e1","type":"inject","z":"4cf88ab4c1f8b45f","name":"","props":[{"p":"payload"},{"p":"topic","vt":"str"}],"repeat":"","crontab":"","once":false,"onceDelay":0.1,"topic":"","payload":"","payloadType":"date","x":320,"y":2260,"wires":[["6dd5b672076db65f"]]},{"id":"40f165c99960ba3e","type":"luxmsbi-datagate","z":"4cf88ab4c1f8b45f","name":"","source":"ch","chunkSize":"15","sqlQuery":"describe table (\nselect * FROM test.product_pivot\n)","x":520,"y":2360,"wires":[["6f78db1650581a3c"]]},{"id":"b9ea99fb2b3ce159","type":"inject","z":"4cf88ab4c1f8b45f","name":"","props":[{"p":"payload"},{"p":"topic","vt":"str"}],"repeat":"","crontab":"","once":false,"onceDelay":0.1,"topic":"","payload":"","payloadType":"date","x":320,"y":2360,"wires":[["40f165c99960ba3e"]]},{"id":"706ed1ec2a101e3e","type":"function","z":"4cf88ab4c1f8b45f","name":"function 248","func":"msg.topic = \"task1\";\nreturn msg;","outputs":1,"noerr":0,"initialize":"","finalize":"","libs":[],"x":710,"y":2160,"wires":[["715ae02.ffcb82"]]},{"id":"65755a0c7c823ce1","type":"function","z":"4cf88ab4c1f8b45f","name":"function 249","func":"msg.topic = \"task2\";\nreturn msg;","outputs":1,"noerr":0,"initialize":"","finalize":"","libs":[],"x":710,"y":2260,"wires":[["715ae02.ffcb82"]]},{"id":"6f78db1650581a3c","type":"function","z":"4cf88ab4c1f8b45f","name":"function 250","func":"msg.topic = \"task3\";\nreturn msg;","outputs":1,"noerr":0,"initialize":"","finalize":"","libs":[],"x":710,"y":2360,"wires":[["715ae02.ffcb82"]]},{"id":"29950f5a430b97f4","type":"debug","z":"4cf88ab4c1f8b45f","name":"debug 1001","active":false,"tosidebar":true,"console":false,"tostatus":false,"complete":"true","targetType":"full","statusVal":"","statusType":"auto","x":890,"y":1820,"wires":[]},{"id":"46ba5961789507a6","type":"debug","z":"4cf88ab4c1f8b45f","name":"debug 1002","active":false,"tosidebar":true,"console":false,"tostatus":false,"complete":"true","targetType":"full","statusVal":"","statusType":"auto","x":1130,"y":1980,"wires":[]},{"id":"61019cd17ac75459","type":"debug","z":"4cf88ab4c1f8b45f","name":"debug 1003","active":false,"tosidebar":true,"console":false,"tostatus":false,"complete":"true","targetType":"full","statusVal":"","statusType":"auto","x":1130,"y":2060,"wires":[]}]