n8n - 💡(How to fix) Fix Data Table information not saved when merging from main [1 comments, 2 participants]

After merging workflow from Dev to main the Table node is missing the Order By Column value.

What is the error message (if any)?

Please share your workflow/screenshots/recording

{ "nodes": [ { "parameters": { "defineForm": "json", "jsonOutput": "={{\n[\n {\n "fieldLabel": "EXECUTION SUMMARY",\n "fieldType": "textarea",\n "placeholder": "The workflow fired the below information:\n\nCompID: " + ($('Code in JavaScript3').item.json.compId || "N/A") + "\nTrancheID: " + ($('Code in JavaScript3').item.json.trancheId || "N/A") + "\nReport Type: " + ($('Code in JavaScript3').item.json.reportType || "N/A") + "\nSide: " + ($('Form2').item.json.Side || "N/A") + "\n\nERROR: " + ($json.error?.message || "None") + "\n\n\n\n\n\n\n\n",\n "requiredField": false\n },\n {\n "fieldLabel": "Select Next Action",\n "fieldType": "dropdown",\n "fieldOptions": {\n "values": [\n { "option": "exit" },\n { "option": "Re-run current workflow" },\n { "option": "return to form selection" }\n ]\n },\n "requiredField": true\n }\n]\n}}", "options": { "customCss": ":root {\n\t--font-family: 'Open Sans', sans-serif;\n\t--font-weight-normal: 400;\n\t--font-weight-bold: 600;\n\t--font-size-body: 12px;\n\t--font-size-label: 14px;\n\t--font-size-test-notice: 12px;\n\t--font-size-input: 14px;\n\t--font-size-header: 20px;\n\t--font-size-paragraph: 14px;\n\t--font-size-link: 12px;\n\t--font-size-error: 12px;\n\t--font-size-html-h1: 28px;\n\t--font-size-html-h2: 20px;\n\t--font-size-html-h3: 16px;\n\t--font-size-html-h4: 14px;\n\t--font-size-html-h5: 12px;\n\t--font-size-html-h6: 10px;\n\t--font-size-subheader: 14px;\n\n\t/* Colors /\n\t--color-background: #fbfcfe;\n\t--color-test-notice-text: #e6a23d;\n\t--color-test-notice-bg: #fefaf6;\n\t--color-test-notice-border: #f6dcb7;\n\t--color-card-bg: #ffffff;\n\t--color-card-border: #dbdfe7;\n\t--color-card-shadow: rgba(99, 77, 255, 0.06);\n\t--color-link: #7e8186;\n\t--color-header: #525356;\n\t--color-label: #555555;\n\t--color-input-border: #dbdfe7;\n\t--color-input-text: #71747A;\n\t--color-focus-border: rgb(90, 76, 194);\n\t--color-submit-btn-bg: #ff6d5a;\n\t--color-submit-btn-text: #ffffff;\n\t--color-error: #ea1f30;\n\t--color-required: #ff6d5a;\n\t--color-clear-button-bg: #7e8186;\n\t--color-html-text: #555;\n\t--color-html-link: #ff6d5a;\n\t--color-header-subtext: #7e8186;\n\n\t/ Border Radii /\n\t--border-radius-card: 8px;\n\t--border-radius-input: 6px;\n\t--border-radius-clear-btn: 50%;\n\t--card-border-radius: 8px;\n\n\t/ Spacing /\n\t--padding-container-top: 24px;\n\t--padding-card: 24px;\n\t--padding-test-notice-vertical: 12px;\n\t--padding-test-notice-horizontal: 24px;\n\t--margin-bottom-card: 16px;\n\t--padding-form-input: 12px;\n\t--card-padding: 24px;\n\t--card-margin-bottom: 16px;\n\n\t/ Dimensions /\n\t--container-width: 448px;\n\t--submit-btn-height: 48px;\n\t--checkbox-size: 18px;\n\n\t/ Others /\n\t--box-shadow-card: 0px 4px 16px 0px var(--color-card-shadow);\n\t--opacity-placeholder: 0.5;\n#field-0 {\n height: 230px !important;\n min-height: 230px !important;\n font-family: monospace; / Optional: makes the log-style text look cleaner /\n background-color: #f9f9f9; / Optional: gives it a "read-only" look /\n line-height: 1.5;\n}\n\n/ If you want to hide the user's ability to resize it manually /\ntextarea#field-0 {\n resize: none;\n}\n \n}" } }, "type": "n8n-nodes-base.form", "typeVersion": 2.3, "position": [ -624, 80 ], "id": "64279e23-4174-4fed-9a99-cebc44d3d196", "name": "Fail Output", "webhookId": "56247bc5-a9bd-47c6-9feb-805747a5fd40" }, { "parameters": { "rules": { "values": [ { "conditions": { "options": { "caseSensitive": true, "leftValue": "", "typeValidation": "strict", "version": 3 }, "conditions": [ { "leftValue": "={{ $json['Select Next Action'] }}", "rightValue": "exit", "operator": { "type": "string", "operation": "equals" }, "id": "54627938-c24a-40a1-8b3a-3755995276a7" } ], "combinator": "and" } }, { "conditions": { "options": { "caseSensitive": true, "leftValue": "", "typeValidation": "strict", "version": 3 }, "conditions": [ { "id": "c018a27f-69ec-4362-a75a-b1ee76b30c4f", "leftValue": "={{ $json['Select Next Action'] }}", "rightValue": "Re-run current workflow", "operator": { "type": "string", "operation": "equals" } } ], "combinator": "and" } }, { "conditions": { "options": { "caseSensitive": true, "leftValue": "", "typeValidation": "strict", "version": 3 }, "conditions": [ { "id": "61d0f67d-1589-489a-99cd-ab0cd3e1a903", "leftValue": "={{ $json['Select Next Action'] }}", "rightValue": "return to form selection", "operator": { "type": "string", "operation": "equals" } } ], "combinator": "and" } } ] }, "options": {} }, "type": "n8n-nodes-base.switch", "typeVersion": 3.4, "position": [ -448, 0 ], "id": "7512b13b-c82f-4a48-9f67-e7e5567f7762", "name": "Switch" }, { "parameters": { "defineForm": "json", "jsonOutput": "={{\n[\n {\n "fieldLabel": "SUCCESSFUL EXECUTION SUMMARY",\n "fieldType": "textarea",\n "placeholder": [\n "The workflow fired the below information:",\n "",\n "CompID: " + ($node["Form2"].json["Select CompID"] || "N/A"),\n "TrancheID: " + ($node["Form2"].json["Tranche ID"] || "N/A"),\n "Report Type: " + ($node["Form2"].json["Report Type"] || "N/A"),\n "Side: " + ($node["Form2"].json["Side"] || "N/A"),\n "",\n "DETAILS: Workflow completed successfully.",\n ].join('\n'),\n "requiredField": false\n },\n {\n "fieldLabel": "Select Next Action",\n "fieldType": "dropdown",\n "fieldOptions": {\n "values": [\n { "option": "exit" },\n { "option": "Re-run current workflow" },\n { "option": "return to form selection" }\n ]\n },\n "requiredField": true\n }\n]\n}}", "options": { "customCss": ":root {\n\t--font-family: 'Open Sans', sans-serif;\n\t--font-weight-normal: 400;\n\t--font-weight-bold: 600;\n\t--font-size-body: 12px;\n\t--font-size-label: 14px;\n\t--font-size-test-notice: 12px;\n\t--font-size-input: 14px;\n\t--font-size-header: 20px;\n\t--font-size-paragraph: 14px;\n\t--font-size-link: 12px;\n\t--font-size-error: 12px;\n\t--font-size-html-h1: 28px;\n\t--font-size-html-h2: 20px;\n\t--font-size-html-h3: 16px;\n\t--font-size-html-h4: 14px;\n\t--font-size-html-h5: 12px;\n\t--font-size-html-h6: 10px;\n\t--font-size-subheader: 14px;\n\n\t/ Colors /\n\t--color-background: #fbfcfe;\n\t--color-test-notice-text: #e6a23d;\n\t--color-test-notice-bg: #fefaf6;\n\t--color-test-notice-border: #f6dcb7;\n\t--color-card-bg: #ffffff;\n\t--color-card-border: #dbdfe7;\n\t--color-card-shadow: rgba(99, 77, 255, 0.06);\n\t--color-link: #7e8186;\n\t--color-header: #525356;\n\t--color-label: #555555;\n\t--color-input-border: #dbdfe7;\n\t--color-input-text: #71747A;\n\t--color-focus-border: rgb(90, 76, 194);\n\t--color-submit-btn-bg: #ff6d5a;\n\t--color-submit-btn-text: #ffffff;\n\t--color-error: #ea1f30;\n\t--color-required: #ff6d5a;\n\t--color-clear-button-bg: #7e8186;\n\t--color-html-text: #555;\n\t--color-html-link: #ff6d5a;\n\t--color-header-subtext: #7e8186;\n\n\t/ Border Radii /\n\t--border-radius-card: 8px;\n\t--border-radius-input: 6px;\n\t--border-radius-clear-btn: 50%;\n\t--card-border-radius: 8px;\n\n\t/ Spacing /\n\t--padding-container-top: 24px;\n\t--padding-card: 24px;\n\t--padding-test-notice-vertical: 12px;\n\t--padding-test-notice-horizontal: 24px;\n\t--margin-bottom-card: 16px;\n\t--padding-form-input: 12px;\n\t--card-padding: 24px;\n\t--card-margin-bottom: 16px;\n\n\t/ Dimensions /\n\t--container-width: 448px;\n\t--submit-btn-height: 48px;\n\t--checkbox-size: 18px;\n\n\t/ Others /\n\t--box-shadow-card: 0px 4px 16px 0px var(--color-card-shadow);\n\t--opacity-placeholder: 0.5;\n #field-0 {\n height: 230px !important;\n min-height: 230px !important;\n font-family: monospace; / Optional: makes the log-style text look cleaner /\n background-color: #f9f9f9; / Optional: gives it a "read-only" look /\n line-height: 1.5;\n}\n\n/ If you want to hide the user's ability to resize it manually */\ntextarea#field-0 {\n resize: none;\n}\n}" } }, "type": "n8n-nodes-base.form", "typeVersion": 2.3, "position": [ -624, -80 ], "id": "b86c92a7-3159-420f-b8fa-a5611136bb05", "name": "Succcess Output", "webhookId": "56247bc5-a9bd-47c6-9feb-805747a5fd40" }, { "parameters": { "operation": "completion", "respondWith": "redirect", "redirectUrl": "={{$vars.N8N_URL}}/webhook/select-workflow", "options": {} }, "type": "n8n-nodes-base.form", "typeVersion": 2.5, "position": [ -256, 48 ], "id": "563757d6-5e7f-4bcc-9108-66ca845b37c8", "name": "Form", "webhookId": "3c6ab339-6565-4edb-94e8-e212a237b88d" }, { "parameters": { "formTitle": "OrderBook orders/snapshot", "options": { "appendAttribution": true, "path": "OrderBook-Single-Snapshot-Summary" } }, "type": "n8n-nodes-base.formTrigger", "typeVersion": 2.3, "position": [ -2000, 16 ], "id": "db234849-ec4a-4648-b38b-6289f9edee23", "name": "On form submission1", "webhookId": "9b3996c2-e828-412b-939f-f6c4abcb9383" }, { "parameters": { "method": "POST", "url": "XXXXX", "sendBody": true, "specifyBody": "json", "jsonBody": "={{\n $if($json.subId !== "", \n{\n "recipient": {\n "compId": $json.compId,\n "subId": $json.subId\n },\n "trancheId": $json.trancheId,\n "legalEntityRole":$json.legalEntityRole,\n }, \n{\n "recipient": {\n "compId": $json.compId,\n },\n "trancheId": $json.trancheId,\n "legalEntityRole": $json.legalEntityRole,\n })\n}}", "options": {} }, "type": "n8n-nodes-base.httpRequest", "typeVersion": 4.3, "position": [ -880, 16 ], "id": "0f622c90-c8fc-4de1-9e5d-838621d0897a", "name": "API call to COAS1 using /orders/snapshot1", "alwaysOutputData": false, "onError": "continueErrorOutput" }, { "parameters": { "operation": "get", "dataTableId": { "__rl": true, "value": "fqsQlPWwH24SPg6C", "mode": "list", "cachedResultName": "CompID and SubID", "cachedResultUrl": "/projects/GfuAGo57mdLwKvJe/datatables/fqsQlPWwH24SPg6C" }, "limit": 500, "orderBy": true, "orderByColumn": "SortPriority", "orderByDirection": "ASC" }, "type": "n8n-nodes-base.dataTable", "typeVersion": 1.1, "position": [ -1776, 16 ], "id": "3a610171-c120-40c0-933b-c7e1a16e9e53", "name": "Get row(s)1" }, { "parameters": { "jsCode": "const items = $input.all();\nconst preference = [LIST,];\n\n// 1. Get Unique CompIDs\nlet uniqueCompIds = [...new Set(items.map(i => i.json.CompID))].filter(Boolean);\n\n// 2. Sort CompIDs by PARTIAL preference match\nuniqueCompIds.sort((a, b) => {\n // Find the first preference string that is contained within string 'a'\n let idxA = preference.findIndex(pref => a.toUpperCase().includes(pref.toUpperCase()));\n \n // Find the first preference string that is contained within string 'b'\n let idxB = preference.findIndex(pref => b.toUpperCase().includes(pref.toUpperCase()));\n \n const weightA = idxA === -1 ? 999 : idxA;\n const weightB = idxB === -1 ? 999 : idxB;\n \n return weightA - weightB;\n});\n\n// 3. Get Unique SubIDs\nlet uniqueSubIds = [...new Set(items.map(i => i.json.SubID))].filter(Boolean);\n\nreturn {\n json: {\n compID_options: uniqueCompIds.map(id => ({ option: id })),\n subID_options: uniqueSubIds.map(id => ({ option: id }))\n }\n};" }, "type": "n8n-nodes-base.code", "typeVersion": 2, "position": [ -1552, 16 ], "id": "f5e350bf-3427-4b00-b1e9-cca371b1e187", "name": "Code in JavaScript2" }, { "parameters": { "defineForm": "json", "jsonOutput": "=[\n {\n "fieldLabel": "Select CompID",\n "fieldType": "dropdown",\n "requiredField": true,\n "fieldOptions": {\n "values": {{ $json.compID_options }}\n }\n },\n {\n "fieldLabel": "Select SubID (Optional)",\n "fieldType": "dropdown",\n "requiredField": false,\n "fieldOptions": {\n "values": {{ $json.subID_options }}\n }\n },\n {\n "fieldLabel": "Tranche ID",\n "fieldType": "text",\n "requiredField": true\n },\n {\n "fieldLabel": "Side",\n "fieldType": "dropdown",\n "requiredField": true,\n "fieldOptions": {\n "values": [\n { "option": "syndicate" },\n { "option": "investor" }\n ]\n }\n },\n {\n "fieldLabel": "Report Type",\n "fieldType": "dropdown",\n "requiredField": true,\n "fieldOptions": {\n "values": [\n { "option": "Basic" },\n { "option": "Enhanced" }\n ]\n }\n }\n]", "limitWaitTime": "={{ false }}", "options": {} }, "type": "n8n-nodes-base.form", "typeVersion": 2.5, "position": [ -1328, 16 ], "id": "ba49951b-7bf2-4ed0-ae8c-b7c5490e1c6e", "name": "Form2", "webhookId": "61f21061-9299-4bee-b866-7e2874242552" }, { "parameters": { "jsCode": "const form = $input.item.json;\n\n// 1. Normalize the SubID (if it's null/undefined, make it "")\nconst selectedSubId = form["Select SubID (Optional)"] || "";\n\n// 2. Build the object with the key ALWAYS present\nreturn {\n "compId": form["Select CompID"] || "",\n "subId": selectedSubId.toString().trim(),\n "trancheId": form["Tranche ID"] || "",\n "legalEntityRole": form["Side"] || "",\n};" }, "type": "n8n-nodes-base.code", "typeVersion": 2, "position": [ -1104, 16 ], "id": "5f525e51-f105-4f81-9463-e265c156fe25", "name": "Code in JavaScript3" } ], "connections": { "Fail Output": { "main": [ [ { "node": "Switch", "type": "main", "index": 0 } ] ] }, "Switch": { "main": [ [], [ { "node": "Get row(s)1", "type": "main", "index": 0 } ], [ { "node": "Form", "type": "main", "index": 0 } ] ] }, "Succcess Output": { "main": [ [ { "node": "Switch", "type": "main", "index": 0 } ] ] }, "On form submission1": { "main": [ [ { "node": "Get row(s)1", "type": "main", "index": 0 } ] ] }, "API call to COAS1 using /orders/snapshot1": { "main": [ [ { "node": "Succcess Output", "type": "main", "index": 0 } ], [ { "node": "Fail Output", "type": "main", "index": 0 } ] ] }, "Get row(s)1": { "main": [ [ { "node": "Code in JavaScript2", "type": "main", "index": 0 } ] ] }, "Code in JavaScript2": { "main": [ [ { "node": "Form2", "type": "main", "index": 0 } ] ] }, "Form2": { "main": [ [ { "node": "Code in JavaScript3", "type": "main", "index": 0 } ] ] }, "Code in JavaScript3": { "main": [ [ { "node": "API call to COAS1 using /orders/snapshot1", "type": "main", "index": 0 } ] ] } }, "pinData": {}, "meta": { "instanceId": "0641dbe1641680b1f23507c22a6b07ad1dd08fc6975c1c752c0059c2fb2867b4" } }

Initial step:

Checking the Data table:

Confirm only one table should be displayed:

Selecting the first table show an ID and the value for Order by Column still empty

Now only 1 Data Table appers on the dropdown

Selecting the Data Table shows the value populated:

(Select the nodes on your canvas and use the keyboard shortcuts CMD+C/CTRL+C and CMD+V/CTRL+V to copy and paste the workflow.)
⚠️ WARNING ⚠️ If you have sensitive data in your workflow (like API keys), please remove it before sharing.

Share the output returned by the last node

Debug info

core

• n8nVersion: 2.9.4
• platform: docker (self-hosted)
• nodeJsVersion: 24.13.1
• nodeEnv: production
• database: postgres
• executionMode: regular
• concurrency: -1
• license: enterprise (production)

storage

• success: all
• error: all
• progress: false
• manual: true
• binaryMode: filesystem

pruning

• enabled: true
• maxAge: 336 hours
• maxCount: 10000 executions

client

• userAgent: mozilla/5.0 (windows nt 10.0; win64; x64) applewebkit/537.36 (khtml, like gecko) chrome/147.0.0.0 safari/537.36
• isTouchDevice: false

Generated at: 2026-04-27T13:58:53.167Z}