Have a twofold question on merging queries.
I have two ADO orgs that I can pull data down in separate reports easy enough. The unique ID in each ORG is called WorkItemID, the other columns may or may not have duplicate entries but WorkItemID is always unique for sure.
My first question is this:
1. If the data pulled down is different, as in some column names don't match (eg. one org has extra columns than the other) is there a merge function that will simply combine the tables and columns into one?
2. Is there an alternative to merging? I tried a function call but one of the orgs is missing data and I cannot figure out why.
What's the best way to do this?
sample table entries from each
ORG2
Column Name Description Calculated Column Expression
| WorkItemId | | | |
| InProgressDate | | | |
| CompletedDate | | | |
| LeadTimeDays | | | |
| CycleTimeDays | | | |
| InProgressDateSK | | | |
| CompletedDateSK | | | |
| AnalyticsUpdatedDate | | | |
| ProjectSK | | | |
| WorkItemRevisionSK | | | |
| AreaSK | | | |
| IterationSK | | | |
| AssignedToUserSK | | | |
| ChangedByUserSK | | | |
| CreatedByUserSK | | | |
| ActivatedByUserSK | | | |
| ClosedByUserSK | | | |
| ResolvedByUserSK | | | |
| ActivatedDateSK | | | |
| ChangedDateSK | | | |
| ClosedDateSK | | | |
| CreatedDateSK | | | |
| ResolvedDateSK | | | |
| StateChangeDateSK | | | |
| Revision | | | |
| Watermark | | | |
| Title | | | |
| WorkItemType | | | |
| ChangedDate | | | |
| CreatedDate | | | |
| State | | | |
| Reason | | | |
| FoundIn | | | |
| IntegrationBuild | | | |
| ActivatedDate | | | |
| Activity | | | |
| BusinessValue | | | |
| ClosedDate | | | |
| Issue | | | |
| Priority | | | |
| Rating | | | |
| ResolvedDate | | | |
| ResolvedReason | | | |
| Risk | | | |
| Severity | | | |
| StackRank | | | |
| TimeCriticality | | | |
| ValueArea | | | |
| CompletedWork | | | |
| DueDate | | | |
| Effort | | | |
| FinishDate | | | |
| OriginalEstimate | | | |
| RemainingWork | | | |
| StartDate | | | |
| StoryPoints | | | |
| TargetDate | | | |
| Blocked | | | |
| SubjectMatterExpert1 | | | |
| ParentWorkItemId | | | |
| TagNames | | | |
| StateCategory | | | |
| AutomatedTestId | | | |
| AutomatedTestName | | | |
| AutomatedTestStorage | | | |
| AutomatedTestType | | | |
| AutomationStatus | | | |
| StateChangeDate | | | |
| Count |
ORG1
Column Name Description Calculated Column Expression
| WorkItemId | | | |
| InProgressDate | | | |
| CompletedDate | | | |
| LeadTimeDays | | | |
| CycleTimeDays | | | |
| InProgressDateSK | | | |
| CompletedDateSK | | | |
| AnalyticsUpdatedDate | | | |
| ProjectSK | | | |
| WorkItemRevisionSK | | | |
| AreaSK | | | |
| IterationSK | | | |
| AssignedToUserSK | | | |
| ChangedByUserSK | | | |
| CreatedByUserSK | | | |
| ActivatedByUserSK | | | |
| ClosedByUserSK | | | |
| ResolvedByUserSK | | | |
| ActivatedDateSK | | | |
| ChangedDateSK | | | |
| ClosedDateSK | | | |
| CreatedDateSK | | | |
| ResolvedDateSK | | | |
| StateChangeDateSK | | | |
| Revision | | | |
| Watermark | | | |
| Title | | | |
| WorkItemType | | | |
| ChangedDate | | | |
| CreatedDate | | | |
| State | | | |
| Reason | | | |
| FoundIn | | | |
| IntegrationBuild | | | |
| ActivatedDate | | | |
| Activity | | | |
| BusinessValue | | | |
| ClosedDate | | | |
| Issue | | | |
| Priority | | | |
| Rating | | | |
| ResolvedDate | | | |
| ResolvedReason | | | |
| Risk | | | |
| Severity | | | |
| StackRank | | | |
| TimeCriticality | | | |
| ValueArea | | | |
| CompletedWork | | | |
| DueDate | | | |
| Effort | | | |
| FinishDate | | | |
| OriginalEstimate | | | |
| RemainingWork | | | |
| StartDate | | | |
| StoryPoints | | | |
| TargetDate | | | |
| Blocked | | | |
| SubjectMatterExpert1 | | | |
| ParentWorkItemId | | | |
| TagNames | | | |
| StateCategory | | | |
| AutomatedTestId | | | |
| AutomatedTestName | | | |
| AutomatedTestStorage | | | |
| AutomatedTestType | | | |
| AutomationStatus | | | |
| StateChangeDate | | | |
| Count | | | |
| CommentCount |
