Forum Discussion
Resolver IICopy a New Column from Table 2 to Table where all the other Row Value Matches
I have a Table called Sprint Master
| PROJECT_KEY | BOARD_NAME | ISSUE_KEY | SPRINT_NAME | SPRINT_NUMBER | INITIAL_ESTIMATE | CURRENT_ESTIMATE | SPRINT_REPORT_STATUS | IS_ADDED_DURING_SPRINT | STORY_POINTS_COMMITTED | STORY_POINTS_EXTRA_PULLED | STORY_POINTS_COMPLETED | STORY_POINTS_EXTRA_COMPLETED | STORY_POINTS_NOT_COMPLETED | STORY_POINTS_REMOVED | ISSUE_TYPE_NAME | ISSUE_STATUS_NAME | PRIORITY | RESOLUTION | CREATED | Detailed_Affected_Version | Story_Points | Task_Type | STATE | START_DATE | END_DATE | COMPLETE_DATE | STORY_COMITTED | STORY_POINTS_COMMITED_START |
| ABC | ABC Scrum Board | ABC-473 | ABC Sprint 31 | 31 | 3 | 3 | INCOMPLETED | FALSE | 3 | 0 | null | null | 3 | 0 | Story | Closed | Major | Fixed | 22-09-2022 11:14:16 +00:00 | null | 3 | null | closed | 06-05-2024 13:00:50 +00:00 | 24-05-2024 17:00:00 +00:00 | 27-05-2024 06:32:08 +00:00 | 1 | 3 |
| ABC | ABC Scrum Board | ABC-473 | ABC Sprint 32 | 32 | 3 | 3 | INCOMPLETED | FALSE | 3 | 0 | null | null | 3 | 0 | Story | Closed | Major | Fixed | 22-09-2022 11:14:16 +00:00 | null | 3 | null | closed | 27-05-2024 13:58:34 +00:00 | 14-06-2024 18:00:00 +00:00 | 15-06-2024 10:09:34 +00:00 | 1 | 3 |
| ABC | ABC Scrum Board | ABC-473 | ABC Sprint 33 | 33 | 3 | 3 | COMPLETED | FALSE | 3 | 0 | 3 | 0 | 0 | 0 | Story | Closed | Major | Fixed | 22-09-2022 11:14:16 +00:00 | null | 3 | null | closed | 17-06-2024 13:01:04 +00:00 | 05-07-2024 19:00:00 +00:00 | 08-07-2024 07:08:23 +00:00 | 1 | 3 |
I have another Table called UNIQUE_STORY_POINTS
| PROJECT_KEY | BOARD_NAME | ISSUE_KEY | SPRINT_NAME | SPRINT_NUMBER | INITIAL_ESTIMATE | CURRENT_ESTIMATE | SPRINT_REPORT_STATUS | IS_ADDED_DURING_SPRINT | STORY_POINTS_COMMITTED | STORY_POINTS_EXTRA_PULLED | STORY_POINTS_COMPLETED | STORY_POINTS_EXTRA_COMPLETED | STORY_POINTS_NOT_COMPLETED | STORY_POINTS_REMOVED | ISSUE_TYPE_NAME | ISSUE_STATUS_NAME | PRIORITY | RESOLUTION | CREATED | Detailed_Affected_Version | Story_Points | Task_Type | STATE | START_DATE | END_DATE | COMPLETE_DATE | STORY_COMITTED | STORY_POINTS_COMMITED_START | TOTAL_UNIQUE_STORY_POINTS | |
| ABC | ABC Scrum Board | ABC-473 | ABC Sprint 33 | 33 | 3 | 3 | COMPLETED | FALSE | 3 | 0 | 3 | 0 | 0 | 0 | Story | Closed | Major | Fixed | 22-09-2022 11:14:16 +00:00 | null | 3 | null | closed | 17-06-2024 13:01:04 +00:00 | 05-07-2024 19:00:00 +00:00 | 08-07-2024 07:08:23 +00:00 | 1 | 3 | 3 |
In Table UNIQUE_STORY_POINTS there is a column called TOTAL_UNIQUE_STORY_POINTS. I want to copy this column to Table SPRINT_MASTER when there is a exatch match with all the column values of that particular row. Where there is no match add zero (0).
The difference is the SPRINT_MASTER Table has Story points moved across sprints where as in UNIQUE_STORY_POINTS Table i have considered it only once.So to calculate TOTAL_UNIQUE_STORY_POINTS and to build all visuals from SPRINT_MASTER table i would need this.
Can you please help.
Hi JeevanMallya,
You can use the Merge option on the Home tab to achieve this. Select the target table, go to Home, and click Merge. From the dropdown menu, select the lookup table. Now set merge keys by holding down CTRL and selecting a column within the target table and its equivalent from the lookup table. Repeat this process until all columns are mapped. A small numeral will show when multiple columns are selected, helping to identify each set of keys.
Next, use the sideward arrows in the merge result column to expand the desired field. Optionally, replace null with 0.Note that when a Merge matches more than 1 row in the lookup table, expanding the column will add a row for each matched result, leading to "duplication" of rows.
I hope this is helpful.
1 Reply
- m_dekorte
Resident Rockstar
Hi JeevanMallya,
You can use the Merge option on the Home tab to achieve this. Select the target table, go to Home, and click Merge. From the dropdown menu, select the lookup table. Now set merge keys by holding down CTRL and selecting a column within the target table and its equivalent from the lookup table. Repeat this process until all columns are mapped. A small numeral will show when multiple columns are selected, helping to identify each set of keys.
Next, use the sideward arrows in the merge result column to expand the desired field. Optionally, replace null with 0.Note that when a Merge matches more than 1 row in the lookup table, expanding the column will add a row for each matched result, leading to "duplication" of rows.
I hope this is helpful.