(BlogPost: { "ab" : false, "abStatus" : null, "abTestId" : null, "abVariation" : false, "abVariationAutomated" : false, "absoluteUrl" : "https://www.symon.ai/learning-hub/combine-the-rows-of-two-data-sets", "afterPostBody" : null, "aifeatures" : null, "allowedSlugConflict" : false, "analytics" : null, "analyticsPageId" : "89451729754", "analyticsPageType" : "blog-post", "approvalStatus" : null, "archived" : false, "archivedAt" : 0, "archivedInDashboard" : false, "areCommentsAllowed" : true, "attachedStylesheets" : [ ], "audienceAccess" : "PUBLIC", "author" : null, "authorName" : null, "authorUsername" : null, "blogAuthor" : { "avatar" : "", "bio" : "", "cdnPurgeEmbargoTime" : null, "cosObjectType" : "BLOG_AUTHOR", "created" : 1632321849891, "deletedAt" : 0, "displayName" : "Admin", "email" : null, "facebook" : "", "fullName" : "Admin", "gravatarUrl" : null, "hasSocialProfiles" : false, "id" : 55821023870, "label" : "Admin", "language" : null, "linkedin" : "", "name" : "Admin", "portalId" : 6899630, "slug" : "admin", "translatedFromId" : null, "translations" : { }, "twitter" : "", "twitterUsername" : "", "updated" : 1632321849891, "userId" : null, "username" : null, "website" : "" }, "blogAuthorId" : 55821023870, "blogPostAuthor" : { "avatar" : "", "bio" : "", "cdnPurgeEmbargoTime" : null, "cosObjectType" : "BLOG_AUTHOR", "created" : 1632321849891, "deletedAt" : 0, "displayName" : "Admin", "email" : null, "facebook" : "", "fullName" : "Admin", "gravatarUrl" : null, "hasSocialProfiles" : false, "id" : 55821023870, "label" : "Admin", "language" : null, "linkedin" : "", "name" : "Admin", "portalId" : 6899630, "slug" : "admin", "translatedFromId" : null, "translations" : { }, "twitter" : "", "twitterUsername" : "", "updated" : 1632321849891, "userId" : null, "username" : null, "website" : "" }, "blogPostScheduleTaskUid" : null, "blogPublishInstantEmailCampaignId" : null, "blogPublishInstantEmailRetryCount" : null, "blogPublishInstantEmailTaskUid" : null, "blogPublishToSocialMediaTask" : "DONE_NOT_SENT", "blueprintTypeId" : 0, "businessUnitId" : null, "campaign" : null, "campaignName" : null, "campaignUtm" : null, "category" : 3, "categoryId" : 3, "cdnPurgeEmbargoTime" : null, "checkPostLevelAudienceAccessFirst" : true, "clonedFrom" : null, "composeBody" : null, "compositionId" : 0, "contentAccessRuleIds" : [ ], "contentAccessRuleTypes" : [ ], "contentGroup" : 84256981056, "contentGroupId" : 84256981056, "contentTypeCategory" : 3, "contentTypeCategoryId" : 3, "contentTypeId" : null, "created" : 1666726849544, "createdByAgent" : null, "createdById" : 44716558, "createdTime" : 1666726849544, "crmObjectId" : null, "css" : { }, "cssText" : "", "ctaClicks" : null, "ctaViews" : null, "currentState" : "PUBLISHED", "currentlyPublished" : true, "deletedAt" : 0, "deletedBy" : null, "deletedByEmail" : null, "deletedById" : null, "domain" : "", "dynamicPageDataSourceId" : null, "dynamicPageDataSourceType" : null, "dynamicPageHubDbTableId" : null, "enableDomainStylesheets" : null, "enableGoogleAmpOutputOverride" : false, "enableLayoutStylesheets" : null, "errors" : [ ], "featuredImage" : "https://6899630.fs1.hubspotusercontent-na1.net/hubfs/6899630/join-5.jpg", "featuredImageAltText" : "", "featuredImageHeight" : 175, "featuredImageLength" : 0, "featuredImageWidth" : 300, "flexAreas" : { }, "folderId" : null, "footerHtml" : null, "freezeDate" : 1666726947000, "generateJsonLdEnabledOverride" : true, "hasContentAccessRules" : false, "hasUserChanges" : true, "headHtml" : null, "header" : null, "htmlTitle" : "Combine the Rows of Two Data Sets", "id" : 89451729754, "includeDefaultCustomCss" : null, "isCaptchaRequired" : true, "isCrawlableByBots" : false, "isDraft" : false, "isInstanceLayoutPage" : false, "isInstantEmailEnabled" : false, "isPublished" : true, "isSocialPublishingEnabled" : false, "keywords" : [ ], "label" : "Combine the Rows of Two Data Sets", "language" : "en", "lastEditSessionId" : null, "lastEditUpdateId" : null, "layoutSections" : { }, "legacyBlogTabid" : null, "legacyId" : null, "legacyPostGuid" : null, "linkRelCanonicalUrl" : null, "listTemplate" : "", "liveDomain" : "www.symon.ai", "mab" : false, "mabExperimentId" : null, "mabMaster" : false, "mabVariant" : false, "meta" : { "html_title" : "Combine the Rows of Two Data Sets", "public_access_rules" : [ ], "public_access_rules_enabled" : false, "use_featured_image" : true, "keywords" : [ ], "enable_google_amp_output_override" : false, "generate_json_ld_enabled" : true, "composition_id" : 0, "is_crawlable_by_bots" : false, "tag_ids" : [ 88448017234, 109684312704 ], "topic_ids" : [ 88448017234, 109684312704 ], "post_summary" : "Learn how to utilize the Union tool to combine the rows of two separate data sets.", "post_body" : "Learn how to utilize the Union tool to combine the rows of two separate data sets.", "rss_summary" : "Learn how to utilize the Union tool to combine the rows of two separate data sets.", "rss_body" : "Learn how to utilize the Union tool to combine the rows of two separate data sets.", "blog_post_schedule_task_uid" : null, "blog_publish_to_social_media_task" : "DONE_NOT_SENT", "blog_publish_instant_email_task_uid" : null, "blog_publish_instant_email_campaign_id" : null, "blog_publish_instant_email_retry_count" : null, "meta_description" : "Learn how to utilize the Union tool to combine the rows of two separate data sets.\n\n", "meta_keywords" : null, "layout_sections" : { }, "past_mab_experiment_ids" : [ ], "deleted_by" : null, "featured_image_alt_text" : "", "enable_layout_stylesheets" : null, "tweet" : null, "tweet_at" : null, "campaign_name" : null, "campaign_utm" : null, "tweet_immediately" : false, "publish_immediately" : null, "security_state" : "NONE", "scheduled_update_date" : 0, "placement_guids" : [ ], "property_for_dynamic_page_title" : null, "property_for_dynamic_page_slug" : null, "property_for_dynamic_page_meta_description" : null, "property_for_dynamic_page_featured_image" : null, "property_for_dynamic_page_canonical_url" : null, "preview_image_src" : null, "legacy_blog_tabid" : null, "legacy_post_guid" : null, "performable_variation_letter" : null, "style_override_id" : null, "has_user_changes" : true, "css" : { }, "css_text" : "", "unpublished_at" : 0, "published_by_id" : 45399073, "allowed_slug_conflict" : false, "ai_features" : null, "link_rel_canonical_url" : null, "page_redirected" : false, "page_expiry_enabled" : null, "page_expiry_date" : null, "page_expiry_redirect_id" : null, "page_expiry_redirect_url" : null, "deleted_by_id" : null, "state_when_deleted" : null, "cloned_from" : null, "staged_from" : null, "personas" : [ ], "compose_body" : null, "featured_image" : "https://6899630.fs1.hubspotusercontent-na1.net/hubfs/6899630/join-5.jpg", "featured_image_width" : 300, "featured_image_height" : 175, "publish_timezone_offset" : null, "theme_settings_values" : null, "head_html" : null, "footer_html" : null, "attached_stylesheets" : [ ], "enable_domain_stylesheets" : null, "include_default_custom_css" : null, "password" : null, "header" : null, "published_at" : 1683121872548, "last_edit_session_id" : null, "last_edit_update_id" : null, "created_by_agent" : null }, "metaDescription" : "Learn how to utilize the Union tool to combine the rows of two separate data sets.\n\n", "metaKeywords" : null, "name" : "Combine the Rows of Two Data Sets", "nextPostFeaturedImage" : "https://6899630.fs1.hubspotusercontent-na1.net/hubfs/6899630/join-2.jpg", "nextPostFeaturedImageAltText" : "", "nextPostName" : "Join Two Data Sets", "nextPostSlug" : "learning-hub/join-two-data-sets", "pageExpiryDate" : null, "pageExpiryEnabled" : null, "pageExpiryRedirectId" : null, "pageExpiryRedirectUrl" : null, "pageRedirected" : false, "pageTitle" : "Combine the Rows of Two Data Sets", "parentBlog" : { "absoluteUrl" : "https://www.symon.ai/learning-hub", "allowComments" : true, "ampBodyColor" : "#404040", "ampBodyFont" : "'Helvetica Neue', Helvetica, Arial, sans-serif", "ampBodyFontSize" : "18", "ampCustomCss" : "", "ampHeaderBackgroundColor" : "#ffffff", "ampHeaderColor" : "#1e1e1e", "ampHeaderFont" : "'Helvetica Neue', Helvetica, Arial, sans-serif", "ampHeaderFontSize" : "36", "ampLinkColor" : "#416bb3", "ampLogoAlt" : "", "ampLogoHeight" : 0, "ampLogoSrc" : "", "ampLogoWidth" : 0, "analyticsPageId" : 84256981056, "attachedStylesheets" : [ ], "audienceAccess" : "PUBLIC", "businessUnitId" : null, "captchaAfterDays" : 7, "captchaAlways" : false, "categoryId" : 3, "cdnPurgeEmbargoTime" : null, "closeCommentsOlder" : 0, "commentDateFormat" : "medium", "commentFormGuid" : "0a9a6d20-7864-4209-b37e-4e4f46f71511", "commentMaxThreadDepth" : 1, "commentModeration" : false, "commentNotificationEmails" : [ ], "commentShouldCreateContact" : false, "commentVerificationText" : "", "cosObjectType" : "BLOG", "created" : 1662583231162, "createdDateTime" : 1662583231162, "dailyNotificationEmailId" : null, "dateFormattingLanguage" : null, "defaultGroupStyleId" : "", "defaultNotificationFromName" : "", "defaultNotificationReplyTo" : "", "deletedAt" : 0, "description" : "Learn how to use Symon.AI's drag-and-drop, no-code data pipeline builder to clean, transform, and prepare your data. Get advanced analytics insights fast.", "domain" : "www.symon.ai", "domainWhenPublished" : "www.symon.ai", "emailApiSubscriptionId" : null, "enableGoogleAmpOutput" : true, "enableSocialAutoPublishing" : false, "generateJsonLdEnabled" : true, "header" : null, "htmlFooter" : "", "htmlFooterIsShared" : true, "htmlHead" : "", "htmlHeadIsShared" : true, "htmlKeywords" : [ ], "htmlTitle" : "Symon.AI Learning Hub", "id" : 84256981056, "ilsSubscriptionListsByType" : { }, "instantNotificationEmailId" : null, "itemLayoutId" : null, "itemTemplateIsShared" : false, "itemTemplatePath" : "Symon/templates/Symon-Learning-Hub-Post.html", "label" : "Symon.AI Learning Hub", "language" : "en", "legacyGuid" : null, "legacyModuleId" : null, "legacyTabId" : null, "listingLayoutId" : null, "listingPageId" : 84256981057, "listingTemplatePath" : "", "liveDomain" : "www.symon.ai", "monthFilterFormat" : "MMMM yyyy", "monthlyNotificationEmailId" : null, "name" : "Symon.AI Learning Hub", "parentBlogUpdateTaskId" : null, "portalId" : 6899630, "postHtmlFooter" : "", "postHtmlHead" : "", "postsPerListingPage" : 10, "postsPerRssFeed" : 10, "publicAccessRules" : [ ], "publicAccessRulesEnabled" : false, "publicTitle" : "Symon.AI Learning Hub", "publishDateFormat" : "medium", "resolvedDomain" : "www.symon.ai", "rootUrl" : "https://www.symon.ai/learning-hub", "rssCustomFeed" : null, "rssDescription" : null, "rssItemFooter" : null, "rssItemHeader" : null, "settingsOverrides" : { "itemLayoutId" : false, "itemTemplatePath" : false, "itemTemplateIsShared" : false, "listingLayoutId" : false, "listingTemplatePath" : false, "postsPerListingPage" : false, "showSummaryInListing" : false, "useFeaturedImageInSummary" : false, "htmlHead" : false, "postHtmlHead" : false, "htmlHeadIsShared" : false, "htmlFooter" : false, "listingPageHtmlFooter" : false, "postHtmlFooter" : false, "htmlFooterIsShared" : false, "attachedStylesheets" : false, "postsPerRssFeed" : false, "showSummaryInRss" : false, "showSummaryInEmails" : false, "showSummariesInEmails" : false, "allowComments" : false, "commentShouldCreateContact" : false, "commentModeration" : false, "closeCommentsOlder" : false, "commentNotificationEmails" : false, "commentMaxThreadDepth" : false, "commentVerificationText" : false, "socialAccountTwitter" : false, "showSocialLinkTwitter" : false, "showSocialLinkLinkedin" : false, "showSocialLinkFacebook" : false, "enableGoogleAmpOutput" : false, "ampLogoSrc" : false, "ampLogoHeight" : false, "ampLogoWidth" : false, "ampLogoAlt" : false, "ampHeaderFont" : false, "ampHeaderFontSize" : false, "ampHeaderColor" : false, "ampHeaderBackgroundColor" : false, "ampBodyFont" : false, "ampBodyFontSize" : false, "ampBodyColor" : false, "ampLinkColor" : false, "generateJsonLdEnabled" : false }, "showSocialLinkFacebook" : true, "showSocialLinkLinkedin" : true, "showSocialLinkTwitter" : true, "showSummaryInEmails" : true, "showSummaryInListing" : true, "showSummaryInRss" : true, "siteId" : null, "slug" : "learning-hub", "socialAccountTwitter" : "", "state" : null, "subscriptionContactsProperty" : null, "subscriptionEmailType" : null, "subscriptionFormGuid" : null, "subscriptionListsByType" : { }, "title" : null, "translatedFromId" : null, "translations" : { }, "updated" : 1667401754013, "updatedDateTime" : 1667401754013, "urlBase" : "www.symon.ai/learning-hub", "urlSegments" : { "all" : "all", "archive" : "archive", "author" : "author", "page" : "page", "tag" : "tag" }, "useFeaturedImageInSummary" : true, "usesDefaultTemplate" : false, "weeklyNotificationEmailId" : null }, "password" : null, "pastMabExperimentIds" : [ ], "performableGuid" : null, "performableVariationLetter" : null, "personas" : [ ], "placementGuids" : [ ], "portableKey" : null, "portalId" : 6899630, "position" : null, "postBody" : "Learn how to utilize the Union tool to combine the rows of two separate data sets.", "postBodyRss" : "Learn how to utilize the Union tool to combine the rows of two separate data sets.", "postEmailContent" : "Learn how to utilize the Union tool to combine the rows of two separate data sets.", "postFeaturedImageIfEnabled" : "https://6899630.fs1.hubspotusercontent-na1.net/hubfs/6899630/join-5.jpg", "postListContent" : "Learn how to utilize the Union tool to combine the rows of two separate data sets.", "postListSummaryFeaturedImage" : "https://6899630.fs1.hubspotusercontent-na1.net/hubfs/6899630/join-5.jpg", "postRssContent" : "Learn how to utilize the Union tool to combine the rows of two separate data sets.", "postRssSummaryFeaturedImage" : "https://6899630.fs1.hubspotusercontent-na1.net/hubfs/6899630/join-5.jpg", "postSummary" : "Learn how to utilize the Union tool to combine the rows of two separate data sets.", "postSummaryRss" : "Learn how to utilize the Union tool to combine the rows of two separate data sets.", "postTemplate" : "Symon/templates/Symon-Learning-Hub-Post.html", "previewImageSrc" : null, "previewKey" : "ODKkULwH", "previousPostFeaturedImage" : "https://6899630.fs1.hubspotusercontent-na1.net/hubfs/6899630/join-11-1.jpg", "previousPostFeaturedImageAltText" : "", "previousPostName" : "Restructure Data", "previousPostSlug" : "learning-hub/restructure-data", "processingStatus" : "PUBLISHED", "propertyForDynamicPageCanonicalUrl" : null, "propertyForDynamicPageFeaturedImage" : null, "propertyForDynamicPageMetaDescription" : null, "propertyForDynamicPageSlug" : null, "propertyForDynamicPageTitle" : null, "publicAccessRules" : [ ], "publicAccessRulesEnabled" : false, "publishDate" : 1666726947000, "publishDateLocalTime" : 1666726947000, "publishDateLocalized" : { "date" : 1666726947000, "format" : "medium", "language" : null }, "publishImmediately" : null, "publishTimezoneOffset" : null, "publishedAt" : 1683121872548, "publishedByEmail" : null, "publishedById" : 45399073, "publishedByName" : null, "publishedUrl" : "https://www.symon.ai/learning-hub/combine-the-rows-of-two-data-sets", "resolvedDomain" : "www.symon.ai", "resolvedLanguage" : null, "rssBody" : "Learn how to utilize the Union tool to combine the rows of two separate data sets.", "rssSummary" : "Learn how to utilize the Union tool to combine the rows of two separate data sets.", "rssSummaryFeaturedImage" : "https://6899630.fs1.hubspotusercontent-na1.net/hubfs/6899630/join-5.jpg", "scheduledUpdateDate" : 0, "screenshotPreviewTakenAt" : 1711806672433, "screenshotPreviewUrl" : "https://cdn1.hubspot.net/hubshotv3/prod/e/0/be78da78-c611-4f82-a3cf-f33868215f0c.png", "sections" : { }, "securityState" : "NONE", "siteId" : null, "slug" : "learning-hub/combine-the-rows-of-two-data-sets", "stagedFrom" : null, "state" : "PUBLISHED", "stateWhenDeleted" : null, "structuredContentPageType" : null, "structuredContentType" : null, "styleOverrideId" : null, "subcategory" : "normal_blog_post", "syncedWithBlogRoot" : true, "tagIds" : [ 88448017234, 109684312704 ], "tagList" : [ { "categoryId" : 3, "cdnPurgeEmbargoTime" : null, "contentIds" : [ ], "cosObjectType" : "TAG", "created" : 1666036803107, "deletedAt" : 0, "description" : "", "id" : 88448017234, "label" : "Clean and Prepare Data", "language" : "en", "name" : "Clean and Prepare Data", "portalId" : 6899630, "slug" : "clean-and-prepare-data", "translatedFromId" : null, "translations" : { }, "updated" : 1666726720716 }, { "categoryId" : 3, "cdnPurgeEmbargoTime" : null, "contentIds" : [ ], "cosObjectType" : "TAG", "created" : 1680713424275, "deletedAt" : 0, "description" : "", "id" : 109684312704, "label" : "Featured", "language" : "en", "name" : "Featured", "portalId" : 6899630, "slug" : "featured", "translatedFromId" : null, "translations" : { }, "updated" : 1682961620074 } ], "tagNames" : [ "Clean and Prepare Data", "Featured" ], "teamPerms" : [ ], "templatePath" : "", "templatePathForRender" : "Symon/templates/Symon-Learning-Hub-Post.html", "textToAudioFileId" : null, "textToAudioGenerationRequestId" : null, "themePath" : null, "themeSettingsValues" : null, "title" : "Combine the Rows of Two Data Sets", "tmsId" : null, "topicIds" : [ 88448017234, 109684312704 ], "topicList" : [ { "categoryId" : 3, "cdnPurgeEmbargoTime" : null, "contentIds" : [ ], "cosObjectType" : "TAG", "created" : 1666036803107, "deletedAt" : 0, "description" : "", "id" : 88448017234, "label" : "Clean and Prepare Data", "language" : "en", "name" : "Clean and Prepare Data", "portalId" : 6899630, "slug" : "clean-and-prepare-data", "translatedFromId" : null, "translations" : { }, "updated" : 1666726720716 }, { "categoryId" : 3, "cdnPurgeEmbargoTime" : null, "contentIds" : [ ], "cosObjectType" : "TAG", "created" : 1680713424275, "deletedAt" : 0, "description" : "", "id" : 109684312704, "label" : "Featured", "language" : "en", "name" : "Featured", "portalId" : 6899630, "slug" : "featured", "translatedFromId" : null, "translations" : { }, "updated" : 1682961620074 } ], "topicNames" : [ "Clean and Prepare Data", "Featured" ], "topics" : [ 88448017234, 109684312704 ], "translatedContent" : { }, "translatedFromId" : null, "translations" : { }, "tweet" : null, "tweetAt" : null, "tweetImmediately" : false, "unpublishedAt" : 0, "updated" : 1683121872553, "updatedById" : 45399073, "upsizeFeaturedImage" : false, "url" : "https://www.symon.ai/learning-hub/combine-the-rows-of-two-data-sets", "useFeaturedImage" : true, "userPerms" : [ ], "views" : 0, "visibleToAll" : null, "widgetContainers" : { }, "widgetcontainers" : { }, "widgets" : { "module_16661226169288" : { "body" : { "module_id" : 88592615586, "video_embed" : { "height" : 113, "max_height" : 113, "max_width" : 200, "oembed_response" : { "author_name" : "Symon AI", "author_url" : "https://www.youtube.com/channel/UCeWi9QMEie3n_V3MY94Gz7Q", "height" : "113", "html" : "<iframe width=\"200\" height=\"113\" src=\"https://www.youtube.com/embed/1vKiz_qVicA?feature=oembed\" frameborder=\"0\" allow=\"accelerometer; autoplay; clipboard-write; encrypted-media; gyroscope; picture-in-picture\" allowfullscreen title=\"How to Blend Two Datasets to Add Rows – Symon.AI\"></iframe>", "provider_name" : "YouTube", "provider_url" : "https://www.youtube.com/", "thumbnail_height" : "360", "thumbnail_url" : "https://i.ytimg.com/vi/1vKiz_qVicA/hqdefault.jpg", "thumbnail_width" : "480", "title" : "How to Blend Two Datasets to Add Rows – Symon.AI", "type" : "video", "version" : "1.0", "width" : "200" }, "oembed_url" : "https://www.youtube.com/watch?v=1vKiz_qVicA", "size_type" : "auto_full_width", "source_type" : "oembed", "width" : 200 } }, "child_css" : { }, "css" : { }, "deleted_at" : 1675878274173, "id" : "module_16661226169288", "label" : "Video", "module_id" : 88592615586, "name" : "module_16661226169288", "order" : 2, "smart_type" : null, "styles" : { }, "type" : "module" }, "video" : { "body" : { "hubspot_video" : { "height" : 1080, "player_id" : 89609129225, "player_type" : "hsvideo2", "width" : 1920 }, "module_id" : 35056501883, "video_type" : "hubspot_video" }, "child_css" : { }, "css" : { }, "id" : "video", "label" : null, "module_id" : 35056501883, "name" : "video", "order" : 2, "smart_type" : null, "styles" : { }, "type" : "module" } } })

Clean and Prepare Data , Featured

Combine the Rows of Two Data Sets

Learn how to utilize the Union tool to combine the rows of two separate data sets.

Sign up for a Symon.AI account today

No credit card required.