I have a dashboard where when the certain ID of a part is entered, I want to delete that line when the button is pressed. I am able to remove the data, but it then outputs as undefined and is not able to leave the output CSV node.
[
{
"id": "1aec8b4fbf3e71df",
"type": "tab",
"label": "Flow 1",
"disabled": false,
"info": "",
"env": []
},
{
"id": "aa468a591b7fc34c",
"type": "csv",
"z": "1aec8b4fbf3e71df",
"name": "",
"sep": ",",
"hdrin": "",
"hdrout": "none",
"multi": "one",
"ret": "\\n",
"temp": "hex_output,item_name,quantity,restockquant",
"skip": "0",
"strings": true,
"include_empty_strings": false,
"include_null_values": false,
"x": 410,
"y": 160,
"wires": [
[
"dc6754d55e35c333"
]
]
},
{
"id": "dc6754d55e35c333",
"type": "switch",
"z": "1aec8b4fbf3e71df",
"name": "",
"property": "payload.hex_output",
"propertyType": "msg",
"rules": [
{
"t": "eq",
"v": "rfidhex",
"vt": "flow"
},
{
"t": "else"
}
],
"checkall": "true",
"repair": false,
"outputs": 2,
"x": 530,
"y": 160,
"wires": [
[
"17a172317b9788b3"
],
[
"5c257a15c743a92c"
]
]
},
{
"id": "8f995eabfc526153",
"type": "csv",
"z": "1aec8b4fbf3e71df",
"name": "",
"sep": ",",
"hdrin": "",
"hdrout": "none",
"multi": "one",
"ret": "\\n",
"temp": "hex_output,item_name,quantity,restockquant",
"skip": "0",
"strings": true,
"include_empty_strings": true,
"include_null_values": false,
"x": 990,
"y": 160,
"wires": [
[
"1747ea39ef757c0f"
]
]
},
{
"id": "17a172317b9788b3",
"type": "change",
"z": "1aec8b4fbf3e71df",
"name": "",
"rules": [
{
"t": "delete",
"p": "payload",
"pt": "msg"
}
],
"action": "",
"property": "",
"from": "",
"to": "",
"reg": false,
"x": 690,
"y": 140,
"wires": [
[
"5c257a15c743a92c"
]
]
},
{
"id": "5c257a15c743a92c",
"type": "join",
"z": "1aec8b4fbf3e71df",
"name": "",
"mode": "auto",
"build": "object",
"property": "payload",
"propertyType": "msg",
"key": "topic",
"joiner": "\\n",
"joinerType": "str",
"accumulate": true,
"timeout": "",
"count": "",
"reduceRight": false,
"reduceExp": "",
"reduceInit": "",
"reduceInitType": "",
"reduceFixup": "",
"x": 870,
"y": 160,
"wires": [
[
"8f995eabfc526153",
"c0359cfbb2dfbb1f"
]
]
},
{
"id": "c0359cfbb2dfbb1f",
"type": "debug",
"z": "1aec8b4fbf3e71df",
"name": "",
"active": true,
"tosidebar": true,
"console": false,
"tostatus": false,
"complete": "false",
"statusVal": "",
"statusType": "auto",
"x": 1050,
"y": 260,
"wires": []
},
{
"id": "d6f3a342b80c056c",
"type": "template",
"z": "1aec8b4fbf3e71df",
"name": "",
"field": "payload",
"fieldType": "msg",
"format": "handlebars",
"syntax": "mustache",
"template": "e0040150c6cd280d,HHCS 1/4-20X1/2,76,300\ne0040150c6cd16ff,HHCS 1/4-20X3/4,91,300\ne0040150c6cd2a81,HHCS 1/4-20X1,80,300\ne0040150c6cd14c3,HHCS 1/4-20X1-1/4,64,250\n",
"output": "str",
"x": 280,
"y": 160,
"wires": [
[
"aa468a591b7fc34c"
]
]
},
{
"id": "1747ea39ef757c0f",
"type": "template",
"z": "1aec8b4fbf3e71df",
"name": "",
"field": "payload",
"fieldType": "msg",
"format": "handlebars",
"syntax": "mustache",
"template": "This is the payload: {{payload}} !",
"output": "str",
"x": 1140,
"y": 160,
"wires": [
[]
]
}
]
This is my flow for the moment, but it is more intricate on my big file. I am trying to remove the second line based off of the ID (the first column of values).
This is the output I receive when I do click the button on my dashboard in my large project.