There shouldn't be any duplicates as this will not work with many to one relationship. Then, turn to Data tab and click on the Consolidate button. I wish to expand and extract values from all these columns separated with delimiter in same row in respective columns. First off, click a blank cell where you want to place the merged and summed data. Duplicates cannot be removed as there is data in other rows which is required. When I tried to extract values, it gives me error so I have to expand it to new rows which create duplicates in column - 'key'. Most of the projects are using fix versions and versions field where few projects are using other 4 fields.Īs you can see all these 6 columns are list or records. Step 3: Now, select the rows we want to combine. Step 2: After clicking the anchor, get the Clipboard panel. Release Information.įor all JIRA projects in my report, I derived that following 6 fields are used (shown in screenshot). We can easily merge the rows utilizing the Clipboard tool in Excel. The only problem here is one field which is not used in a harmonized way for across all JIRA projects and i.e. I am working on Power BI project where I am fetching data from many JIRA projects.
0 Comments
Leave a Reply. |