Merging of 2 data table

Help Studio
, ,
1

hi i need to merge 2 data table, in that 1 data table contains headers and one data table doesn’t having any headers.

is this possible to merge this kind of datatable?

need to merge this 2 datatable.:
1st datatable: [{“id”:40720,“workItemId”:40720,“workItemGuid”:“e40ffeae-38a0-45e2-9337-9d4a6d23e615”,“legalEntityGuid”:“23c2dd8b-1f2f-4fc0-89c7-451ebd392313”,“workflowTaskDetailId”:510302,“workFlowTaskDetailGUID”:“1f5f8e12-5b63-45f4-8c53-667a006624b8”,“workItemName”:“K1E - VINTAGE VII EMP LP - AIOF II NJORD EQUITY AGGREGATOR, L.P.”,“taxFormName”:“NA”,“jurisdiction”:“NA”,“legalEntityName”:“VINTAGE VII EMP LP”,“taxEntityCustomAttribute1”:“GSAM”,“taxEntityCustomAttribute2”:“”,“taxEntityCustomAttribute3”:“Vintage VII”,“taxEntityCustomAttribute4”:“NA”,“taxEntityCustomAttribute5”:“NA”,“taxEntityCustomAttribute6”:“NA”,“taxEntityCustomAttribute7”:“Partnership”,“workItemTypeId”:2,“workItemTypeName”:“K1 Extraction”,“keyProcess”:“Compliance”,“process”:“Direct”,“subProcess”:“Support-COE”,“taxType”:“Document Extraction”,“taxYear”:2021,“statutoryDueDate”:“NA”,“assignedName”:“NA”,“accountableParty”:“Sura Sharath Bhushan”,“country”:“NA”,“region”:“NA”,“statusName”:“In Progress",“createdDtm”:“2022-06-15T13:57:07.0749617Z”,“createdUser”:"Sura.Bhushan3@gds.ey.com”,“updatedDtm”:“2022-06-17T03:53:41.8931454Z”,“updatedUser”:"Alfred.Worley@ey.com",“filingEntity”:“NA”,“templateNameDesc”:“K1 Extract Medium”,“targetDueDate”:“2022-06-20 13:57:04”,“deliverableCount”:76,“assignedToUserId”:null,“currentTask”:“COE Level 3 Review”,“taskStatus”:“Not Started”,“investmentName”:“AIOF II NJORD EQUITY AGGREGATOR, L.P.”,“taxPeriodName”:“2021 Annual”},{“id”:40721,“workItemId”:40721,“workItemGuid”:“0469dc80-5365-4253-8311-8490a390b2f9”,“legalEntityGuid”:“23c2dd8b-1f2f-4fc0-89c7-451ebd392313”,“workflowTaskDetailId”:510307,“workFlowTaskDetailGUID”:“afa9cba4-2397-4cc6-8ac2-3f35ef3806c9”,“workItemName”:“K1E - VINTAGE VII EMP LP - AIOF II NJORD EQUITY AGGREGATOR, L.P._2021”,“taxFormName”:“NA”,“jurisdiction”:“NA”,“legalEntityName”:“VINTAGE VII EMP LP”,“taxEntityCustomAttribute1”:“GSAM”,“taxEntityCustomAttribute2”:“”,“taxEntityCustomAttribute3”:“Vintage VII”,“taxEntityCustomAttribute4”:“NA”,“taxEntityCustomAttribute5”:“NA”,“taxEntityCustomAttribute6”:“NA”,“taxEntityCustomAttribute7”:“Partnership”,“workItemTypeId”:2,“workItemTypeName”:“K1 Extraction”,“keyProcess”:“Compliance”,“process”:“Direct”,“subProcess”:“Support-COE”,“taxType”:“Document Extraction”,“taxYear”:2021,“statutoryDueDate”:“NA”,“assignedName”:“NA”,“accountableParty”:“Sura Sharath Bhushan”,“country”:“NA”,“region”:“NA”,“statusName”:“In Progress",“createdDtm”:“2022-06-15T14:17:36.8482598Z”,“createdUser”:"Sura.Bhushan3@gds.ey.com”,“updatedDtm”:“2022-06-17T03:40:27.6369685Z”,“updatedUser”:"Vishnu.C.V@gds.ey.com",“filingEntity”:“NA”,“templateNameDesc”:“K1 Extract Medium”,“targetDueDate”:“2022-06-20 14:17:33”,“deliverableCount”:76,“assignedToUserId”:null,“currentTask”:“COE Level 3 Review”,“taskStatus”:“Not Started”,“investmentName”:“AIOF II NJORD EQUITY AGGREGATOR, L.P.”,“taxPeriodName”:“2021 Annual”},{“id”:40722,“workItemId”:40722,“workItemGuid”:“f4baa189-febd-483f-a548-5e2cc76f3bf7”,“legalEntityGuid”:“23c2dd8b-1f2f-4fc0-89c7-451ebd392313”,“workflowTaskDetailId”:510312,“workFlowTaskDetailGUID”:“2c38cae3-fe16-4a6a-81a5-4b4cbe8d63be”,“workItemName”:“K1E - VINTAGE VII EMP LP - OAKTREE OPPORTUNITIES FUND XI, LP_2021”,“taxFormName”:“NA”,“jurisdiction”:“NA”,“legalEntityName”:“VINTAGE VII EMP LP”,“taxEntityCustomAttribute1”:“GSAM”,“taxEntityCustomAttribute2”:“”,“taxEntityCustomAttribute3”:“Vintage VII”,“taxEntityCustomAttribute4”:“NA”,“taxEntityCustomAttribute5”:“NA”,“taxEntityCustomAttribute6”:“NA”,“taxEntityCustomAttribute7”:“Partnership”,“workItemTypeId”:2,“workItemTypeName”:“K1 Extraction”,“keyProcess”:“Compliance”,“process”:“Direct”,“subProcess”:“Support-COE”,“taxType”:“Document Extraction”,“taxYear”:2021,“statutoryDueDate”:“NA”,“assignedName”:“NA”,“accountableParty”:“Neshma Hernandez”,“country”:“NA”,“region”:“NA”,“statusName”:“In Progress",“createdDtm”:“2022-06-15T18:30:21.6817114Z”,“createdUser”:"Neshma.Hernandez@ey.com”,“updatedDtm”:“2022-06-17T03:25:48.9482841Z”,“updatedUser”:"Alfred.Worley@ey.com",“filingEntity”:“NA”,“templateNameDesc”:“K1 Extract Medium”,“targetDueDate”:“2022-06-20 18:30:18”,“deliverableCount”:76,“assignedToUserId”:null,“currentTask”:“COE Level 3 Review”,“taskStatus”:“Not Started”,“investmentName”:“OAKTREE OPPORTUNITIES FUND XI, LP”,“taxPeriodName”:“2021 Annual”},{“id”:40723,“workItemId”:40723,“workItemGuid”:“9e28142f-f75d-4d68-b4b2-652a206a6eab”,“legalEntityGuid”:“23c2dd8b-1f2f-4fc0-89c7-451ebd392313”,“workflowTaskDetailId”:510317,“workFlowTaskDetailGUID”:“0a2ee693-c65d-4fab-b0c1-07005435ca18”,“workItemName”:“K1E - VINTAGE VII EMP LP - OAKTREE OPPORTUNITIES FUND XI AIV (CAYMAN), L.P._2021”,“taxFormName”:“NA”,“jurisdiction”:“NA”,“legalEntityName”:“VINTAGE VII EMP LP”,“taxEntityCustomAttribute1”:“GSAM”,“taxEntityCustomAttribute2”:“”,“taxEntityCustomAttribute3”:“Vintage VII”,“taxEntityCustomAttribute4”:“NA”,“taxEntityCustomAttribute5”:“NA”,“taxEntityCustomAttribute6”:“NA”,“taxEntityCustomAttribute7”:“Partnership”,“workItemTypeId”:2,“workItemTypeName”:“K1 Extraction”,“keyProcess”:“Compliance”,“process”:“Direct”,“subProcess”:“Support-COE”,“taxType”:“Document Extraction”,“taxYear”:2021,“statutoryDueDate”:“NA”,“assignedName”:“NA”,“accountableParty”:“Neshma Hernandez”,“country”:“NA”,“region”:“NA”,“statusName”:“In Progress",“createdDtm”:“2022-06-15T18:34:05.6116175Z”,“createdUser”:"Neshma.Hernandez@ey.com”,“updatedDtm”:“2022-06-17T03:09:53.8944922Z”,“updatedUser”:"Alfred.Worley@ey.com",“filingEntity”:“NA”,“templateNameDesc”:“K1 Extract Medium”,“targetDueDate”:“2022-06-20 18:34:04”,“deliverableCount”:76,“assignedToUserId”:null,“currentTask”:“COE Level 3 Review”,“taskStatus”:“Not Started”,“investmentName”:“OAKTREE OPPORTUNITIES FUND XI AIV (CAYMAN), L.P.”,“taxPeriodName”:“2021 Annual”},{“id”:40724,“workItemId”:40724,“workItemGuid”:“67fa8e17-ad87-41b7-8e7e-54833892a154”,“legalEntityGuid”:“23c2dd8b-1f2f-4fc0-89c7-451ebd392313”,“workflowTaskDetailId”:510322,“workFlowTaskDetailGUID”:“8340459d-65b9-4965-8b02-347d03aa3251”,“workItemName”:“K1E - VINTAGE VII EMP LP - ROARK CAPITAL PARTNERS V (T) LP_2021”,“taxFormName”:“NA”,“jurisdiction”:“NA”,“legalEntityName”:“VINTAGE VII EMP LP”,“taxEntityCustomAttribute1”:“GSAM”,“taxEntityCustomAttribute2”:“”,“taxEntityCustomAttribute3”:“Vintage VII”,“taxEntityCustomAttribute4”:“NA”,“taxEntityCustomAttribute5”:“NA”,“taxEntityCustomAttribute6”:“NA”,“taxEntityCustomAttribute7”:“Partnership”,“workItemTypeId”:2,“workItemTypeName”:“K1 Extraction”,“keyProcess”:“Compliance”,“process”:“Direct”,“subProcess”:“Support-COE”,“taxType”:“Document Extraction”,“taxYear”:2021,“statutoryDueDate”:“NA”,“assignedName”:“NA”,“accountableParty”:“Neshma Hernandez”,“country”:“NA”,“region”:“NA”,“statusName”:“In Progress",“createdDtm”:“2022-06-15T18:49:23.6169118Z”,“createdUser”:"Neshma.Hernandez@ey.com”,“updatedDtm”:“2022-06-17T02:38:26.3855021Z”,“updatedUser”:"Alfred.Worley@ey.com",“filingEntity”:“NA”,“templateNameDesc”:“K1 Extract Medium”,“targetDueDate”:“2022-06-20 18:49:22”,“deliverableCount”:76,“assignedToUserId”:null,“currentTask”:“COE Level 3 Review”,“taskStatus”:“Not Started”,“investmentName”:“ROARK CAPITAL PARTNERS V (T) LP”,“taxPeriodName”:“2021 Annual”}]

2nd datatabel:

how to merge this 2 datatable?

2

@manipreethi410 Did you try using Merge Data Table Activity

3

yes Merge Data Table Activity will work only when 2 data table will having some value, if we get null value it will not work.

4

@manipreethi410 May i know why do you want to merge the empty data table

5

Hi @manipreethi410

Two things:

  • this looks like two JSON Arrays rather than a Data Table; you can merge them by using the Invoke Method activity and the JArray.Merge:

    image
    image1480×589 27.7 KB

    If the value comes as a string, you might have to parse it into JArray first with an Assign activity (or a Deserialize JSON Array activity):
    tempArray = JArray.Parse(yourStringInput)

  • are you sure the data you have shared in the first post can be posted on a public forum?

6

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.