(BlogPost: {CMSContentType=Optional[BLOG_POST], ab=false, abMaster=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, allModules=2 object module(s) and 0 layout section module(s), allWidgets=[{body={hubspot_video={height=1080, player_id=89609129225, player_type=hsvideo2, width=1920}, module_id=35056501883, video_type=hubspot_video}, css={}, child_css={}, id=video, name=video, type=module, order=2, label=null, smart_type=null, styles={}, module_id=35056501883}, {body={module_id=88592615586, video_embed={height=113, max_height=113, max_width=200, oembed_response={provider_url=https://www.youtube.com/, width=200, 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>, thumbnail_width=480, version=1.0, title=How to Blend Two Datasets to Add Rows – Symon.AI, provider_name=YouTube, type=video, thumbnail_height=360, author_url=https://www.youtube.com/channel/UCeWi9QMEie3n_V3MY94Gz7Q, thumbnail_url=https://i.ytimg.com/vi/1vKiz_qVicA/hqdefault.jpg, author_name=Symon AI}, oembed_url=https://www.youtube.com/watch?v=1vKiz_qVicA, size_type=auto_full_width, source_type=oembed, width=200}}, css={}, child_css={}, id=module_16661226169288, name=module_16661226169288, type=module, order=2, label=Video, smart_type=null, styles={}, module_id=88592615586, deleted_at=1675878274173}], allowedSlugConflict=false, allowedSlugConflictColumn=false, ampUrl=https://www.symon.ai/learning-hub/combine-the-rows-of-two-data-sets?hs_amp=true, analytics=null, analyticsFieldsMap={CONTENT_GROUP_ID=long_value: 84256981056
, BLOG_AUTHOR_ID=long_value: 55821023870
, TAG_IDS=long_list_value {
long_value: 88448017234
long_value: 109684312704
}
, NAME=string_value: "<span id=\"hs_cos_wrapper_name\" class=\"hs_cos_wrapper hs_cos_wrapper_meta_field hs_cos_wrapper_type_text\" style=\"\" data-hs-cos-general-type=\"meta_field\" data-hs-cos-type=\"text\" >Combine the Rows of Two Data Sets</span>"
, HTML_TITLE=string_value: "Combine the Rows of Two Data Sets"
, PUBLISH_STATUS_ID=long_value: 2
, URL=string_value: "https://www.symon.ai/learning-hub/combine-the-rows-of-two-data-sets"
, CREATED_TIMESTAMP=long_value: 1666726849544
, PUBLISHED_TIMESTAMP=long_value: 1666726947000
, CONTENT_TYPE_CODE=long_value: 3
}, analyticsForeignIndexObjectType=Optional[BLOG_POST], analyticsPageId=89451729754, analyticsPageType=blog-post, approvalStatus=null, archived=false, archivedAt=0, archivedInDashboard=false, areCommentsAllowed=true, attachedStylesheets=[], audienceAccess=PUBLIC, author=null, authorAt=1683121872553, authorEmail=null, authorFullName=null, authorId=45399073, authorName=null, authorUserId=45399073, authorUsername=null, automated=false, automatedAbMaster=false, blogAuthor=Admin, blogAuthorId=55821023870, blogPostAuthor=Admin, blogPostScheduleTaskUid=null, blogPublishInstantEmailCampaignId=null, blogPublishInstantEmailRetryCount=null, blogPublishInstantEmailTaskUid=null, blogPublishToSocialMediaTask=DONE_NOT_SENT, blueprintTypeId=0, body=BlogPost 89451729754 Combine the Rows of Two Data Sets, businessUnitId=null, campaign=null, campaignName=null, campaignUtm=null, category=BLOG_POST, categoryId=3, clonedFrom=null, commentCount=0, commentList=[], composeBody=null, compositionId=0, contentAccessRuleIds=[], contentAccessRuleTypes=[], contentGroup=84256981056, contentGroupId=84256981056, contentGroupIdForDb=84256981056, contentTypeCategory=BLOG_POST, contentTypeCategoryId=3, contentTypeId=null, cosObjectType=CONTENT, created=1666726849544, createdById=44716558, createdTime=2022-10-25T19:40:49.544Z, crmObjectId=null, css={}, cssText=, ctaClicks=null, ctaViews=null, currentState=PUBLISHED, currentlyPublished=true, deferDynamicValues=false, deletedAt=0, deletedBy=null, domain=, dynamicPageDataSourceCrmObject=false, dynamicPageDataSourceDataQuery=false, dynamicPageDataSourceHubDbTable=false, dynamicPageDataSourceId=null, dynamicPageDataSourceType=null, dynamicPageHubDbTableId=null, enableDomainStylesheets=null, enableDomainStylesheetsColumn=null, enableGoogleAmpOutput=true, enableGoogleAmpOutputOverride=false, enableLayoutStylesheets=null, enableLayoutStylesheetsColumn=null, errors=[], featuredImage=https://6899630.fs1.hubspotusercontent-na1.net/hubfs/6899630/join-5.jpg, featuredImageAltText=, featuredImageAltTextColumn=null, featuredImageColumn=null, featuredImageHeight=175, featuredImageLength=0, featuredImageWidth=300, flexAreas={}, folderId=null, footerHtml=null, freezeDate=1666726947000, generateJsonLdEnabled=true, generateJsonLdEnabledOverride=true, hasContentAccessRules=false, hasUserChanges=true, headHtml=null, header=null, htmlTitle=Combine the Rows of Two Data Sets, htmlTitleColumn=null, id=89451729754, includeDefaultCustomCss=null, includeDefaultCustomCssColumn=null, isCaptchaRequired=true, isDraft=false, isInstanceLayoutPage=false, isInstantEmailEnabled=false, isPublished=true, isSocialPublishingEnabled=false, isStagedPage=false, jsonBody={"attached_stylesheets":[],"featured_image_height":175,"featured_image_width":300,"post_summary":"<p>Learn how to utilize the Union tool to combine the rows of two separate data sets.</p>","has_user_changes":true,"last_edit_session_id":null,"last_edit_update_id":null,"html_title":"Combine the Rows of Two Data Sets","tag_ids":[88448017234,109684312704],"topic_ids":[88448017234,109684312704],"campaign_name":null,"campaign_utm":null,"enable_google_amp_output_override":false,"featured_image":"https://6899630.fs1.hubspotusercontent-na1.net/hubfs/6899630/join-5.jpg","featured_image_alt_text":"","head_html":null,"link_rel_canonical_url":null,"meta_description":"Learn how to utilize the Union tool to combine the rows of two separate data sets.\n\n","post_body":"<span id=\"hs_cos_wrapper_post_body\" class=\"hs_cos_wrapper hs_cos_wrapper_meta_field hs_cos_wrapper_type_rich_text\" style=\"\" data-hs-cos-general-type=\"meta_field\" data-hs-cos-type=\"rich_text\" ><p>Learn how to utilize the Union tool to combine the rows of two separate data sets.</p></span>","publish_immediately":null,"use_featured_image":true,"layout_sections":{},"published_by_id":45399073,"published_at":1683121872548,"rss_body":"<p>Learn how to utilize the Union tool to combine the rows of two separate data sets.</p>","rss_summary":"<p>Learn how to utilize the Union tool to combine the rows of two separate data sets.</p>","scheduled_update_date":0,"blog_publish_to_social_media_task":"DONE_NOT_SENT","blog_post_schedule_task_uid":null,"header":null}, jsonBodyAsString={"attached_stylesheets":[],"featured_image_height":175,"featured_image_width":300,"post_summary":"<p>Learn how to utilize the Union tool to combine the rows of two separate data sets.</p>","has_user_changes":true,"last_edit_session_id":null,"last_edit_update_id":null,"html_title":"Combine the Rows of Two Data Sets","tag_ids":[88448017234,109684312704],"topic_ids":[88448017234,109684312704],"campaign_name":null,"campaign_utm":null,"enable_google_amp_output_override":false,"featured_image":"https://6899630.fs1.hubspotusercontent-na1.net/hubfs/6899630/join-5.jpg","featured_image_alt_text":"","head_html":null,"link_rel_canonical_url":null,"meta_description":"Learn how to utilize the Union tool to combine the rows of two separate data sets.\n\n","post_body":"<span id=\"hs_cos_wrapper_post_body\" class=\"hs_cos_wrapper hs_cos_wrapper_meta_field hs_cos_wrapper_type_rich_text\" style=\"\" data-hs-cos-general-type=\"meta_field\" data-hs-cos-type=\"rich_text\" ><p>Learn how to utilize the Union tool to combine the rows of two separate data sets.</p></span>","publish_immediately":null,"use_featured_image":true,"layout_sections":{},"published_by_id":45399073,"published_at":1683121872548,"rss_body":"<p>Learn how to utilize the Union tool to combine the rows of two separate data sets.</p>","rss_summary":"<p>Learn how to utilize the Union tool to combine the rows of two separate data sets.</p>","scheduled_update_date":0,"blog_publish_to_social_media_task":"DONE_NOT_SENT","blog_post_schedule_task_uid":null,"header":null}, jsonBodyMap={layout_sections={}, tag_ids=[88448017234, 109684312704], featured_image_alt_text=, topic_ids=[88448017234, 109684312704], featured_image_width=300, featured_image_height=175, html_title=Combine the Rows of Two Data Sets, featured_image=https://6899630.fs1.hubspotusercontent-na1.net/hubfs/6899630/join-5.jpg, meta_description=Learn how to utilize the Union tool to combine the rows of two separate data sets.
, has_user_changes=true, attached_stylesheets=[], enable_google_amp_output_override=false, blog_publish_to_social_media_task=DONE_NOT_SENT}, keywords=[], label=<span id="hs_cos_wrapper_name" class="hs_cos_wrapper hs_cos_wrapper_meta_field hs_cos_wrapper_type_text" style="" data-hs-cos-general-type="meta_field" data-hs-cos-type="text" >Combine the Rows of Two Data Sets</span>, language=en, languageVariant=false, layoutSections={}, legacyBlogTabid=null, legacyId=null, legacyPostGuid=null, linkRelCanonicalUrl=null, linkRelCanonicalUrlColumn=null, listTemplate=, liveDomain=www.symon.ai, mab=false, mabExperimentId=null, mabMaster=false, mabVariant=false, majorVersion=0, metaDescription=Learn how to utilize the Union tool to combine the rows of two separate data sets.
, metaKeywords=null, migratedLegacyPost=false, name=<span id="hs_cos_wrapper_name" class="hs_cos_wrapper hs_cos_wrapper_meta_field hs_cos_wrapper_type_text" style="" data-hs-cos-general-type="meta_field" data-hs-cos-type="text" >Combine the Rows of Two Data Sets</span>, 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, onlyIdSlug=false, pageExpiryDate=null, pageExpiryDateColumn=null, pageExpiryRedirectId=null, pageExpiryRedirectIdColumn=null, pageExpiryRedirectUrl=null, pageExpiryRedirectUrlColumn=null, pageRedirectedColumn=false, pageTitle=Combine the Rows of Two Data Sets, parentBlog='Symon.AI Learning Hub' blog (84256981056) of hub id 6899630, password=null, passwordColumn=null, pastMabExperimentIds=[], performableGuid=null, performableVariationLetter=null, permissionedObjectType=Optional[BLOG_POST], personas=[], placementGuids=[], portableKey=null, portalId=6899630, position=null, postBody=<span id="hs_cos_wrapper_post_body" class="hs_cos_wrapper hs_cos_wrapper_meta_field hs_cos_wrapper_type_rich_text" style="" data-hs-cos-general-type="meta_field" data-hs-cos-type="rich_text" ><p>Learn how to utilize the Union tool to combine the rows of two separate data sets.</p></span>, postBodyRss=<p>Learn how to utilize the Union tool to combine the rows of two separate data sets.</p>, postEmailContent=<p>Learn how to utilize the Union tool to combine the rows of two separate data sets.</p>, postFeaturedImageIfEnabled=https://6899630.fs1.hubspotusercontent-na1.net/hubfs/6899630/join-5.jpg, postListContent=<p>Learn how to utilize the Union tool to combine the rows of two separate data sets.</p>, postListSummaryFeaturedImage=https://6899630.fs1.hubspotusercontent-na1.net/hubfs/6899630/join-5.jpg, postRssContent=<p>Learn how to utilize the Union tool to combine the rows of two separate data sets.</p>, postRssSummaryFeaturedImage=https://6899630.fs1.hubspotusercontent-na1.net/hubfs/6899630/join-5.jpg, postSummary=<p>Learn how to utilize the Union tool to combine the rows of two separate data sets.</p>, postSummaryRss=<p>Learn how to utilize the Union tool to combine the rows of two separate data sets.</p>, postTemplate=Symon/templates/Symon-Learning-Hub-Post.html, potentiallyStale=false, 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, publicAccessRulesEnabledColumn=false, publishDate=2022-10-25 19:42:27, publishDateLocalTime=2022-10-25T19:42:27Z, publishDateLocalized=com.hubspot.jinjava.objects.date.FormattedDate@648ac72e, publishDateLong=1666726947000, publishDateSnakeCaseLong=1666726947000, publishImmediately=null, publishImmediatelyColumn=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, requiresDeletion=false, resolvedDomain=www.symon.ai, resolvedLanguage=null, rssBody=<p>Learn how to utilize the Union tool to combine the rows of two separate data sets.</p>, rssSummary=<p>Learn how to utilize the Union tool to combine the rows of two separate data sets.</p>, rssSummaryFeaturedImage=https://6899630.fs1.hubspotusercontent-na1.net/hubfs/6899630/join-5.jpg, safeFeaturedImageAltText=Combine the Rows of Two Data Sets, scheduledUpdateDate=0, screenshotPreviewTakenAt=1690293072692, screenshotPreviewUrl=https://cdn1.hubspot.net/hubshotv3/prod/e/0/d16f931b-aac8-4e23-a495-df5e5f59a981.png, sections={}, securityState=NONE, siteId=null, slug=learning-hub/combine-the-rows-of-two-data-sets, stagedFrom=null, state=PUBLISHED, stateWhenDeleted=null, styleOverrideId=null, styleOverrideIdColumn=null, subcategory=normal_blog_post, subcategoryEnum=normal_blog_post, syncedWithBlogRoot=true, tagId=null, tagIds=[88448017234, 109684312704], tagList=[Clean and Prepare Data, Featured], tagNames=[Clean and Prepare Data, Featured], tagsForBuffer=[88448017234, 109684312704], targetObjectType=BLOG_POST, teamPerms=[], templatePath=, templatePathForRender=Symon/templates/Symon-Learning-Hub-Post.html, themePath=null, themeSettingsValues=null, title=Combine the Rows of Two Data Sets, tmsId=null, topicId=null, topicIds=[88448017234, 109684312704], topicList=[Clean and Prepare Data, Featured], topicNames=[Clean and Prepare Data, Featured], translatedContent={}, translatedContentEnumMap={}, translatedFromId=null, translations={}, tweet=null, tweetAt=null, tweetImmediately=false, unpublishedAt=0, updated=1683121872553, updatedById=45399073, updatedDateTime=2023-05-03T13:51:12.553Z, upsizeFeaturedImage=false, url=https://www.symon.ai/learning-hub/combine-the-rows-of-two-data-sets, useFeaturedImage=true, useFeaturedImageColumn=false, userPerms=[], usesJsRendering=false, views=0, visibleToAll=null, widgetContainers={}, widgetcontainers={}, widgets={video={body={hubspot_video={height=1080, player_id=89609129225, player_type=hsvideo2, width=1920}, module_id=35056501883, video_type=hubspot_video}, css={}, child_css={}, id=video, name=video, type=module, order=2, label=null, smart_type=null, styles={}, module_id=35056501883}, module_16661226169288={body={module_id=88592615586, video_embed={height=113, max_height=113, max_width=200, oembed_response={provider_url=https://www.youtube.com/, width=200, 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>, thumbnail_width=480, version=1.0, title=How to Blend Two Datasets to Add Rows – Symon.AI, provider_name=YouTube, type=video, thumbnail_height=360, author_url=https://www.youtube.com/channel/UCeWi9QMEie3n_V3MY94Gz7Q, thumbnail_url=https://i.ytimg.com/vi/1vKiz_qVicA/hqdefault.jpg, author_name=Symon AI}, oembed_url=https://www.youtube.com/watch?v=1vKiz_qVicA, size_type=auto_full_width, source_type=oembed, width=200}}, css={}, child_css={}, id=module_16661226169288, name=module_16661226169288, type=module, order=2, label=Video, smart_type=null, styles={}, module_id=88592615586, deleted_at=1675878274173}}})