{"id":138372,"date":"2026-02-17T17:21:43","date_gmt":"2026-02-17T11:51:43","guid":{"rendered":"https:\/\/www.vskills.in\/certification\/tutorial\/?page_id=138372"},"modified":"2026-02-17T17:21:44","modified_gmt":"2026-02-17T11:51:44","slug":"working-with-data-merge-split-set-format","status":"publish","type":"page","link":"https:\/\/www.vskills.in\/certification\/tutorial\/working-with-data-merge-split-set-format\/","title":{"rendered":"Working with Data (Merge, Split, Set, Format)"},"content":{"rendered":"\n<p>Working with data in n8n means shaping information so it is clean, correct, and ready to be used by the next app or node. Most workflow failures happen not because the integration is wrong, but because the data format is not what the next step expects. These tools help you control that.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">Set (select, rename, create fields)<\/h3>\n\n\n\n<p>The <strong>Set<\/strong> node is used to create a clean output structure. You can:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>keep only the fields you need (remove extra fields)<\/li>\n\n\n\n<li>rename fields (for example <code>cust_name<\/code> \u2192 <code>Customer Name<\/code>)<\/li>\n\n\n\n<li>create new fields (for example add <code>source = \"Website Form\"<\/code>)<\/li>\n\n\n\n<li>combine fields (first name + last name)<\/li>\n<\/ul>\n\n\n\n<p>This is useful before sending data to a CRM, email, or database.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">Merge (combine data from two paths)<\/h3>\n\n\n\n<p>The <strong>Merge<\/strong> node combines two inputs into one. It is useful when:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>you fetch customer details from one app and order details from another<\/li>\n\n\n\n<li>you run two branches in parallel and want one combined output<\/li>\n<\/ul>\n\n\n\n<p>You can merge by position, by key fields, or by matching items depending on your workflow logic.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">Split (break data into smaller parts)<\/h3>\n\n\n\n<p>\u201cSplit\u201d in n8n usually means separating multiple items so you can process them properly. This is useful when:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>an API returns a list of records and you need to handle each one<\/li>\n\n\n\n<li>you want to loop through rows, emails, or transactions<\/li>\n<\/ul>\n\n\n\n<p>Common tools include item handling and splitting lists into individual items for processing.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">Format (make data acceptable for the next system)<\/h3>\n\n\n\n<p>Formatting includes:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>date\/time formatting (ISO format vs readable format)<\/li>\n\n\n\n<li>numbers and currency formatting<\/li>\n\n\n\n<li>text cleanup (trim spaces, standardise case)<\/li>\n\n\n\n<li>converting JSON fields into the right structure<\/li>\n<\/ul>\n\n\n\n<p>When you use Set, Merge, Split, and formatting properly, your workflow becomes stable, readable, and much easier to scale.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Working with data in n8n means shaping information so it is clean, correct, and ready to be used by the next app or node. Most workflow failures happen not because the integration is wrong, but because the data format is not what the next step expects. These tools help you control that. Set (select, rename,&#8230;<\/p>\n","protected":false},"author":21,"featured_media":0,"parent":0,"menu_order":0,"comment_status":"closed","ping_status":"closed","template":"","meta":{"footnotes":""},"categories":[],"tags":[],"class_list":["post-138372","page","type-page","status-publish","hentry"],"acf":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v24.5 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Working with Data (Merge, Split, Set, Format) - Tutorial<\/title>\n<meta name=\"description\" content=\"Working with data in n8n means shaping information so it is clean, correct, and ready to be used by the next app or node.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.vskills.in\/certification\/tutorial\/working-with-data-merge-split-set-format\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Working with Data (Merge, Split, Set, Format) - Tutorial\" \/>\n<meta property=\"og:description\" content=\"Working with data in n8n means shaping information so it is clean, correct, and ready to be used by the next app or node.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.vskills.in\/certification\/tutorial\/working-with-data-merge-split-set-format\/\" \/>\n<meta property=\"og:site_name\" content=\"Tutorial\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/vskills.in\/\" \/>\n<meta property=\"article:modified_time\" content=\"2026-02-17T11:51:44+00:00\" \/>\n<meta name=\"twitter:label1\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data1\" content=\"2 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.vskills.in\/certification\/tutorial\/working-with-data-merge-split-set-format\/\",\"url\":\"https:\/\/www.vskills.in\/certification\/tutorial\/working-with-data-merge-split-set-format\/\",\"name\":\"Working with Data (Merge, Split, Set, Format) - Tutorial\",\"isPartOf\":{\"@id\":\"https:\/\/www.vskills.in\/certification\/tutorial\/#website\"},\"datePublished\":\"2026-02-17T11:51:43+00:00\",\"dateModified\":\"2026-02-17T11:51:44+00:00\",\"description\":\"Working with data in n8n means shaping information so it is clean, correct, and ready to be used by the next app or node.\",\"breadcrumb\":{\"@id\":\"https:\/\/www.vskills.in\/certification\/tutorial\/working-with-data-merge-split-set-format\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.vskills.in\/certification\/tutorial\/working-with-data-merge-split-set-format\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.vskills.in\/certification\/tutorial\/working-with-data-merge-split-set-format\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.vskills.in\/certification\/tutorial\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Working with Data (Merge, Split, Set, Format)\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.vskills.in\/certification\/tutorial\/#website\",\"url\":\"https:\/\/www.vskills.in\/certification\/tutorial\/\",\"name\":\"Tutorial\",\"description\":\"Vskills - A initiative in elearning and certification\",\"publisher\":{\"@id\":\"https:\/\/www.vskills.in\/certification\/tutorial\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.vskills.in\/certification\/tutorial\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/www.vskills.in\/certification\/tutorial\/#organization\",\"name\":\"Vskills\",\"url\":\"https:\/\/www.vskills.in\/certification\/tutorial\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.vskills.in\/certification\/tutorial\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/www.vskills.in\/certification\/tutorial\/wp-content\/uploads\/2017\/07\/vskills-min-logo.jpg\",\"contentUrl\":\"https:\/\/www.vskills.in\/certification\/tutorial\/wp-content\/uploads\/2017\/07\/vskills-min-logo.jpg\",\"width\":73,\"height\":55,\"caption\":\"Vskills\"},\"image\":{\"@id\":\"https:\/\/www.vskills.in\/certification\/tutorial\/#\/schema\/logo\/image\/\"},\"sameAs\":[\"https:\/\/www.facebook.com\/vskills.in\/\",\"https:\/\/x.com\/vskills_in\",\"https:\/\/www.linkedin.com\/company-beta\/1371554\/\",\"https:\/\/www.youtube.com\/channel\/UCMWnscxPwRF_PqXo9B7q_Tw\"]}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Working with Data (Merge, Split, Set, Format) - Tutorial","description":"Working with data in n8n means shaping information so it is clean, correct, and ready to be used by the next app or node.","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.vskills.in\/certification\/tutorial\/working-with-data-merge-split-set-format\/","og_locale":"en_US","og_type":"article","og_title":"Working with Data (Merge, Split, Set, Format) - Tutorial","og_description":"Working with data in n8n means shaping information so it is clean, correct, and ready to be used by the next app or node.","og_url":"https:\/\/www.vskills.in\/certification\/tutorial\/working-with-data-merge-split-set-format\/","og_site_name":"Tutorial","article_publisher":"https:\/\/www.facebook.com\/vskills.in\/","article_modified_time":"2026-02-17T11:51:44+00:00","twitter_misc":{"Est. reading time":"2 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/www.vskills.in\/certification\/tutorial\/working-with-data-merge-split-set-format\/","url":"https:\/\/www.vskills.in\/certification\/tutorial\/working-with-data-merge-split-set-format\/","name":"Working with Data (Merge, Split, Set, Format) - Tutorial","isPartOf":{"@id":"https:\/\/www.vskills.in\/certification\/tutorial\/#website"},"datePublished":"2026-02-17T11:51:43+00:00","dateModified":"2026-02-17T11:51:44+00:00","description":"Working with data in n8n means shaping information so it is clean, correct, and ready to be used by the next app or node.","breadcrumb":{"@id":"https:\/\/www.vskills.in\/certification\/tutorial\/working-with-data-merge-split-set-format\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.vskills.in\/certification\/tutorial\/working-with-data-merge-split-set-format\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.vskills.in\/certification\/tutorial\/working-with-data-merge-split-set-format\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.vskills.in\/certification\/tutorial\/"},{"@type":"ListItem","position":2,"name":"Working with Data (Merge, Split, Set, Format)"}]},{"@type":"WebSite","@id":"https:\/\/www.vskills.in\/certification\/tutorial\/#website","url":"https:\/\/www.vskills.in\/certification\/tutorial\/","name":"Tutorial","description":"Vskills - A initiative in elearning and certification","publisher":{"@id":"https:\/\/www.vskills.in\/certification\/tutorial\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.vskills.in\/certification\/tutorial\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/www.vskills.in\/certification\/tutorial\/#organization","name":"Vskills","url":"https:\/\/www.vskills.in\/certification\/tutorial\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.vskills.in\/certification\/tutorial\/#\/schema\/logo\/image\/","url":"https:\/\/www.vskills.in\/certification\/tutorial\/wp-content\/uploads\/2017\/07\/vskills-min-logo.jpg","contentUrl":"https:\/\/www.vskills.in\/certification\/tutorial\/wp-content\/uploads\/2017\/07\/vskills-min-logo.jpg","width":73,"height":55,"caption":"Vskills"},"image":{"@id":"https:\/\/www.vskills.in\/certification\/tutorial\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/vskills.in\/","https:\/\/x.com\/vskills_in","https:\/\/www.linkedin.com\/company-beta\/1371554\/","https:\/\/www.youtube.com\/channel\/UCMWnscxPwRF_PqXo9B7q_Tw"]}]}},"_links":{"self":[{"href":"https:\/\/www.vskills.in\/certification\/tutorial\/wp-json\/wp\/v2\/pages\/138372","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.vskills.in\/certification\/tutorial\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/www.vskills.in\/certification\/tutorial\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/www.vskills.in\/certification\/tutorial\/wp-json\/wp\/v2\/users\/21"}],"replies":[{"embeddable":true,"href":"https:\/\/www.vskills.in\/certification\/tutorial\/wp-json\/wp\/v2\/comments?post=138372"}],"version-history":[{"count":1,"href":"https:\/\/www.vskills.in\/certification\/tutorial\/wp-json\/wp\/v2\/pages\/138372\/revisions"}],"predecessor-version":[{"id":138373,"href":"https:\/\/www.vskills.in\/certification\/tutorial\/wp-json\/wp\/v2\/pages\/138372\/revisions\/138373"}],"wp:attachment":[{"href":"https:\/\/www.vskills.in\/certification\/tutorial\/wp-json\/wp\/v2\/media?parent=138372"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.vskills.in\/certification\/tutorial\/wp-json\/wp\/v2\/categories?post=138372"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.vskills.in\/certification\/tutorial\/wp-json\/wp\/v2\/tags?post=138372"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}