Push csv row values in dropdown

General
1

I'm trying to push csv row values into a dropdown. need help on this.

[{"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,"initialize":"","finalize":"","libs":[],"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":"ad0f2fde.e4774","type":"csv","z":"f23392c0.2a45e","name":"","sep":",","hdrin":false,"hdrout":"none","multi":"mult","ret":"\\n","temp":",Work_Center","skip":"2","strings":true,"include_empty_strings":"","include_null_values":"","x":490,"y":1080,"wires":[["5d54c480.88d5ac"]]},{"id":"cfa8cffb.2d14f","type":"inject","z":"f23392c0.2a45e","name":"","props":[{"p":"payload"},{"p":"topic","vt":"str"}],"repeat":"","crontab":"","once":false,"onceDelay":0.1,"topic":"","payload":"","payloadType":"date","x":160,"y":1080,"wires":[["19566887.e0b907"]]},{"id":"5d54c480.88d5ac","type":"change","z":"f23392c0.2a45e","name":"","rules":[{"t":"set","p":"payload","pt":"msg","to":"$distinct(payload)","tot":"jsonata"}],"action":"","property":"","from":"","to":"","reg":false,"x":650,"y":1080,"wires":[["9d898403.dec058"]]},{"id":"9d898403.dec058","type":"csv","z":"f23392c0.2a45e","name":"","sep":",","hdrin":false,"hdrout":"all","multi":"one","ret":"\\n","temp":"","skip":"0","strings":true,"include_empty_strings":"","include_null_values":"","x":820,"y":1080,"wires":[["7687cbac.3a0444"]]},{"id":"aa268037.8d454","type":"file in","z":"f23392c0.2a45e","name":"mt02order","filename":"C:\\Users\\Sahil\\Desktop\\testing\\mt02order.csv","format":"utf8","chunk":false,"sendError":false,"encoding":"none","x":320,"y":1100,"wires":[[]]},{"id":"2d1212a0.07aabe","type":"function","z":"f23392c0.2a45e","name":"transform data","func":"//as per info panel, the data needs to be formatted\n//as [ \"Choice 1\", \"Choice 2\", {\"Choice 3\":\"3\"} ]\n//and sent in msg.options.\nmsg.options = [];//create empty array\nfor(let i = 0; i < msg.payload.length; i++)\n    {\n    let row = msg.payload[i]; //get the row\n    let opt = {};//make new opt object\n    opt[row.Work_Center] = row.Work_Center; \n    msg.options.push(opt);//add the opt to array    \n    }\nreturn msg;","outputs":1,"noerr":0,"initialize":"","finalize":"","libs":[],"x":1220,"y":1080,"wires":[["e003b8bf.77d6b8","d41dea69.7be008"]]},{"id":"e003b8bf.77d6b8","type":"ui_dropdown","z":"f23392c0.2a45e","name":"Work center","label":"Work center","tooltip":"","place":"select","group":"acbd28dd.7cd108","order":1,"width":"6","height":"1","passthru":false,"multiple":false,"options":[{"label":"","value":"","type":"str"}],"payload":"","topic":"work_center","topicType":"str","x":1430,"y":1100,"wires":[[]]},{"id":"19566887.e0b907","type":"template","z":"f23392c0.2a45e","name":"simulate file","field":"payload","fieldType":"msg","format":"handlebars","syntax":"mustache","template":"Order_No,Work_Center,Material,Work_Center_Description,Cycle_TIme,Material_Description,Order_Qty,Confirm_Qty,Creation_date,Pending_Qty,Person_Responsible,Plant,Drg_No\n,,,,,,,,,,,,\n100070432,M02HD008,C-M-201-0696-01,HD008 HEADER,3,SHAFT SWING ARM UPTO COLD FORGING,750,750,08.06.2021,0,RAM SINGH,MT02,M-0696\n100070441,M02MBF01,C-M-201-3449-02,MBF1 MBF HARDENING & WASHING,1.67,BOLT SWING ARM PIVOT UPTO HT,\"3,000.00\",\"1,076.00\",08.06.2021,\"1,924.00\",PAWAN,MT02,M-3449\n100070296,M02MBF01,C-M-201-3449-02,MBF1 MBF HARDENING & WASHING,1.67,BOLT SWING ARM PIVOT UPTO HT,\"2,000.00\",\"2,000.00\",05.06.2021,0,PAWAN,MT02,M-3449\n100070441,M02ST003,C-M-201-3449-03,ST03 STRAIGHTENING,8,BOLT SWING ARM PIVOT UPTO STRAIGHTENING,\"3,000.00\",\"1,076.00\",08.06.2021,\"1,924.00\",AMIT SHARMA,MT02,M-3449\n100070296,M02ST003,C-M-201-3449-03,ST03 STRAIGHTENING,8,BOLT SWING ARM PIVOT UPTO STRAIGHTENING,\"2,000.00\",\"2,000.00\",05.06.2021,0,AMIT SHARMA,MT02,M-3449\n100070297,M02CL013,C-M-201-3449-04,CL13 CENTRE LESS GRINDER,7,BOLT SWING ARM PIVOT UPTO DIA HALF GRIND,\"2,000.00\",\"2,000.00\",05.06.2021,0,AMIT SHARMA,MT02,M-3449\n100070441,M02CL013,C-M-201-3449-04,CL13 CENTRE LESS GRINDER,7,BOLT SWING ARM PIVOT UPTO DIA HALF GRIND,\"3,000.00\",\"1,076.00\",08.06.2021,\"1,924.00\",AMIT SHARMA,MT02,M-3449\n100070297,M02CL013,C-M-201-3449-05,CL13 CENTRE LESS GRINDER,6,BOLT SWING ARM PIVOT UPTO DIA FINAL GRIN,\"2,000.00\",\"2,000.00\",05.06.2021,0,AMIT SHARMA,MT02,M-3449\n100070441,M02CL013,C-M-201-3449-05,CL13 CENTRE LESS GRINDER,6,BOLT SWING ARM PIVOT UPTO DIA FINAL GRIN,\"3,000.00\",\"1,076.00\",08.06.2021,\"1,924.00\",AMIT SHARMA,MT02,M-3449\n100070441,M02TR007,C-M-201-3449-06,TR07 THREAD ROLLING,7,BOLT SWING ARM PIVOT UPTO THREAD ROLLING,\"3,000.00\",\"1,076.00\",08.06.2021,\"1,924.00\",AMIT SHARMA,MT02,M-3449\n100070298,M02TR007,C-M-201-3449-06,TR07 THREAD ROLLING,7,BOLT SWING ARM PIVOT UPTO THREAD ROLLING,\"2,000.00\",\"2,000.00\",05.06.2021,0,AMIT SHARMA,MT02,M-3449\n100070356,M02SB001,C-M-219-0286-04,SB01 SHOT BLASTING,7.2,PINION KICK STARTER UPTO SHOT BLASTING,\"15,911.00\",\"4,420.00\",07.06.2021,\"11,491.00\",UDAY THAKUR,MT02,M-0286","output":"str","x":330,"y":1040,"wires":[["ad0f2fde.e4774"]]},{"id":"d41dea69.7be008","type":"debug","z":"f23392c0.2a45e","name":"","active":true,"tosidebar":true,"console":false,"tostatus":false,"complete":"payload","targetType":"msg","statusVal":"","statusType":"auto","x":1430,"y":1040,"wires":[]},{"id":"7687cbac.3a0444","type":"subflow:c8c78f4d.679e8","z":"f23392c0.2a45e","name":"","x":1010,"y":1080,"wires":[["2d1212a0.07aabe"]]},{"id":"acbd28dd.7cd108","type":"ui_group","name":"Group 2","tab":"74fd02f9.b99b3c","order":1,"disp":true,"width":6},{"id":"74fd02f9.b99b3c","type":"ui_tab","name":"Breakdown entry form","icon":"dashboard","order":1,"disabled":false,"hidden":false}]

With no codding knowledge sometimes it feels frustrating :tired_face:

2 
[{"id":"cfa8cffb.2d14f","type":"inject","z":"c74669a0.6a34f8","name":"","props":[{"p":"payload"},{"p":"topic","vt":"str"}],"repeat":"","crontab":"","once":false,"onceDelay":0.1,"topic":"","payload":"","payloadType":"date","x":220,"y":4000,"wires":[["19566887.e0b907"]]},{"id":"19566887.e0b907","type":"template","z":"c74669a0.6a34f8","name":"simulate file","field":"payload","fieldType":"msg","format":"handlebars","syntax":"mustache","template":"Order_No,Work_Center,Material,Work_Center_Description,Cycle_TIme,Material_Description,Order_Qty,Confirm_Qty,Creation_date,Pending_Qty,Person_Responsible,Plant,Drg_No\n,,,,,,,,,,,,\n100070432,M02HD008,C-M-201-0696-01,HD008 HEADER,3,SHAFT SWING ARM UPTO COLD FORGING,750,750,08.06.2021,0,RAM SINGH,MT02,M-0696\n100070441,M02MBF01,C-M-201-3449-02,MBF1 MBF HARDENING & WASHING,1.67,BOLT SWING ARM PIVOT UPTO HT,\"3,000.00\",\"1,076.00\",08.06.2021,\"1,924.00\",PAWAN,MT02,M-3449\n100070296,M02MBF01,C-M-201-3449-02,MBF1 MBF HARDENING & WASHING,1.67,BOLT SWING ARM PIVOT UPTO HT,\"2,000.00\",\"2,000.00\",05.06.2021,0,PAWAN,MT02,M-3449\n100070441,M02ST003,C-M-201-3449-03,ST03 STRAIGHTENING,8,BOLT SWING ARM PIVOT UPTO STRAIGHTENING,\"3,000.00\",\"1,076.00\",08.06.2021,\"1,924.00\",AMIT SHARMA,MT02,M-3449\n100070296,M02ST003,C-M-201-3449-03,ST03 STRAIGHTENING,8,BOLT SWING ARM PIVOT UPTO STRAIGHTENING,\"2,000.00\",\"2,000.00\",05.06.2021,0,AMIT SHARMA,MT02,M-3449\n100070297,M02CL013,C-M-201-3449-04,CL13 CENTRE LESS GRINDER,7,BOLT SWING ARM PIVOT UPTO DIA HALF GRIND,\"2,000.00\",\"2,000.00\",05.06.2021,0,AMIT SHARMA,MT02,M-3449\n100070441,M02CL013,C-M-201-3449-04,CL13 CENTRE LESS GRINDER,7,BOLT SWING ARM PIVOT UPTO DIA HALF GRIND,\"3,000.00\",\"1,076.00\",08.06.2021,\"1,924.00\",AMIT SHARMA,MT02,M-3449\n100070297,M02CL013,C-M-201-3449-05,CL13 CENTRE LESS GRINDER,6,BOLT SWING ARM PIVOT UPTO DIA FINAL GRIN,\"2,000.00\",\"2,000.00\",05.06.2021,0,AMIT SHARMA,MT02,M-3449\n100070441,M02CL013,C-M-201-3449-05,CL13 CENTRE LESS GRINDER,6,BOLT SWING ARM PIVOT UPTO DIA FINAL GRIN,\"3,000.00\",\"1,076.00\",08.06.2021,\"1,924.00\",AMIT SHARMA,MT02,M-3449\n100070441,M02TR007,C-M-201-3449-06,TR07 THREAD ROLLING,7,BOLT SWING ARM PIVOT UPTO THREAD ROLLING,\"3,000.00\",\"1,076.00\",08.06.2021,\"1,924.00\",AMIT SHARMA,MT02,M-3449\n100070298,M02TR007,C-M-201-3449-06,TR07 THREAD ROLLING,7,BOLT SWING ARM PIVOT UPTO THREAD ROLLING,\"2,000.00\",\"2,000.00\",05.06.2021,0,AMIT SHARMA,MT02,M-3449\n100070356,M02SB001,C-M-219-0286-04,SB01 SHOT BLASTING,7.2,PINION KICK STARTER UPTO SHOT BLASTING,\"15,911.00\",\"4,420.00\",07.06.2021,\"11,491.00\",UDAY THAKUR,MT02,M-0286","output":"str","x":390,"y":3960,"wires":[["ad0f2fde.e4774"]]},{"id":"ad0f2fde.e4774","type":"csv","z":"c74669a0.6a34f8","name":"","sep":",","hdrin":false,"hdrout":"none","multi":"mult","ret":"\\n","temp":",Work_Center","skip":"2","strings":true,"include_empty_strings":"","include_null_values":"","x":550,"y":4000,"wires":[["5d54c480.88d5ac"]]},{"id":"5d54c480.88d5ac","type":"change","z":"c74669a0.6a34f8","name":"","rules":[{"t":"set","p":"options","pt":"msg","to":"$distinct(payload.*)","tot":"jsonata"}],"action":"","property":"","from":"","to":"","reg":false,"x":720,"y":4000,"wires":[["e003b8bf.77d6b8","d41dea69.7be008"]]},{"id":"e003b8bf.77d6b8","type":"ui_dropdown","z":"c74669a0.6a34f8","name":"Work center","label":"Work center","tooltip":"","place":"select","group":"acbd28dd.7cd108","order":1,"width":"6","height":"1","passthru":false,"multiple":false,"options":[{"label":"","value":"","type":"str"}],"payload":"","topic":"work_center","topicType":"str","x":920,"y":4020,"wires":[[]]},{"id":"d41dea69.7be008","type":"debug","z":"c74669a0.6a34f8","name":"","active":true,"tosidebar":true,"console":false,"tostatus":false,"complete":"payload","targetType":"msg","statusVal":"","statusType":"auto","x":970,"y":3960,"wires":[]},{"id":"acbd28dd.7cd108","type":"ui_group","name":"Group 2","tab":"74fd02f9.b99b3c","order":1,"disp":true,"width":6},{"id":"74fd02f9.b99b3c","type":"ui_tab","name":"Breakdown entry form","icon":"dashboard","order":1,"disabled":false,"hidden":false}]

You just need to convert the array of object into an array of column values example above.

3

Thankyou so much. Can you also help me with the complete flow.

[{"id":"87ac3b01.909018","type":"tab","label":"Breakdown","disabled":false,"info":""},{"id":"e642510e.a315f","type":"ui_text","z":"87ac3b01.909018","group":"f9e41b13.1fe7a8","order":1,"width":6,"height":1,"name":"","label":"Posting Date  :","format":"{{myymd}}","layout":"row-left","x":1020,"y":120,"wires":[]},{"id":"aeae155f.451868","type":"simpletime","z":"87ac3b01.909018","name":"","mydate":true,"myymd":true,"myyear":true,"mymonth":true,"mymonthn":true,"mydom":true,"mydoy":true,"myday":true,"myhourpm":true,"myhour":true,"mytime":true,"mytimes":true,"myminute":true,"myminutes":true,"mysecond":true,"mymillis":true,"myepoch":true,"myrawdate":true,"mypm":true,"x":830,"y":120,"wires":[["e642510e.a315f","91dde6e8.b13f18"]]},{"id":"1096e6ce.85eff9","type":"inject","z":"87ac3b01.909018","name":"","props":[{"p":"payload"},{"p":"topic","vt":"str"}],"repeat":"","crontab":"","once":false,"onceDelay":0.1,"topic":"","payload":"","payloadType":"date","x":660,"y":120,"wires":[["aeae155f.451868"]]},{"id":"2ddf0d85.ea1dc2","type":"ui_dropdown","z":"87ac3b01.909018","name":"","label":"Shift","tooltip":"","place":"Select shift","group":"f9e41b13.1fe7a8","order":10,"width":3,"height":1,"passthru":true,"multiple":false,"options":[{"label":"A","value":"A","type":"str"},{"label":"B","value":"B","type":"str"}],"payload":"","topic":"topic","topicType":"msg","x":690,"y":520,"wires":[["d355d09b.6f24"]]},{"id":"1635f63b.70501a","type":"inject","z":"87ac3b01.909018","name":"","props":[{"p":"payload"},{"p":"topic","vt":"str"}],"repeat":"","crontab":"","once":false,"onceDelay":0.1,"topic":"","payload":"","payloadType":"date","x":700,"y":380,"wires":[["7a940e02.78c04"]]},{"id":"b3f182dc.95637","type":"file in","z":"87ac3b01.909018","name":"mt02order","filename":"C:\\Users\\Sahil\\Desktop\\testing\\mt02order.csv","format":"utf8","chunk":false,"sendError":false,"encoding":"none","x":880,"y":420,"wires":[[]]},{"id":"22f4750f.3db1ca","type":"csv","z":"87ac3b01.909018","name":"","sep":",","hdrin":true,"hdrout":"all","multi":"mult","ret":"\\n","temp":"","skip":"0","strings":true,"include_empty_strings":false,"include_null_values":false,"x":1050,"y":420,"wires":[["c85b3567.5fcb08"]]},{"id":"f4ed0b9d.66aef8","type":"ui_dropdown","z":"87ac3b01.909018","name":"","label":"Work center","tooltip":"","place":"Select Machine","group":"f9e41b13.1fe7a8","order":3,"width":6,"height":1,"passthru":false,"multiple":false,"options":[{"label":"","value":"","type":"str"}],"payload":"","topic":"work_center","topicType":"msg","x":1450,"y":380,"wires":[["3832c97b.fd3ba6","ee10ad87.d3dd3"]]},{"id":"264cd440.e8690c","type":"function","z":"87ac3b01.909018","name":"lookup for Order No","func":"var data = msg.payload;\nvar map = {};\nfor (let index = 0; index < data.length; index++) {\n    const element = data[index];\n    map[element.Work_Center] = element.Order_No;\n}\nmsg.payload = map;\nreturn msg;","outputs":1,"noerr":0,"initialize":"","finalize":"","libs":[],"x":1470,"y":460,"wires":[["a9532548.208828"]]},{"id":"a9532548.208828","type":"change","z":"87ac3b01.909018","name":"","rules":[{"t":"set","p":"partLookup","pt":"flow","to":"payload","tot":"msg"}],"action":"","property":"","from":"","to":"","reg":false,"x":1690,"y":460,"wires":[[]]},{"id":"3832c97b.fd3ba6","type":"change","z":"87ac3b01.909018","name":"","rules":[{"t":"set","p":"payload","pt":"msg","to":"partLookup[msg.payload]","tot":"flow"}],"action":"","property":"","from":"","to":"","reg":false,"x":1640,"y":380,"wires":[["494e47b1.167818","d3a6f345.e0e35"]]},{"id":"494e47b1.167818","type":"debug","z":"87ac3b01.909018","name":"","active":false,"tosidebar":true,"console":false,"tostatus":true,"complete":"true","targetType":"full","statusVal":"payload","statusType":"msg","x":1850,"y":320,"wires":[]},{"id":"d3a6f345.e0e35","type":"ui_dropdown","z":"87ac3b01.909018","name":"","label":"Order No.","tooltip":"","place":"Select","group":"f9e41b13.1fe7a8","order":4,"width":6,"height":1,"passthru":false,"multiple":false,"options":[{"label":"","value":"","type":"str"}],"payload":"","topic":"order_no","topicType":"msg","x":1860,"y":380,"wires":[["8ac90930.199968"]]},{"id":"ea66fdd4.ce5d5","type":"ui_table","z":"87ac3b01.909018","group":"f9e41b13.1fe7a8","name":"","order":7,"width":28,"height":3,"columns":[],"outputs":0,"cts":false,"x":1650,"y":520,"wires":[]},{"id":"f24d7e50.20701","type":"ui_text_input","z":"87ac3b01.909018","name":"Start Time","label":"Start Time","tooltip":"Start Time","group":"f9e41b13.1fe7a8","order":12,"width":3,"height":1,"passthru":false,"mode":"time","delay":300,"topic":"Start Time","topicType":"str","x":700,"y":640,"wires":[["d0bf4f47.05a94"]]},{"id":"d7e88a39.a6de98","type":"ui_date_picker","z":"87ac3b01.909018","name":"","label":"Start date","group":"f9e41b13.1fe7a8","order":11,"width":5,"height":1,"passthru":false,"topic":"Start date","topicType":"str","x":700,"y":560,"wires":[["b1955da5.c99f6"]]},{"id":"a169e909.f6b518","type":"ui_date_picker","z":"87ac3b01.909018","name":"","label":"End date","group":"f9e41b13.1fe7a8","order":17,"width":5,"height":1,"passthru":false,"topic":"End date","topicType":"str","x":700,"y":600,"wires":[["f089f523.5724c8"]]},{"id":"c2411f69.be4d4","type":"ui_text_input","z":"87ac3b01.909018","name":"End Time","label":"End Time","tooltip":"End Time","group":"f9e41b13.1fe7a8","order":18,"width":3,"height":1,"passthru":true,"mode":"time","delay":300,"topic":"End Time","topicType":"str","x":700,"y":680,"wires":[["99726772.f027f8"]]},{"id":"b1955da5.c99f6","type":"change","z":"87ac3b01.909018","name":"dd-mm-yyyy","rules":[{"t":"set","p":"payload","pt":"msg","to":"$moment(payload).tz(\"Europe/London\").format(\"DD-MM-YYYY\")","tot":"jsonata"}],"action":"","property":"","from":"","to":"","reg":false,"x":850,"y":560,"wires":[["85d6eb3f.62b3e8"]]},{"id":"d0bf4f47.05a94","type":"change","z":"87ac3b01.909018","name":"hh:mm","rules":[{"t":"set","p":"payload","pt":"msg","to":"$moment(payload).tz(\"Europe/London\").format(\"HH:mm\")","tot":"jsonata"}],"action":"","property":"","from":"","to":"","reg":false,"x":850,"y":640,"wires":[["e89682fb.4764b"]]},{"id":"f089f523.5724c8","type":"change","z":"87ac3b01.909018","name":"dd-mm-yyyy","rules":[{"t":"set","p":"payload","pt":"msg","to":"$moment(payload).tz(\"Europe/London\").format(\"DD-MM-YYYY\")","tot":"jsonata"}],"action":"","property":"","from":"","to":"","reg":false,"x":850,"y":600,"wires":[["9a6e14f2.84f4d8"]]},{"id":"99726772.f027f8","type":"change","z":"87ac3b01.909018","name":"hh:mm","rules":[{"t":"set","p":"payload","pt":"msg","to":"$moment(payload).tz(\"Europe/London\").format(\"HH:mm\")","tot":"jsonata"}],"action":"","property":"","from":"","to":"","reg":false,"x":850,"y":680,"wires":[["7c159c3b.fce3f4"]]},{"id":"c971cce5.88a9c","type":"ui_dropdown","z":"87ac3b01.909018","name":"Breakdown reasons","label":"Breakdown reason","tooltip":"Breakdown reason","place":"Select Breakdown reason","group":"f9e41b13.1fe7a8","order":14,"width":9,"height":2,"passthru":false,"multiple":true,"options":[{"label":"Breakdown reason 1","value":"Reason 1","type":"str"},{"label":"Breakdown reason 2","value":"Reason 2","type":"str"},{"label":"Breakdown reason 3","value":"Reason 3","type":"str"},{"label":"Breakdown reason 4","value":"Reason 4","type":"str"}],"payload":"","topic":"Breakdown reason","topicType":"str","x":730,"y":720,"wires":[["836c5773.159a68"]]},{"id":"2d869a98.7e0f16","type":"ui_button","z":"87ac3b01.909018","name":"","group":"f9e41b13.1fe7a8","order":21,"width":4,"height":1,"passthru":false,"label":"Submit","tooltip":"","color":"","bgcolor":"","icon":"","payload":"complete","payloadType":"str","topic":"","topicType":"str","x":690,"y":820,"wires":[["16c6115f.e5bcbf","ba495f3d.bc474"]]},{"id":"1632493f.a4d6a7","type":"ui_text","z":"87ac3b01.909018","group":"f9e41b13.1fe7a8","order":13,"width":3,"height":2,"name":"","label":"Breakdown time (in hours)","format":"<font size=5>{{msg.payload}}","layout":"col-center","x":750,"y":760,"wires":[]},{"id":"e2741ebc.977cc","type":"inject","z":"87ac3b01.909018","name":"","props":[{"p":"payload"}],"repeat":"","crontab":"","once":false,"onceDelay":0.1,"topic":"","payload":"3","payloadType":"num","x":550,"y":760,"wires":[["1632493f.a4d6a7"]]},{"id":"179bd0b8.89044f","type":"ui_table","z":"87ac3b01.909018","group":"f9e41b13.1fe7a8","name":"","order":23,"width":28,"height":2,"columns":[],"outputs":0,"cts":false,"x":1010,"y":900,"wires":[]},{"id":"1c233064.2dd4b","type":"join","z":"87ac3b01.909018","name":"","mode":"custom","build":"object","property":"payload","propertyType":"msg","key":"topic","joiner":"\\n","joinerType":"str","accumulate":false,"timeout":"","count":"","reduceRight":false,"reduceExp":"","reduceInit":"","reduceInitType":"","reduceFixup":"","x":2250,"y":680,"wires":[["5521cf97.4e1f3"]]},{"id":"41e4ff59.840ee","type":"link in","z":"87ac3b01.909018","name":"","links":["9dc0d65b.64a128"],"x":215,"y":620,"wires":[["91f54c58.30a4f"]]},{"id":"9dc0d65b.64a128","type":"link out","z":"87ac3b01.909018","name":"","links":["41e4ff59.840ee","2a1228c7.93ab48","94d212c4.a29e7","e3856566.ca5c08"],"x":1255,"y":840,"wires":[]},{"id":"16c6115f.e5bcbf","type":"change","z":"87ac3b01.909018","name":"","rules":[{"t":"move","p":"payload","pt":"msg","to":"complete","tot":"msg"}],"action":"","property":"","from":"","to":"","reg":false,"x":950,"y":800,"wires":[["3a9eda1f.4a1a96"]]},{"id":"ba495f3d.bc474","type":"change","z":"87ac3b01.909018","name":"","rules":[{"t":"set","p":"payload","pt":"msg","to":"[]","tot":"json"}],"action":"","property":"","from":"","to":"","reg":false,"x":940,"y":840,"wires":[["9786f876.7c39f8"]]},{"id":"9786f876.7c39f8","type":"delay","z":"87ac3b01.909018","name":"","pauseType":"delay","timeout":"2","timeoutUnits":"seconds","rate":"1","nbRateUnits":"1","rateUnits":"second","randomFirst":"1","randomLast":"5","randomUnits":"seconds","drop":false,"x":1120,"y":840,"wires":[["9dc0d65b.64a128"]]},{"id":"91f54c58.30a4f","type":"change","z":"87ac3b01.909018","name":"timestamp","rules":[{"t":"set","p":"payload","pt":"msg","to":"","tot":"date"}],"action":"","property":"","from":"","to":"","reg":false,"x":350,"y":620,"wires":[["44b2d22d.00d21c"]]},{"id":"5521cf97.4e1f3","type":"file","z":"87ac3b01.909018","name":"","filename":"","appendNewline":true,"createDir":false,"overwriteFile":"false","encoding":"none","x":2510,"y":680,"wires":[[]]},{"id":"1959427e.99693e","type":"file in","z":"87ac3b01.909018","name":"submition report","filename":"C:\\Users\\Sahil\\Desktop\\testing\\breakdown.csv","format":"utf8","chunk":false,"sendError":false,"encoding":"none","x":720,"y":900,"wires":[["d46547e6.219768"]]},{"id":"262688ac.5398c8","type":"inject","z":"87ac3b01.909018","name":"","props":[{"p":"payload"},{"p":"topic","vt":"str"}],"repeat":"","crontab":"","once":false,"onceDelay":0.1,"topic":"","payload":"","payloadType":"date","x":540,"y":900,"wires":[["1959427e.99693e"]]},{"id":"d46547e6.219768","type":"csv","z":"87ac3b01.909018","name":"","sep":",","hdrin":true,"hdrout":"all","multi":"mult","ret":"\\r\\n","temp":"","skip":"0","strings":true,"include_empty_strings":false,"include_null_values":false,"x":890,"y":900,"wires":[["179bd0b8.89044f"]]},{"id":"8cc096b0.0d0498","type":"function","z":"87ac3b01.909018","name":"remove duplicate","func":"var prev = null;\n\nmsg.payload = msg.payload.filter((item) => {\n    var keep = (item.x !== prev);\n    prev = item.x;\n    return keep;\n});\n\nreturn msg;","outputs":1,"noerr":0,"initialize":"","finalize":"","libs":[],"x":1370,"y":80,"wires":[[]]},{"id":"a070bbc0.398b58","type":"link in","z":"87ac3b01.909018","name":"","links":["ee10ad87.d3dd3","8ac90930.199968","85d6eb3f.62b3e8","9a6e14f2.84f4d8","e89682fb.4764b","7c159c3b.fce3f4","3a9eda1f.4a1a96","836c5773.159a68","d355d09b.6f24","c86609ae.3ef4a8"],"x":2115,"y":680,"wires":[["1c233064.2dd4b"]]},{"id":"ee10ad87.d3dd3","type":"link out","z":"87ac3b01.909018","name":"","links":["a070bbc0.398b58"],"x":1575,"y":420,"wires":[]},{"id":"8ac90930.199968","type":"link out","z":"87ac3b01.909018","name":"","links":["a070bbc0.398b58"],"x":1975,"y":380,"wires":[]},{"id":"e89682fb.4764b","type":"link out","z":"87ac3b01.909018","name":"","links":["a070bbc0.398b58"],"x":975,"y":640,"wires":[]},{"id":"7c159c3b.fce3f4","type":"link out","z":"87ac3b01.909018","name":"","links":["a070bbc0.398b58"],"x":975,"y":680,"wires":[]},{"id":"85d6eb3f.62b3e8","type":"link out","z":"87ac3b01.909018","name":"","links":["a070bbc0.398b58"],"x":975,"y":560,"wires":[]},{"id":"9a6e14f2.84f4d8","type":"link out","z":"87ac3b01.909018","name":"","links":["a070bbc0.398b58"],"x":975,"y":600,"wires":[]},{"id":"3a9eda1f.4a1a96","type":"link out","z":"87ac3b01.909018","name":"","links":["a070bbc0.398b58"],"x":1255,"y":800,"wires":[]},{"id":"836c5773.159a68","type":"link out","z":"87ac3b01.909018","name":"","links":["a070bbc0.398b58"],"x":975,"y":720,"wires":[]},{"id":"17922f4d.528801","type":"link in","z":"87ac3b01.909018","name":"","links":["44b2d22d.00d21c"],"x":575,"y":640,"wires":[["f24d7e50.20701"]]},{"id":"90f2659f.56d478","type":"link in","z":"87ac3b01.909018","name":"","links":["44b2d22d.00d21c"],"x":575,"y":680,"wires":[["c2411f69.be4d4"]]},{"id":"2a1228c7.93ab48","type":"link in","z":"87ac3b01.909018","name":"","links":["9dc0d65b.64a128"],"x":1335,"y":420,"wires":[["f4ed0b9d.66aef8"]]},{"id":"94d212c4.a29e7","type":"link in","z":"87ac3b01.909018","name":"","links":["9dc0d65b.64a128"],"x":575,"y":720,"wires":[["c971cce5.88a9c"]]},{"id":"e3856566.ca5c08","type":"link in","z":"87ac3b01.909018","name":"","links":["9dc0d65b.64a128"],"x":575,"y":520,"wires":[["2ddf0d85.ea1dc2"]]},{"id":"d355d09b.6f24","type":"link out","z":"87ac3b01.909018","name":"","links":["a070bbc0.398b58"],"x":975,"y":520,"wires":[]},{"id":"44b2d22d.00d21c","type":"link out","z":"87ac3b01.909018","name":"","links":["1f7daa37.40f246","42eeac3b.95d984","17922f4d.528801","90f2659f.56d478"],"x":475,"y":620,"wires":[]},{"id":"1f7daa37.40f246","type":"link in","z":"87ac3b01.909018","name":"","links":["44b2d22d.00d21c"],"x":575,"y":560,"wires":[["d7e88a39.a6de98"]]},{"id":"42eeac3b.95d984","type":"link in","z":"87ac3b01.909018","name":"","links":["44b2d22d.00d21c"],"x":575,"y":600,"wires":[["a169e909.f6b518"]]},{"id":"91dde6e8.b13f18","type":"template","z":"87ac3b01.909018","name":"","field":"payload","fieldType":"msg","format":"handlebars","syntax":"mustache","template":"{{myymd}}","output":"str","x":1000,"y":160,"wires":[["c7489082.371da"]]},{"id":"39e2f53a.1641da","type":"debug","z":"87ac3b01.909018","name":"","active":false,"tosidebar":true,"console":false,"tostatus":true,"complete":"payload","targetType":"msg","statusVal":"payload","statusType":"auto","x":1350,"y":140,"wires":[]},{"id":"c86609ae.3ef4a8","type":"link out","z":"87ac3b01.909018","name":"","links":["a070bbc0.398b58"],"x":1295,"y":180,"wires":[]},{"id":"c7489082.371da","type":"function","z":"87ac3b01.909018","name":"","func":"msg.payload = msg.payload;\nmsg.topic = 'Posting_date';\nreturn msg;","outputs":1,"noerr":0,"initialize":"","finalize":"","libs":[],"x":1160,"y":160,"wires":[["c86609ae.3ef4a8","39e2f53a.1641da"]]},{"id":"7ddf90a6.8b04","type":"csv","z":"87ac3b01.909018","name":"","sep":",","hdrin":false,"hdrout":"none","multi":"mult","ret":"\\n","temp":",Work_Center","skip":"2","strings":true,"include_empty_strings":"","include_null_values":"","x":1050,"y":380,"wires":[["84673f7c.20372"]]},{"id":"84673f7c.20372","type":"change","z":"87ac3b01.909018","name":"","rules":[{"t":"set","p":"options","pt":"msg","to":"$distinct(payload.*)","tot":"jsonata"}],"action":"","property":"","from":"","to":"","reg":false,"x":1220,"y":380,"wires":[["f4ed0b9d.66aef8"]]},{"id":"c85b3567.5fcb08","type":"link out","z":"87ac3b01.909018","name":"","links":["fae2d912.8a8758","436c5bc9.701274"],"x":1155,"y":460,"wires":[]},{"id":"fae2d912.8a8758","type":"link in","z":"87ac3b01.909018","name":"","links":["c85b3567.5fcb08"],"x":1335,"y":460,"wires":[["264cd440.e8690c"]]},{"id":"7a940e02.78c04","type":"template","z":"87ac3b01.909018","name":"simulate file","field":"payload","fieldType":"msg","format":"handlebars","syntax":"mustache","template":"Order_No,Work_Center,Material,Work_Center_Description,Cycle_TIme,Material_Description,Order_Qty,Confirm_Qty,Creation_date,Pending_Qty,Person_Responsible,Plant,Drg_No\n,,,,,,,,,,,,\n100070432,M02HD008,C-M-201-0696-01,HD008 HEADER,3,SHAFT SWING ARM UPTO COLD FORGING,750,750,08.06.2021,0,RAM SINGH,MT02,M-0696\n100070441,M02MBF01,C-M-201-3449-02,MBF1 MBF HARDENING & WASHING,1.67,BOLT SWING ARM PIVOT UPTO HT,\"3,000.00\",\"1,076.00\",08.06.2021,\"1,924.00\",PAWAN,MT02,M-3449\n100070296,M02MBF01,C-M-201-3449-02,MBF1 MBF HARDENING & WASHING,1.67,BOLT SWING ARM PIVOT UPTO HT,\"2,000.00\",\"2,000.00\",05.06.2021,0,PAWAN,MT02,M-3449\n100070441,M02ST003,C-M-201-3449-03,ST03 STRAIGHTENING,8,BOLT SWING ARM PIVOT UPTO STRAIGHTENING,\"3,000.00\",\"1,076.00\",08.06.2021,\"1,924.00\",AMIT SHARMA,MT02,M-3449\n100070296,M02ST003,C-M-201-3449-03,ST03 STRAIGHTENING,8,BOLT SWING ARM PIVOT UPTO STRAIGHTENING,\"2,000.00\",\"2,000.00\",05.06.2021,0,AMIT SHARMA,MT02,M-3449\n100070297,M02CL013,C-M-201-3449-04,CL13 CENTRE LESS GRINDER,7,BOLT SWING ARM PIVOT UPTO DIA HALF GRIND,\"2,000.00\",\"2,000.00\",05.06.2021,0,AMIT SHARMA,MT02,M-3449\n100070441,M02CL013,C-M-201-3449-04,CL13 CENTRE LESS GRINDER,7,BOLT SWING ARM PIVOT UPTO DIA HALF GRIND,\"3,000.00\",\"1,076.00\",08.06.2021,\"1,924.00\",AMIT SHARMA,MT02,M-3449\n100070297,M02CL013,C-M-201-3449-05,CL13 CENTRE LESS GRINDER,6,BOLT SWING ARM PIVOT UPTO DIA FINAL GRIN,\"2,000.00\",\"2,000.00\",05.06.2021,0,AMIT SHARMA,MT02,M-3449\n100070441,M02CL013,C-M-201-3449-05,CL13 CENTRE LESS GRINDER,6,BOLT SWING ARM PIVOT UPTO DIA FINAL GRIN,\"3,000.00\",\"1,076.00\",08.06.2021,\"1,924.00\",AMIT SHARMA,MT02,M-3449\n100070441,M02TR007,C-M-201-3449-06,TR07 THREAD ROLLING,7,BOLT SWING ARM PIVOT UPTO THREAD ROLLING,\"3,000.00\",\"1,076.00\",08.06.2021,\"1,924.00\",AMIT SHARMA,MT02,M-3449\n100070298,M02TR007,C-M-201-3449-06,TR07 THREAD ROLLING,7,BOLT SWING ARM PIVOT UPTO THREAD ROLLING,\"2,000.00\",\"2,000.00\",05.06.2021,0,AMIT SHARMA,MT02,M-3449\n100070356,M02SB001,C-M-219-0286-04,SB01 SHOT BLASTING,7.2,PINION KICK STARTER UPTO SHOT BLASTING,\"15,911.00\",\"4,420.00\",07.06.2021,\"11,491.00\",UDAY THAKUR,MT02,M-0286\n100070512,M02SB001,C-M-219-0286-04,SB01 SHOT BLASTING,7.2,PINION KICK STARTER UPTO SHOT BLASTING,\"29,975.00\",\"1,600.00\",10.06.2021,\"28,375.00\",UDAY THAKUR,MT02,M-0286\n100070356,M02PH001,C-M-219-0286-05,PT PHOSPHATING TANKS,2,PINION KICK STARTER UPTO ZINK PH. & SOAP,\"31,861.00\",\"6,020.00\",07.06.2021,\"25,841.00\",UDAY THAKUR,MT02,M-0286\n100070356,M02KP003,C-M-219-0286-06,KP03 COLD FORGING,8,PINION KICK STARTER UPTO RT.COLD FORGING,\"31,861.00\",\"6,020.00\",07.06.2021,\"25,841.00\",UDAY THAKUR,MT02,M-0286\n100070420,M02CN001,C-M-219-0286-07,CNC01 TURNING CENTRE,55,PINION KICK STARTER UPTO CNC TURNING 1ST,\"12,501.00\",\"1,472.00\",08.06.2021,\"11,029.00\",ASHOK THAKUR,MT02,M-0286\n100070420,M02CN002,C-M-219-0286-07,CNC02 TURNING CENTRE,55,PINION KICK STARTER UPTO CNC TURNING 1ST,\"10,000.00\",\"1,611.00\",08.06.2021,\"8,389.00\",ASHOK THAKUR,MT02,M-0286\n100070420,M02CN005,C-M-219-0286-07,CNC05 TURNING CENTRE,65,PINION KICK STARTER UPTO CNC TURNING 1ST,\"5,000.00\",\"1,393.00\",08.06.2021,\"3,607.00\",ASHOK THAKUR,MT02,M-0286\n100070420,M02CN006,C-M-219-0286-07,CNC06 TURNING CENTRE,65,PINION KICK STARTER UPTO CNC TURNING 1ST,\"5,000.00\",\"1,599.00\",08.06.2021,\"3,401.00\",ASHOK THAKUR,MT02,M-0286\n100070420,M02CN003,C-M-219-0286-08,CNC03 TURNING CENTRE,60,PINION KICK STARTER UPTO CNC TURNING 2ND,\"12,862.00\",\"1,402.00\",08.06.2021,\"11,460.00\",ASHOK THAKUR,MT02,M-0286\n100070420,M02CN004,C-M-219-0286-08,CNC04 TURNING CENTRE,60,PINION KICK STARTER UPTO CNC TURNING 2ND,\"10,000.00\",\"1,661.00\",08.06.2021,\"8,339.00\",ASHOK THAKUR,MT02,M-0286\n100070420,M02CN007,C-M-219-0286-08,CNC07 TURNING CENTRE,60,PINION KICK STARTER UPTO CNC TURNING 2ND,\"5,000.00\",\"1,671.00\",08.06.2021,\"3,329.00\",ASHOK THAKUR,MT02,M-0286\n100070420,M02CN008,C-M-219-0286-08,CNC08 TURNING CENTRE,60,PINION KICK STARTER UPTO CNC TURNING 2ND,\"5,000.00\",\"1,336.00\",08.06.2021,\"3,664.00\",ASHOK THAKUR,MT02,M-0286\n100070420,M02HB004,C-M-219-0286-09,M02HB004-HOBBING,25,PINION KICK STARTER UPTO GEAR CUTTING,\"33,817.00\",\"5,450.00\",08.06.2021,\"28,367.00\",RAJA BABU,MT02,M-0286\n100070374,M02GCF02,C-M-219-0286-10,GCF02 GAS CARBURISING FURNACE,14,PINION KICK STARTER UPTO HT,\"3,500.00\",\"3,200.00\",07.06.2021,300,PAWAN,MT02,M-0286\n100070319,M02SB002,C-M-219-0286-11,SB02 SHOT BLASTING,2,PINION KICK STARTER UPTO SHOT BLASTING,\"35,001.00\",\"4,691.00\",05.06.2021,\"30,310.00\",UDAY THAKUR,MT02,M-0286","output":"str","x":890,"y":380,"wires":[["7ddf90a6.8b04","22f4750f.3db1ca"]]},{"id":"436c5bc9.701274","type":"link in","z":"87ac3b01.909018","name":"","links":["c85b3567.5fcb08"],"x":1335,"y":520,"wires":[["bb9bd21e.76328"]]},{"id":"bb9bd21e.76328","type":"function","z":"87ac3b01.909018","name":"lookup (all rows)","func":"var data = msg.payload;\nvar map = {};\nfor (let index = 0; index < data.length; index++) {\n    const element = data[index];\n    map[element.Work_Center] = element.Order_No;\n    map[element.Work_Center] = element.Work_Center;\n    map[element.Work_Center] = element.Material;\n    map[element.Work_Center] = element.Work_Center_Description;\n    map[element.Work_Center] = element.Cycle_TIme;\n    map[element.Work_Center] = element.Material_Description;\n    map[element.Work_Center] = element.Order_Qty;\n    map[element.Work_Center] = element.Confirm_Qty;\n    map[element.Work_Center] = element.Creation_date;\n    map[element.Work_Center] = element.Pending_Qty;\n    map[element.Work_Center] = element.Person_Responsible;\n    map[element.Work_Center] = element.Plant;\n    map[element.Work_Center] = element.Drg_No;\n}\nmsg.payload = map;\nreturn msg;","outputs":1,"noerr":0,"initialize":"","finalize":"","libs":[],"x":1460,"y":520,"wires":[["ea66fdd4.ce5d5"]]},{"id":"f9e41b13.1fe7a8","type":"ui_group","name":"Group 1","tab":"74fd02f9.b99b3c","order":2,"disp":false,"width":28,"collapse":false},{"id":"74fd02f9.b99b3c","type":"ui_tab","name":"Breakdown entry form","icon":"dashboard","order":1,"disabled":false,"hidden":false}]

what needed to be done was to first select "work center" then only filtered "order no" are pushed from the same csv file in "order no" dropdown and table node.

4

I can not help with ui-table as i do not use it and it is not in my pallete, But to selrct a work_center then filter all items that contain the work_center i would try somthing like this.

It reads the whole csv file in to a flow context so is available later, then it creates a distinct option list, after you select a option it will filter the csv context store and return all items with the selected work_center

[{"id":"c3dde40.59c29a","type":"inject","z":"c74669a0.6a34f8","name":"","props":[{"p":"payload"},{"p":"topic","vt":"str"}],"repeat":"","crontab":"","once":false,"onceDelay":0.1,"topic":"","payload":"","payloadType":"date","x":810,"y":3920,"wires":[["fd05c75f.929ed"]]},{"id":"fd05c75f.929ed","type":"template","z":"c74669a0.6a34f8","name":"simulate file","field":"payload","fieldType":"msg","format":"handlebars","syntax":"mustache","template":"Order_No,Work_Center,Material,Work_Center_Description,Cycle_TIme,Material_Description,Order_Qty,Confirm_Qty,Creation_date,Pending_Qty,Person_Responsible,Plant,Drg_No\n,,,,,,,,,,,,\n100070432,M02HD008,C-M-201-0696-01,HD008 HEADER,3,SHAFT SWING ARM UPTO COLD FORGING,750,750,08.06.2021,0,RAM SINGH,MT02,M-0696\n100070441,M02MBF01,C-M-201-3449-02,MBF1 MBF HARDENING & WASHING,1.67,BOLT SWING ARM PIVOT UPTO HT,\"3,000.00\",\"1,076.00\",08.06.2021,\"1,924.00\",PAWAN,MT02,M-3449\n100070296,M02MBF01,C-M-201-3449-02,MBF1 MBF HARDENING & WASHING,1.67,BOLT SWING ARM PIVOT UPTO HT,\"2,000.00\",\"2,000.00\",05.06.2021,0,PAWAN,MT02,M-3449\n100070441,M02ST003,C-M-201-3449-03,ST03 STRAIGHTENING,8,BOLT SWING ARM PIVOT UPTO STRAIGHTENING,\"3,000.00\",\"1,076.00\",08.06.2021,\"1,924.00\",AMIT SHARMA,MT02,M-3449\n100070296,M02ST003,C-M-201-3449-03,ST03 STRAIGHTENING,8,BOLT SWING ARM PIVOT UPTO STRAIGHTENING,\"2,000.00\",\"2,000.00\",05.06.2021,0,AMIT SHARMA,MT02,M-3449\n100070297,M02CL013,C-M-201-3449-04,CL13 CENTRE LESS GRINDER,7,BOLT SWING ARM PIVOT UPTO DIA HALF GRIND,\"2,000.00\",\"2,000.00\",05.06.2021,0,AMIT SHARMA,MT02,M-3449\n100070441,M02CL013,C-M-201-3449-04,CL13 CENTRE LESS GRINDER,7,BOLT SWING ARM PIVOT UPTO DIA HALF GRIND,\"3,000.00\",\"1,076.00\",08.06.2021,\"1,924.00\",AMIT SHARMA,MT02,M-3449\n100070297,M02CL013,C-M-201-3449-05,CL13 CENTRE LESS GRINDER,6,BOLT SWING ARM PIVOT UPTO DIA FINAL GRIN,\"2,000.00\",\"2,000.00\",05.06.2021,0,AMIT SHARMA,MT02,M-3449\n100070441,M02CL013,C-M-201-3449-05,CL13 CENTRE LESS GRINDER,6,BOLT SWING ARM PIVOT UPTO DIA FINAL GRIN,\"3,000.00\",\"1,076.00\",08.06.2021,\"1,924.00\",AMIT SHARMA,MT02,M-3449\n100070441,M02TR007,C-M-201-3449-06,TR07 THREAD ROLLING,7,BOLT SWING ARM PIVOT UPTO THREAD ROLLING,\"3,000.00\",\"1,076.00\",08.06.2021,\"1,924.00\",AMIT SHARMA,MT02,M-3449\n100070298,M02TR007,C-M-201-3449-06,TR07 THREAD ROLLING,7,BOLT SWING ARM PIVOT UPTO THREAD ROLLING,\"2,000.00\",\"2,000.00\",05.06.2021,0,AMIT SHARMA,MT02,M-3449\n100070356,M02SB001,C-M-219-0286-04,SB01 SHOT BLASTING,7.2,PINION KICK STARTER UPTO SHOT BLASTING,\"15,911.00\",\"4,420.00\",07.06.2021,\"11,491.00\",UDAY THAKUR,MT02,M-0286","output":"str","x":540,"y":3980,"wires":[["d0018ced.2cf488"]]},{"id":"d0018ced.2cf488","type":"csv","z":"c74669a0.6a34f8","name":"","sep":",","hdrin":true,"hdrout":"none","multi":"mult","ret":"\\n","temp":"","skip":"0","strings":true,"include_empty_strings":"","include_null_values":"","x":680,"y":3980,"wires":[["820afc77.1e9bc8"]]},{"id":"820afc77.1e9bc8","type":"change","z":"c74669a0.6a34f8","name":"","rules":[{"t":"set","p":"options","pt":"msg","to":"$distinct(payload.Work_Center)","tot":"jsonata"},{"t":"move","p":"payload","pt":"msg","to":"csv","tot":"flow"}],"action":"","property":"","from":"","to":"","reg":false,"x":840,"y":3980,"wires":[["e53bd114.f9acb8","c9cbf2a7.d15558"]]},{"id":"e53bd114.f9acb8","type":"debug","z":"c74669a0.6a34f8","name":"","active":true,"tosidebar":true,"console":false,"tostatus":false,"complete":"true","targetType":"full","statusVal":"","statusType":"auto","x":1060,"y":3940,"wires":[]},{"id":"c9cbf2a7.d15558","type":"ui_dropdown","z":"c74669a0.6a34f8","name":"Work center","label":"Work center","tooltip":"","place":"select","group":"acbd28dd.7cd108","order":1,"width":"6","height":"1","passthru":false,"multiple":false,"options":[{"label":"","value":"","type":"str"}],"payload":"","topic":"work_center","topicType":"str","x":1060,"y":4000,"wires":[["faba6afd.35691"]]},{"id":"faba6afd.35691","type":"change","z":"c74669a0.6a34f8","name":"","rules":[{"t":"set","p":"payload","pt":"msg","to":"$flowContext(\"csv\")[Work_Center = $$.payload] ","tot":"jsonata"}],"action":"","property":"","from":"","to":"","reg":false,"x":1270,"y":4000,"wires":[["ee68386.ffa6848"]]},{"id":"ee68386.ffa6848","type":"debug","z":"c74669a0.6a34f8","name":"","active":true,"tosidebar":true,"console":false,"tostatus":false,"complete":"true","targetType":"full","statusVal":"","statusType":"auto","x":1320,"y":4080,"wires":[]},{"id":"acbd28dd.7cd108","type":"ui_group","name":"Group 2","tab":"74fd02f9.b99b3c","order":1,"disp":true,"width":6},{"id":"74fd02f9.b99b3c","type":"ui_tab","name":"Breakdown entry form","icon":"dashboard","order":1,"disabled":false,"hidden":false}]
5

Thankyou again. Its working perfectly now :+1:.
But there is one issue with table node. It doesn't seem to show filtered row values for some "Work_center". If possible, can you check?

[{"id":"8a0d9c0a.1704a","type":"inject","z":"f23392c0.2a45e","name":"","props":[{"p":"payload"},{"p":"topic","vt":"str"}],"repeat":"","crontab":"","once":false,"onceDelay":0.1,"topic":"","payload":"","payloadType":"date","x":240,"y":1200,"wires":[["4d66326e.76746c"]]},{"id":"23b6b0ea.4cc8c","type":"csv","z":"f23392c0.2a45e","name":"","sep":",","hdrin":true,"hdrout":"none","multi":"mult","ret":"\\n","temp":"","skip":"0","strings":true,"include_empty_strings":"","include_null_values":"","x":390,"y":1280,"wires":[["1fd4cfc3.a29c5"]]},{"id":"1fd4cfc3.a29c5","type":"change","z":"f23392c0.2a45e","name":"","rules":[{"t":"set","p":"options","pt":"msg","to":"$distinct(payload.Work_Center)","tot":"jsonata"},{"t":"move","p":"payload","pt":"msg","to":"csv","tot":"flow"}],"action":"","property":"","from":"","to":"","reg":false,"x":480,"y":1320,"wires":[["3a1342a3.c06d6e"]]},{"id":"3a1342a3.c06d6e","type":"ui_dropdown","z":"f23392c0.2a45e","name":"Work center","label":"Work center","tooltip":"","place":"select","group":"acbd28dd.7cd108","order":1,"width":6,"height":1,"passthru":false,"multiple":false,"options":[{"label":"","value":"","type":"str"}],"payload":"","topic":"work_center","topicType":"str","x":570,"y":1360,"wires":[["1b8c76ab.304b09"]]},{"id":"1b8c76ab.304b09","type":"change","z":"f23392c0.2a45e","name":"","rules":[{"t":"set","p":"payload","pt":"msg","to":"$flowContext(\"csv\")[Work_Center = $$.payload] ","tot":"jsonata"}],"action":"","property":"","from":"","to":"","reg":false,"x":660,"y":1420,"wires":[["d295fa0e.76cdb8","f5cbb00b.4f26f"]]},{"id":"d295fa0e.76cdb8","type":"change","z":"f23392c0.2a45e","name":"","rules":[{"t":"set","p":"options","pt":"msg","to":"$distinct(payload.Order_No)","tot":"jsonata"}],"action":"","property":"","from":"","to":"","reg":false,"x":760,"y":1460,"wires":[["1e0aaabf.df96b5"]]},{"id":"1e0aaabf.df96b5","type":"ui_dropdown","z":"f23392c0.2a45e","name":"","label":"Order No.","tooltip":"","place":"Select","group":"acbd28dd.7cd108","order":2,"width":6,"height":1,"passthru":false,"multiple":false,"options":[{"label":"","value":"","type":"str"}],"payload":"","topic":"order_no","topicType":"msg","x":860,"y":1500,"wires":[[]]},{"id":"4d66326e.76746c","type":"template","z":"f23392c0.2a45e","name":"simulate file","field":"payload","fieldType":"msg","format":"handlebars","syntax":"mustache","template":"Order_No,Work_Center,Material,Work_Center_Description,Cycle_TIme,Material_Description,Order_Qty,Confirm_Qty,Creation_date,Pending_Qty,Person_Responsible,Plant,Drg_No\n,,,,,,,,,,,,\n100070432,M02HD008,C-M-201-0696-01,HD008 HEADER,3,SHAFT SWING ARM UPTO COLD FORGING,750,750,08.06.2021,0,RAM SINGH,MT02,M-0696\n100070441,M02MBF01,C-M-201-3449-02,MBF1 MBF HARDENING & WASHING,1.67,BOLT SWING ARM PIVOT UPTO HT,\"3,000.00\",\"1,076.00\",08.06.2021,\"1,924.00\",PAWAN,MT02,M-3449\n100070296,M02MBF01,C-M-201-3449-02,MBF1 MBF HARDENING & WASHING,1.67,BOLT SWING ARM PIVOT UPTO HT,\"2,000.00\",\"2,000.00\",05.06.2021,0,PAWAN,MT02,M-3449\n100070441,M02ST003,C-M-201-3449-03,ST03 STRAIGHTENING,8,BOLT SWING ARM PIVOT UPTO STRAIGHTENING,\"3,000.00\",\"1,076.00\",08.06.2021,\"1,924.00\",AMIT SHARMA,MT02,M-3449\n100070296,M02ST003,C-M-201-3449-03,ST03 STRAIGHTENING,8,BOLT SWING ARM PIVOT UPTO STRAIGHTENING,\"2,000.00\",\"2,000.00\",05.06.2021,0,AMIT SHARMA,MT02,M-3449\n100070297,M02CL013,C-M-201-3449-04,CL13 CENTRE LESS GRINDER,7,BOLT SWING ARM PIVOT UPTO DIA HALF GRIND,\"2,000.00\",\"2,000.00\",05.06.2021,0,AMIT SHARMA,MT02,M-3449\n100070441,M02CL013,C-M-201-3449-04,CL13 CENTRE LESS GRINDER,7,BOLT SWING ARM PIVOT UPTO DIA HALF GRIND,\"3,000.00\",\"1,076.00\",08.06.2021,\"1,924.00\",AMIT SHARMA,MT02,M-3449\n100070297,M02CL013,C-M-201-3449-05,CL13 CENTRE LESS GRINDER,6,BOLT SWING ARM PIVOT UPTO DIA FINAL GRIN,\"2,000.00\",\"2,000.00\",05.06.2021,0,AMIT SHARMA,MT02,M-3449\n100070441,M02CL013,C-M-201-3449-05,CL13 CENTRE LESS GRINDER,6,BOLT SWING ARM PIVOT UPTO DIA FINAL GRIN,\"3,000.00\",\"1,076.00\",08.06.2021,\"1,924.00\",AMIT SHARMA,MT02,M-3449\n100070441,M02TR007,C-M-201-3449-06,TR07 THREAD ROLLING,7,BOLT SWING ARM PIVOT UPTO THREAD ROLLING,\"3,000.00\",\"1,076.00\",08.06.2021,\"1,924.00\",AMIT SHARMA,MT02,M-3449\n100070298,M02TR007,C-M-201-3449-06,TR07 THREAD ROLLING,7,BOLT SWING ARM PIVOT UPTO THREAD ROLLING,\"2,000.00\",\"2,000.00\",05.06.2021,0,AMIT SHARMA,MT02,M-3449\n100070356,M02SB001,C-M-219-0286-04,SB01 SHOT BLASTING,7.2,PINION KICK STARTER UPTO SHOT BLASTING,\"15,911.00\",\"4,420.00\",07.06.2021,\"11,491.00\",UDAY THAKUR,MT02,M-0286\n100070512,M02SB001,C-M-219-0286-04,SB01 SHOT BLASTING,7.2,PINION KICK STARTER UPTO SHOT BLASTING,\"29,975.00\",\"1,600.00\",10.06.2021,\"28,375.00\",UDAY THAKUR,MT02,M-0286\n100070356,M02PH001,C-M-219-0286-05,PT PHOSPHATING TANKS,2,PINION KICK STARTER UPTO ZINK PH. & SOAP,\"31,861.00\",\"6,020.00\",07.06.2021,\"25,841.00\",UDAY THAKUR,MT02,M-0286\n100070356,M02KP003,C-M-219-0286-06,KP03 COLD FORGING,8,PINION KICK STARTER UPTO RT.COLD FORGING,\"31,861.00\",\"6,020.00\",07.06.2021,\"25,841.00\",UDAY THAKUR,MT02,M-0286\n100070420,M02CN001,C-M-219-0286-07,CNC01 TURNING CENTRE,55,PINION KICK STARTER UPTO CNC TURNING 1ST,\"12,501.00\",\"1,472.00\",08.06.2021,\"11,029.00\",ASHOK THAKUR,MT02,M-0286\n100070420,M02CN002,C-M-219-0286-07,CNC02 TURNING CENTRE,55,PINION KICK STARTER UPTO CNC TURNING 1ST,\"10,000.00\",\"1,611.00\",08.06.2021,\"8,389.00\",ASHOK THAKUR,MT02,M-0286\n100070420,M02CN005,C-M-219-0286-07,CNC05 TURNING CENTRE,65,PINION KICK STARTER UPTO CNC TURNING 1ST,\"5,000.00\",\"1,393.00\",08.06.2021,\"3,607.00\",ASHOK THAKUR,MT02,M-0286\n100070420,M02CN006,C-M-219-0286-07,CNC06 TURNING CENTRE,65,PINION KICK STARTER UPTO CNC TURNING 1ST,\"5,000.00\",\"1,599.00\",08.06.2021,\"3,401.00\",ASHOK THAKUR,MT02,M-0286\n100070420,M02CN003,C-M-219-0286-08,CNC03 TURNING CENTRE,60,PINION KICK STARTER UPTO CNC TURNING 2ND,\"12,862.00\",\"1,402.00\",08.06.2021,\"11,460.00\",ASHOK THAKUR,MT02,M-0286\n100070420,M02CN004,C-M-219-0286-08,CNC04 TURNING CENTRE,60,PINION KICK STARTER UPTO CNC TURNING 2ND,\"10,000.00\",\"1,661.00\",08.06.2021,\"8,339.00\",ASHOK THAKUR,MT02,M-0286\n100070420,M02CN007,C-M-219-0286-08,CNC07 TURNING CENTRE,60,PINION KICK STARTER UPTO CNC TURNING 2ND,\"5,000.00\",\"1,671.00\",08.06.2021,\"3,329.00\",ASHOK THAKUR,MT02,M-0286\n100070420,M02CN008,C-M-219-0286-08,CNC08 TURNING CENTRE,60,PINION KICK STARTER UPTO CNC TURNING 2ND,\"5,000.00\",\"1,336.00\",08.06.2021,\"3,664.00\",ASHOK THAKUR,MT02,M-0286\n100070420,M02HB004,C-M-219-0286-09,M02HB004-HOBBING,25,PINION KICK STARTER UPTO GEAR CUTTING,\"33,817.00\",\"5,450.00\",08.06.2021,\"28,367.00\",RAJA BABU,MT02,M-0286\n100070374,M02GCF02,C-M-219-0286-10,GCF02 GAS CARBURISING FURNACE,14,PINION KICK STARTER UPTO HT,\"3,500.00\",\"3,200.00\",07.06.2021,300,PAWAN,MT02,M-0286\n100070319,M02SB002,C-M-219-0286-11,SB02 SHOT BLASTING,2,PINION KICK STARTER UPTO SHOT BLASTING,\"35,001.00\",\"4,691.00\",05.06.2021,\"30,310.00\",UDAY THAKUR,MT02,M-0286","output":"str","x":330,"y":1240,"wires":[["23b6b0ea.4cc8c"]]},{"id":"f5cbb00b.4f26f","type":"ui_table","z":"f23392c0.2a45e","group":"acbd28dd.7cd108","name":"","order":4,"width":24,"height":3,"columns":[],"outputs":0,"cts":false,"x":910,"y":1420,"wires":[]},{"id":"acbd28dd.7cd108","type":"ui_group","name":"Group 2","tab":"74fd02f9.b99b3c","order":1,"disp":true,"width":24},{"id":"74fd02f9.b99b3c","type":"ui_tab","name":"Breakdown entry form","icon":"dashboard","order":1,"disabled":false,"hidden":false}]
6

@E1cid, I was trying to find a way to improve. But unable to. Asking for help again.

there is one thing I noticed, where there is only one value of "work center", value is not pushed to "Order No." dropdown.

[{"id":"fd20beb2.0d957","type":"tab","label":"Breakdown form","disabled":false,"info":""},{"id":"e642510e.a315f","type":"ui_text","z":"fd20beb2.0d957","group":"162e61a9.5d8dee","order":2,"width":4,"height":1,"name":"","label":"Posting Date  :","format":"{{msg.payload}}","layout":"row-left","x":680,"y":120,"wires":[]},{"id":"1096e6ce.85eff9","type":"inject","z":"fd20beb2.0d957","name":"","props":[{"p":"payload"},{"p":"topic","vt":"str"}],"repeat":"","crontab":"","once":true,"onceDelay":0.1,"topic":"","payload":"","payloadType":"date","x":370,"y":120,"wires":[["68733109.54d2e"]]},{"id":"2ddf0d85.ea1dc2","type":"ui_dropdown","z":"fd20beb2.0d957","name":"","label":"Shift","tooltip":"","place":"Select shift","group":"f9e41b13.1fe7a8","order":7,"width":4,"height":1,"passthru":false,"multiple":false,"options":[{"label":"A","value":"A","type":"str"},{"label":"B","value":"B","type":"str"}],"payload":"","topic":"topic","topicType":"msg","x":730,"y":700,"wires":[["d355d09b.6f24"]]},{"id":"f24d7e50.20701","type":"ui_text_input","z":"fd20beb2.0d957","name":"Start Time","label":"Start Time","tooltip":"Start Time","group":"f9e41b13.1fe7a8","order":5,"width":3,"height":1,"passthru":false,"mode":"time","delay":300,"topic":"Start_Time","topicType":"str","x":740,"y":820,"wires":[["d0bf4f47.05a94"]]},{"id":"d7e88a39.a6de98","type":"ui_date_picker","z":"fd20beb2.0d957","name":"","label":"Start date","group":"f9e41b13.1fe7a8","order":6,"width":5,"height":1,"passthru":false,"topic":"Start_date","topicType":"str","x":740,"y":740,"wires":[["b1955da5.c99f6"]]},{"id":"a169e909.f6b518","type":"ui_date_picker","z":"fd20beb2.0d957","name":"","label":"End date","group":"f9e41b13.1fe7a8","order":11,"width":5,"height":1,"passthru":false,"topic":"End_date","topicType":"str","x":740,"y":780,"wires":[["f089f523.5724c8"]]},{"id":"c2411f69.be4d4","type":"ui_text_input","z":"fd20beb2.0d957","name":"End Time","label":"End Time","tooltip":"End Time","group":"f9e41b13.1fe7a8","order":10,"width":3,"height":1,"passthru":false,"mode":"time","delay":300,"topic":"End_Time","topicType":"str","x":740,"y":860,"wires":[["99726772.f027f8"]]},{"id":"b1955da5.c99f6","type":"change","z":"fd20beb2.0d957","name":"dd-mm-yyyy","rules":[{"t":"set","p":"payload","pt":"msg","to":"$moment(payload).tz(\"Europe/London\").format(\"DD-MM-YYYY\")","tot":"jsonata"}],"action":"","property":"","from":"","to":"","reg":false,"x":890,"y":740,"wires":[["85d6eb3f.62b3e8"]]},{"id":"d0bf4f47.05a94","type":"change","z":"fd20beb2.0d957","name":"hh:mm","rules":[{"t":"set","p":"payload","pt":"msg","to":"$moment(payload).tz(\"Europe/London\").format(\"HH:mm\")","tot":"jsonata"}],"action":"","property":"","from":"","to":"","reg":false,"x":890,"y":820,"wires":[["e89682fb.4764b"]]},{"id":"f089f523.5724c8","type":"change","z":"fd20beb2.0d957","name":"dd-mm-yyyy","rules":[{"t":"set","p":"payload","pt":"msg","to":"$moment(payload).tz(\"Europe/London\").format(\"DD-MM-YYYY\")","tot":"jsonata"}],"action":"","property":"","from":"","to":"","reg":false,"x":890,"y":780,"wires":[["9a6e14f2.84f4d8"]]},{"id":"99726772.f027f8","type":"change","z":"fd20beb2.0d957","name":"hh:mm","rules":[{"t":"set","p":"payload","pt":"msg","to":"$moment(payload).tz(\"Europe/London\").format(\"HH:mm\")","tot":"jsonata"}],"action":"","property":"","from":"","to":"","reg":false,"x":890,"y":860,"wires":[["7c159c3b.fce3f4"]]},{"id":"c971cce5.88a9c","type":"ui_dropdown","z":"fd20beb2.0d957","name":"Breakdown reasons","label":"Breakdown reason","tooltip":"Breakdown reason","place":"Select Breakdown reason","group":"f9e41b13.1fe7a8","order":8,"width":10,"height":1,"passthru":false,"multiple":false,"options":[{"label":"","value":"","type":"str"}],"payload":"","topic":"Breakdown reason","topicType":"str","x":770,"y":900,"wires":[["836c5773.159a68"]]},{"id":"2d869a98.7e0f16","type":"ui_button","z":"fd20beb2.0d957","name":"","group":"f9e41b13.1fe7a8","order":14,"width":5,"height":1,"passthru":false,"label":"Submit","tooltip":"","color":"","bgcolor":"","icon":"","payload":"complete","payloadType":"str","topic":"","topicType":"str","x":730,"y":1000,"wires":[["16c6115f.e5bcbf","ba495f3d.bc474"]]},{"id":"179bd0b8.89044f","type":"ui_table","z":"fd20beb2.0d957","group":"5179bc3b.985dd4","name":"submition report","order":1,"width":24,"height":2,"columns":[],"outputs":0,"cts":false,"x":1080,"y":1080,"wires":[]},{"id":"1c233064.2dd4b","type":"join","z":"fd20beb2.0d957","name":"","mode":"custom","build":"object","property":"payload","propertyType":"msg","key":"topic","joiner":"\\n","joinerType":"str","accumulate":false,"timeout":"","count":"","reduceRight":false,"reduceExp":"","reduceInit":"","reduceInitType":"","reduceFixup":"","x":1550,"y":600,"wires":[["591598f1.fefd78"]]},{"id":"41e4ff59.840ee","type":"link in","z":"fd20beb2.0d957","name":"","links":["9dc0d65b.64a128"],"x":235,"y":760,"wires":[["91f54c58.30a4f"]]},{"id":"9dc0d65b.64a128","type":"link out","z":"fd20beb2.0d957","name":"","links":["41e4ff59.840ee","94d212c4.a29e7","e3856566.ca5c08","7da48f3f.4c714","dde9f2ca.adb85","79be03db.31abbc","65294a89.62e3a4"],"x":1295,"y":1020,"wires":[]},{"id":"16c6115f.e5bcbf","type":"change","z":"fd20beb2.0d957","name":"","rules":[{"t":"move","p":"payload","pt":"msg","to":"complete","tot":"msg"}],"action":"","property":"","from":"","to":"","reg":false,"x":990,"y":980,"wires":[["3a9eda1f.4a1a96"]]},{"id":"ba495f3d.bc474","type":"change","z":"fd20beb2.0d957","name":"","rules":[{"t":"set","p":"payload","pt":"msg","to":"[]","tot":"json"}],"action":"","property":"","from":"","to":"","reg":false,"x":980,"y":1020,"wires":[["9786f876.7c39f8"]]},{"id":"9786f876.7c39f8","type":"delay","z":"fd20beb2.0d957","name":"","pauseType":"delay","timeout":"2","timeoutUnits":"seconds","rate":"1","nbRateUnits":"1","rateUnits":"second","randomFirst":"1","randomLast":"5","randomUnits":"seconds","drop":false,"x":1160,"y":1020,"wires":[["9dc0d65b.64a128"]]},{"id":"91f54c58.30a4f","type":"change","z":"fd20beb2.0d957","name":"0","rules":[{"t":"set","p":"payload","pt":"msg","to":"0","tot":"str"}],"action":"","property":"","from":"","to":"","reg":false,"x":350,"y":760,"wires":[["44b2d22d.00d21c"]]},{"id":"5521cf97.4e1f3","type":"file","z":"fd20beb2.0d957","name":"breakdown.csv","filename":"D:\\testing\\breakdown.csv","appendNewline":true,"createDir":true,"overwriteFile":"false","encoding":"none","x":1720,"y":680,"wires":[[]]},{"id":"1959427e.99693e","type":"file in","z":"fd20beb2.0d957","name":"submition report","filename":"D:\\testing\\breakdown.csv","format":"utf8","chunk":false,"sendError":false,"encoding":"none","x":760,"y":1080,"wires":[["d46547e6.219768"]]},{"id":"d46547e6.219768","type":"csv","z":"fd20beb2.0d957","name":"","sep":",","hdrin":true,"hdrout":"all","multi":"mult","ret":"\\r\\n","temp":"","skip":"0","strings":true,"include_empty_strings":false,"include_null_values":false,"x":930,"y":1080,"wires":[["179bd0b8.89044f"]]},{"id":"a070bbc0.398b58","type":"link in","z":"fd20beb2.0d957","name":"","links":["85d6eb3f.62b3e8","9a6e14f2.84f4d8","e89682fb.4764b","7c159c3b.fce3f4","3a9eda1f.4a1a96","836c5773.159a68","d355d09b.6f24","c86609ae.3ef4a8","15cf1cb5.9f2453","a9ee1664.b911e8"],"x":1435,"y":600,"wires":[["1c233064.2dd4b"]]},{"id":"e89682fb.4764b","type":"link out","z":"fd20beb2.0d957","name":"","links":["a070bbc0.398b58"],"x":1015,"y":820,"wires":[]},{"id":"7c159c3b.fce3f4","type":"link out","z":"fd20beb2.0d957","name":"","links":["a070bbc0.398b58"],"x":1015,"y":860,"wires":[]},{"id":"85d6eb3f.62b3e8","type":"link out","z":"fd20beb2.0d957","name":"","links":["a070bbc0.398b58"],"x":1015,"y":740,"wires":[]},{"id":"9a6e14f2.84f4d8","type":"link out","z":"fd20beb2.0d957","name":"","links":["a070bbc0.398b58"],"x":1015,"y":780,"wires":[]},{"id":"3a9eda1f.4a1a96","type":"link out","z":"fd20beb2.0d957","name":"","links":["a070bbc0.398b58","17095bbc.9cf004"],"x":1295,"y":980,"wires":[]},{"id":"836c5773.159a68","type":"link out","z":"fd20beb2.0d957","name":"","links":["a070bbc0.398b58"],"x":1015,"y":900,"wires":[]},{"id":"17922f4d.528801","type":"link in","z":"fd20beb2.0d957","name":"","links":["44b2d22d.00d21c"],"x":615,"y":820,"wires":[["f24d7e50.20701"]]},{"id":"90f2659f.56d478","type":"link in","z":"fd20beb2.0d957","name":"","links":["44b2d22d.00d21c"],"x":615,"y":860,"wires":[["c2411f69.be4d4"]]},{"id":"94d212c4.a29e7","type":"link in","z":"fd20beb2.0d957","name":"","links":["9dc0d65b.64a128"],"x":615,"y":900,"wires":[["c971cce5.88a9c"]]},{"id":"e3856566.ca5c08","type":"link in","z":"fd20beb2.0d957","name":"","links":["9dc0d65b.64a128"],"x":615,"y":700,"wires":[["2ddf0d85.ea1dc2"]]},{"id":"d355d09b.6f24","type":"link out","z":"fd20beb2.0d957","name":"","links":["a070bbc0.398b58"],"x":1015,"y":700,"wires":[]},{"id":"44b2d22d.00d21c","type":"link out","z":"fd20beb2.0d957","name":"","links":["1f7daa37.40f246","42eeac3b.95d984","17922f4d.528801","90f2659f.56d478"],"x":495,"y":760,"wires":[]},{"id":"1f7daa37.40f246","type":"link in","z":"fd20beb2.0d957","name":"","links":["44b2d22d.00d21c"],"x":615,"y":740,"wires":[["d7e88a39.a6de98"]]},{"id":"42eeac3b.95d984","type":"link in","z":"fd20beb2.0d957","name":"","links":["44b2d22d.00d21c"],"x":615,"y":780,"wires":[["a169e909.f6b518"]]},{"id":"c86609ae.3ef4a8","type":"link out","z":"fd20beb2.0d957","name":"","links":["a070bbc0.398b58"],"x":615,"y":160,"wires":[]},{"id":"60f09522.e8671c","type":"inject","z":"fd20beb2.0d957","name":"","props":[{"p":"payload"},{"p":"topic","vt":"str"}],"repeat":"","crontab":"","once":false,"onceDelay":0.1,"topic":"","payload":"","payloadType":"date","x":400,"y":300,"wires":[["bf869068.10bd8"]]},{"id":"46ac76f4.f36438","type":"csv","z":"fd20beb2.0d957","name":"","sep":",","hdrin":true,"hdrout":"none","multi":"mult","ret":"\\n","temp":"","skip":"0","strings":true,"include_empty_strings":"","include_null_values":"","x":630,"y":340,"wires":[["ca7ca7d8.7631b8","1d28056e.47670b"]]},{"id":"ca7ca7d8.7631b8","type":"change","z":"fd20beb2.0d957","name":"","rules":[{"t":"set","p":"options","pt":"msg","to":"$distinct(payload.Work_Center)","tot":"jsonata"},{"t":"move","p":"payload","pt":"msg","to":"csv","tot":"flow"}],"action":"","property":"","from":"","to":"","reg":false,"x":720,"y":380,"wires":[["2bc4414e.fde82e"]]},{"id":"2bc4414e.fde82e","type":"ui_dropdown","z":"fd20beb2.0d957","name":"Work center","label":"Work center","tooltip":"","place":"select","group":"f9e41b13.1fe7a8","order":1,"width":7,"height":1,"passthru":false,"multiple":false,"options":[{"label":"","value":"","type":"str"}],"payload":"","topic":"Work_Center","topicType":"str","x":790,"y":420,"wires":[["4be64f55.71cbd","15cf1cb5.9f2453"]]},{"id":"4be64f55.71cbd","type":"change","z":"fd20beb2.0d957","name":"","rules":[{"t":"set","p":"payload","pt":"msg","to":"$flowContext(\"csv\")[Work_Center = $$.payload] ","tot":"jsonata"}],"action":"","property":"","from":"","to":"","reg":false,"x":900,"y":460,"wires":[["e78d2f1b.574a6","9615b085.4b0d9"]]},{"id":"21f43e84.8a0cf2","type":"file in","z":"fd20beb2.0d957","name":"mt02order","filename":"C:\\Users\\Sahil\\Desktop\\testing\\mt02order.csv","format":"utf8","chunk":false,"sendError":false,"encoding":"none","x":570,"y":260,"wires":[[]]},{"id":"e78d2f1b.574a6","type":"change","z":"fd20beb2.0d957","name":"","rules":[{"t":"set","p":"options","pt":"msg","to":"$distinct(payload.Order_No)","tot":"jsonata"}],"action":"","property":"","from":"","to":"","reg":false,"x":1000,"y":500,"wires":[["6be3db5b.c96fa4"]]},{"id":"6be3db5b.c96fa4","type":"ui_dropdown","z":"fd20beb2.0d957","name":"Order No.","label":"Order No.","tooltip":"","place":"Select","group":"f9e41b13.1fe7a8","order":2,"width":10,"height":1,"passthru":false,"multiple":false,"options":[{"label":"","value":"","type":"str"}],"payload":"","topic":"Order_No","topicType":"msg","x":1100,"y":540,"wires":[["a9ee1664.b911e8","61787a81.d26ae4"]]},{"id":"bf869068.10bd8","type":"template","z":"fd20beb2.0d957","name":"simulate file - mt02order","field":"payload","fieldType":"msg","format":"handlebars","syntax":"mustache","template":"Order_No,Work_Center,Material,Work_Center_Description,Cycle_TIme,Material_Description,Order_Qty,Confirm_Qty,Creation_date,Pending_Qty,Person_Responsible,Plant,Drg_No\n,,,,,,,,,,,,\n100070432,M02HD008,C-M-201-0696-01,HD008 HEADER,3,SHAFT SWING ARM UPTO COLD FORGING,750,750,08.06.2021,0,RAM SINGH,MT02,M-0696\n100070441,M02MBF01,C-M-201-3449-02,MBF1 MBF HARDENING & WASHING,1.67,BOLT SWING ARM PIVOT UPTO HT,\"3,000.00\",\"1,076.00\",08.06.2021,\"1,924.00\",PAWAN,MT02,M-3449\n100070296,M02MBF01,C-M-201-3449-02,MBF1 MBF HARDENING & WASHING,1.67,BOLT SWING ARM PIVOT UPTO HT,\"2,000.00\",\"2,000.00\",05.06.2021,0,PAWAN,MT02,M-3449\n100070441,M02ST003,C-M-201-3449-03,ST03 STRAIGHTENING,8,BOLT SWING ARM PIVOT UPTO STRAIGHTENING,\"3,000.00\",\"1,076.00\",08.06.2021,\"1,924.00\",AMIT SHARMA,MT02,M-3449\n100070296,M02ST003,C-M-201-3449-03,ST03 STRAIGHTENING,8,BOLT SWING ARM PIVOT UPTO STRAIGHTENING,\"2,000.00\",\"2,000.00\",05.06.2021,0,AMIT SHARMA,MT02,M-3449\n100070297,M02CL013,C-M-201-3449-04,CL13 CENTRE LESS GRINDER,7,BOLT SWING ARM PIVOT UPTO DIA HALF GRIND,\"2,000.00\",\"2,000.00\",05.06.2021,0,AMIT SHARMA,MT02,M-3449\n100070441,M02CL013,C-M-201-3449-04,CL13 CENTRE LESS GRINDER,7,BOLT SWING ARM PIVOT UPTO DIA HALF GRIND,\"3,000.00\",\"1,076.00\",08.06.2021,\"1,924.00\",AMIT SHARMA,MT02,M-3449\n100070297,M02CL013,C-M-201-3449-05,CL13 CENTRE LESS GRINDER,6,BOLT SWING ARM PIVOT UPTO DIA FINAL GRIN,\"2,000.00\",\"2,000.00\",05.06.2021,0,AMIT SHARMA,MT02,M-3449\n100070441,M02CL013,C-M-201-3449-05,CL13 CENTRE LESS GRINDER,6,BOLT SWING ARM PIVOT UPTO DIA FINAL GRIN,\"3,000.00\",\"1,076.00\",08.06.2021,\"1,924.00\",AMIT SHARMA,MT02,M-3449\n100070441,M02TR007,C-M-201-3449-06,TR07 THREAD ROLLING,7,BOLT SWING ARM PIVOT UPTO THREAD ROLLING,\"3,000.00\",\"1,076.00\",08.06.2021,\"1,924.00\",AMIT SHARMA,MT02,M-3449\n100070298,M02TR007,C-M-201-3449-06,TR07 THREAD ROLLING,7,BOLT SWING ARM PIVOT UPTO THREAD ROLLING,\"2,000.00\",\"2,000.00\",05.06.2021,0,AMIT SHARMA,MT02,M-3449\n100070356,M02SB001,C-M-219-0286-04,SB01 SHOT BLASTING,7.2,PINION KICK STARTER UPTO SHOT BLASTING,\"15,911.00\",\"4,420.00\",07.06.2021,\"11,491.00\",UDAY THAKUR,MT02,M-0286\n100070512,M02SB001,C-M-219-0286-04,SB01 SHOT BLASTING,7.2,PINION KICK STARTER UPTO SHOT BLASTING,\"29,975.00\",\"1,600.00\",10.06.2021,\"28,375.00\",UDAY THAKUR,MT02,M-0286\n100070356,M02PH001,C-M-219-0286-05,PT PHOSPHATING TANKS,2,PINION KICK STARTER UPTO ZINK PH. & SOAP,\"31,861.00\",\"6,020.00\",07.06.2021,\"25,841.00\",UDAY THAKUR,MT02,M-0286\n100070356,M02KP003,C-M-219-0286-06,KP03 COLD FORGING,8,PINION KICK STARTER UPTO RT.COLD FORGING,\"31,861.00\",\"6,020.00\",07.06.2021,\"25,841.00\",UDAY THAKUR,MT02,M-0286\n100070420,M02CN001,C-M-219-0286-07,CNC01 TURNING CENTRE,55,PINION KICK STARTER UPTO CNC TURNING 1ST,\"12,501.00\",\"1,472.00\",08.06.2021,\"11,029.00\",ASHOK THAKUR,MT02,M-0286\n100070420,M02CN002,C-M-219-0286-07,CNC02 TURNING CENTRE,55,PINION KICK STARTER UPTO CNC TURNING 1ST,\"10,000.00\",\"1,611.00\",08.06.2021,\"8,389.00\",ASHOK THAKUR,MT02,M-0286\n100070420,M02CN005,C-M-219-0286-07,CNC05 TURNING CENTRE,65,PINION KICK STARTER UPTO CNC TURNING 1ST,\"5,000.00\",\"1,393.00\",08.06.2021,\"3,607.00\",ASHOK THAKUR,MT02,M-0286\n100070420,M02CN006,C-M-219-0286-07,CNC06 TURNING CENTRE,65,PINION KICK STARTER UPTO CNC TURNING 1ST,\"5,000.00\",\"1,599.00\",08.06.2021,\"3,401.00\",ASHOK THAKUR,MT02,M-0286\n100070420,M02CN003,C-M-219-0286-08,CNC03 TURNING CENTRE,60,PINION KICK STARTER UPTO CNC TURNING 2ND,\"12,862.00\",\"1,402.00\",08.06.2021,\"11,460.00\",ASHOK THAKUR,MT02,M-0286\n100070420,M02CN004,C-M-219-0286-08,CNC04 TURNING CENTRE,60,PINION KICK STARTER UPTO CNC TURNING 2ND,\"10,000.00\",\"1,661.00\",08.06.2021,\"8,339.00\",ASHOK THAKUR,MT02,M-0286\n100070420,M02CN007,C-M-219-0286-08,CNC07 TURNING CENTRE,60,PINION KICK STARTER UPTO CNC TURNING 2ND,\"5,000.00\",\"1,671.00\",08.06.2021,\"3,329.00\",ASHOK THAKUR,MT02,M-0286\n100070420,M02CN008,C-M-219-0286-08,CNC08 TURNING CENTRE,60,PINION KICK STARTER UPTO CNC TURNING 2ND,\"5,000.00\",\"1,336.00\",08.06.2021,\"3,664.00\",ASHOK THAKUR,MT02,M-0286\n100070420,M02HB004,C-M-219-0286-09,M02HB004-HOBBING,25,PINION KICK STARTER UPTO GEAR CUTTING,\"33,817.00\",\"5,450.00\",08.06.2021,\"28,367.00\",RAJA BABU,MT02,M-0286\n100070374,M02GCF02,C-M-219-0286-10,GCF02 GAS CARBURISING FURNACE,14,PINION KICK STARTER UPTO HT,\"3,500.00\",\"3,200.00\",07.06.2021,300,PAWAN,MT02,M-0286\n100070319,M02SB002,C-M-219-0286-11,SB02 SHOT BLASTING,2,PINION KICK STARTER UPTO SHOT BLASTING,\"35,001.00\",\"4,691.00\",05.06.2021,\"30,310.00\",UDAY THAKUR,MT02,M-0286","output":"str","x":610,"y":300,"wires":[["46ac76f4.f36438"]]},{"id":"9615b085.4b0d9","type":"ui_table","z":"fd20beb2.0d957","group":"f9e41b13.1fe7a8","name":"","order":4,"width":24,"height":3,"columns":[],"outputs":0,"cts":false,"x":1170,"y":280,"wires":[]},{"id":"1d28056e.47670b","type":"ui_table","z":"fd20beb2.0d957","group":"2891289a.2f7078","name":"all rows","order":1,"width":24,"height":4,"columns":[],"outputs":0,"cts":false,"x":860,"y":280,"wires":[]},{"id":"e737a768.c7c8a8","type":"ui_button","z":"fd20beb2.0d957","name":"Fetch Order No.","group":"162e61a9.5d8dee","order":3,"width":3,"height":1,"passthru":false,"label":"Fetch Order No.","tooltip":"","color":"","bgcolor":"","icon":"","payload":"","payloadType":"date","topic":"fetchorderno","topicType":"msg","x":240,"y":240,"wires":[["f83d3949.d63b58","bf869068.10bd8"]]},{"id":"dde9f2ca.adb85","type":"link in","z":"fd20beb2.0d957","name":"","links":["9dc0d65b.64a128"],"x":675,"y":480,"wires":[["2bc4414e.fde82e"]]},{"id":"7da48f3f.4c714","type":"link in","z":"fd20beb2.0d957","name":"","links":["9dc0d65b.64a128"],"x":975,"y":560,"wires":[["6be3db5b.c96fa4"]]},{"id":"a9ee1664.b911e8","type":"link out","z":"fd20beb2.0d957","name":"","links":["a070bbc0.398b58"],"x":1215,"y":480,"wires":[]},{"id":"15cf1cb5.9f2453","type":"link out","z":"fd20beb2.0d957","name":"","links":["a070bbc0.398b58"],"x":915,"y":400,"wires":[]},{"id":"65294a89.62e3a4","type":"link in","z":"fd20beb2.0d957","name":"","links":["9dc0d65b.64a128"],"x":775,"y":340,"wires":[["1d28056e.47670b"]]},{"id":"79be03db.31abbc","type":"link in","z":"fd20beb2.0d957","name":"","links":["9dc0d65b.64a128"],"x":1135,"y":380,"wires":[["9615b085.4b0d9"]]},{"id":"591598f1.fefd78","type":"csv","z":"fd20beb2.0d957","name":"","sep":",","hdrin":true,"hdrout":"all","multi":"one","ret":"\\n","temp":"","skip":"0","strings":true,"include_empty_strings":"","include_null_values":"","x":1630,"y":640,"wires":[["5521cf97.4e1f3","50d110c6.a12b7","ac60068c.48b018"]]},{"id":"50d110c6.a12b7","type":"debug","z":"fd20beb2.0d957","name":"","active":true,"tosidebar":true,"console":false,"tostatus":false,"complete":"false","statusVal":"","statusType":"auto","x":1810,"y":600,"wires":[]},{"id":"17095bbc.9cf004","type":"link in","z":"fd20beb2.0d957","name":"","links":["3a9eda1f.4a1a96"],"x":495,"y":1080,"wires":[["686a090b.5b3e08"]]},{"id":"686a090b.5b3e08","type":"delay","z":"fd20beb2.0d957","name":"","pauseType":"delay","timeout":"2","timeoutUnits":"seconds","rate":"1","nbRateUnits":"1","rateUnits":"second","randomFirst":"1","randomLast":"5","randomUnits":"seconds","drop":false,"x":600,"y":1080,"wires":[["1959427e.99693e"]]},{"id":"ac60068c.48b018","type":"ui_toast","z":"fd20beb2.0d957","position":"top right","displayTime":"3","highlight":"","sendall":false,"outputs":0,"ok":"OK","cancel":"","raw":true,"topic":"","name":"","x":1890,"y":640,"wires":[]},{"id":"68733109.54d2e","type":"function","z":"fd20beb2.0d957","name":"date","func":"var d = new Date(msg.payload);\nvar day = d.getDate();\nvar month = d.getMonth();\nvar monthformat = month + 1;\nvar year = d.getFullYear();\nmsg.payload = day +\"-\"+ monthformat +\"-\"+ year;\nmsg.topic = 'Posting_date';\nreturn msg;","outputs":1,"noerr":0,"initialize":"","finalize":"","libs":[],"x":510,"y":120,"wires":[["c86609ae.3ef4a8","e642510e.a315f"]]},{"id":"52343b0a.967934","type":"ui_media","z":"fd20beb2.0d957","group":"162e61a9.5d8dee","name":"","width":1,"height":1,"order":1,"category":"logo","file":"logo transparent.png","layout":"adjust","showcontrols":false,"loop":false,"onstart":false,"scope":"local","tooltip":"","x":210,"y":120,"wires":[[]]},{"id":"61787a81.d26ae4","type":"debug","z":"fd20beb2.0d957","name":"","active":true,"tosidebar":true,"console":false,"tostatus":true,"complete":"payload","targetType":"msg","statusVal":"payload","statusType":"auto","x":1290,"y":540,"wires":[]},{"id":"592104b1.cae37c","type":"file in","z":"fd20beb2.0d957","name":"Breakdown reasons","filename":"C:\\Users\\Sahil\\Desktop\\testing\\breakdown_reasons.csv","format":"utf8","chunk":false,"sendError":false,"encoding":"none","x":200,"y":480,"wires":[[]]},{"id":"5655b762.aea3e8","type":"csv","z":"fd20beb2.0d957","name":"","sep":",","hdrin":true,"hdrout":"none","multi":"mult","ret":"\\n","temp":"","skip":"0","strings":true,"include_empty_strings":"","include_null_values":"","x":290,"y":560,"wires":[["147c0f71.3a9091"]]},{"id":"147c0f71.3a9091","type":"change","z":"fd20beb2.0d957","name":"","rules":[{"t":"set","p":"options","pt":"msg","to":"$distinct(payload.Breakdown_reason)","tot":"jsonata"}],"action":"","property":"","from":"","to":"","reg":false,"x":380,"y":600,"wires":[["c971cce5.88a9c"]]},{"id":"f83d3949.d63b58","type":"template","z":"fd20beb2.0d957","name":"simulate file - breakdown reason","field":"payload","fieldType":"msg","format":"handlebars","syntax":"mustache","template":"Breakdown_reason\nWarming up time\nNo raw material\nInsert change or adjustment\nMachine accident\nTool not available\nNo operator\nInspection time\nMachine cleaning\nPreventive maintenance\nNew part development\nLate start early stoppage\nLoad unload\nSpindle off time\nAxis off time\nMachine off time\nRework\nSetup\nMaintenance\nExcess load unload\nMachine breakdown\nSchedule closure\nSmall stop losses\nPlanned idle time\nReason unknown\nNo data","output":"str","x":230,"y":520,"wires":[["5655b762.aea3e8"]]},{"id":"f5fc1599.2b62f8","type":"change","z":"fd20beb2.0d957","name":"timestamp","rules":[{"t":"set","p":"payload","pt":"msg","to":"","tot":"date"}],"action":"","property":"","from":"","to":"","reg":false,"x":370,"y":720,"wires":[[]]},{"id":"162e61a9.5d8dee","type":"ui_group","name":"Heading","tab":"74fd02f9.b99b3c","order":1,"disp":false,"width":"24","collapse":false},{"id":"f9e41b13.1fe7a8","type":"ui_group","name":"form","tab":"74fd02f9.b99b3c","order":3,"disp":false,"width":"24","collapse":false},{"id":"5179bc3b.985dd4","type":"ui_group","name":"Entry Confirmation","tab":"74fd02f9.b99b3c","order":4,"disp":true,"width":24,"collapse":false},{"id":"2891289a.2f7078","type":"ui_group","name":"View orders","tab":"74fd02f9.b99b3c","order":2,"disp":true,"width":"24","collapse":true},{"id":"74fd02f9.b99b3c","type":"ui_tab","name":"Breakdown entry form","icon":"dashboard","order":1,"disabled":false,"hidden":false}]
7

That is because if it is one value it is not return as an array, to force the array enclose the expression in [ ]

[$distinct(payload.Work_Center)]
8

@E1cid , thankyou again.
I also want to show the filtered row in table.

$flowContext("csv")[Work_Center = $$.payload]

how to modify the expression

:neutral_face: sorry I'm poor at coding.

9

Understood.
"to force the array enclose the expression in [ ] "
so the expression would be

[$flowContext("csv")[Work_Center = $$.payload]]

:+1:

10

This topic was automatically closed 60 days after the last reply. New replies are no longer allowed.