Parse a CSV file by column
Most CSV files are organized by row, this will parse a CSV file if the data is organized by columns.
[{"id":"c8c78f4d.679e8","type":"subflow","name":"csvColumnParser","info":"","category":"","in":[{"x":70,"y":80,"wires":[{"id":"a8857356.d49e68"}]}],"out":[{"x":900,"y":80,"wires":[{"id":"d71e0bef.46647","port":0}]}],"env":[]},{"id":"a8857356.d49e68","type":"csv","z":"c8c78f4d.679e8","name":"","sep":",","hdrin":true,"hdrout":"","multi":"one","ret":"\\n","temp":"","skip":"0","strings":true,"x":200,"y":80,"wires":[["d12b5d18.58218"]]},{"id":"3b501c89.fa554c","type":"split","z":"c8c78f4d.679e8","name":"","splt":"\\n","spltType":"str","arraySplt":1,"arraySpltType":"len","stream":false,"addname":"topic","x":540,"y":80,"wires":[["6dad6ed9.c91f08"]]},{"id":"6dad6ed9.c91f08","type":"function","z":"c8c78f4d.679e8","name":"","func":"if (!context.results) context.results = {}\n\nif (!context.results[msg.topic]) context.results[msg.topic] = []\ncontext.results[msg.topic].push(msg.payload)\nmsg.payload = context.results\n\nif ((msg.originalParts.index === msg.originalParts.count - 1) && (msg.parts.index === msg.parts.count - 1)) {\n msg.payload = context.results\n context.results = {}\n return msg\n}\n","outputs":1,"noerr":0,"x":660,"y":80,"wires":[["d71e0bef.46647"]]},{"id":"d12b5d18.58218","type":"change","z":"c8c78f4d.679e8","name":"","rules":[{"t":"set","p":"originalParts","pt":"msg","to":"parts","tot":"msg"}],"action":"","property":"","from":"","to":"","reg":false,"x":370,"y":80,"wires":[["3b501c89.fa554c"]]},{"id":"d71e0bef.46647","type":"change","z":"c8c78f4d.679e8","name":"spread","rules":[{"t":"set","p":"payload","pt":"msg","to":"$spread(payload)","tot":"jsonata"}],"action":"","property":"","from":"","to":"","reg":false,"x":780,"y":80,"wires":[[]]},{"id":"41d99cd9.ebaab4","type":"subflow:c8c78f4d.679e8","z":"9ebcc82e.a603a8","name":"","env":[],"x":490,"y":120,"wires":[["27cb50d6.df2568"]]},{"id":"b86a02cd.cac6a8","type":"inject","z":"9ebcc82e.a603a8","name":"","topic":"","payload":"","payloadType":"date","repeat":"","crontab":"","once":false,"onceDelay":0.1,"x":120,"y":120,"wires":[["445d6d7.8e00114"]]},{"id":"445d6d7.8e00114","type":"template","z":"9ebcc82e.a603a8","name":"","field":"payload","fieldType":"msg","format":"handlebars","syntax":"mustache","template":"Monday,Tuesday,Wednesday,Thursday,Friday\n1,a,10,6,cat\n2,b,20,5,dog\n3,c,30,4,zip\n4,d,40,3,zap\n5,e,50,2,ping\n6,f,60,1,pong","output":"str","x":300,"y":120,"wires":[["41d99cd9.ebaab4"]]},{"id":"27cb50d6.df2568","type":"debug","z":"9ebcc82e.a603a8","name":"","active":true,"tosidebar":true,"console":false,"tostatus":false,"complete":"false","x":710,"y":120,"wires":[]},{"id":"b51a9213.23ef1","type":"comment","z":"9ebcc82e.a603a8","name":"Parse CSV file by column","info":"","x":150,"y":60,"wires":[]}]
