Forum Discussion
Creating/merging a table so that it shows data from multiple tables
Hi Anonymous ,
Are there any relationships between the four tables?
If they are parts of one table, you could use "Append Queries" feature.
As you can see I have copied in the four excels, using just a few lines to keep it simple. When I want to load this data into Power BI are we saying that to create a table containing all the four tables, there would need to be a column for each unique name (i.e if excel one has Name, caller, task type and excel two has name, task type, group.....I would need to create a column for caller and group when I append/merge?)
Excel 1
| Number | Company | Caller | Opened | Task Type |
| INC08279 | A | Adam | 2020-06-30 22:08:59 | Incident |
| INC08279 | A | Jay | 2020-06-30 22:08:57 | Incident |
| INC08279 | A | Adam | 2020-06-30 22:08:57 | Incident |
Excel 2
| Company | Number | Short description | State | Opened | Close code | Created | Task type | Caller |
| A | CHG00372 | Test | Canceled | 2020-06-16 11:06:36 | 2020-06-16 11:09:33 | Change Request | Bill | |
| A | CHG00372 | Test | Authorize | 2020-06-05 11:25:07 | 2020-06-05 11:32:18 | Change Request | Eng | |
| A | CHG00371 | Test | New | 2020-06-02 16:49:18 | 2020-06-02 16:56:11 | Change Request | Rob | |
| A | CHG00371 | Test | Assess | 2020-06-01 13:45:18 | 2020-06-01 13:45:19 | Change Request | Tim | |
| A | CHG00371 | Test | Closed | 2020-05-26 09:06:41 | Successful | 2020-05-26 09:06:41 | Change Request | John |
Excel 3
| Company | Number | Opened | Task type | Assignment group | Configuration item | Related Incidents | Priority |
| A | PRB004322 | ########### | Problem | Client Feedback | 0 | 4 - Low | |
| A | PRB004299 | ########### | Problem | Problem Management | 0 | 4 - Low | |
| A | PRB004290 | ########### | Problem | Problem Management | 1 | 3 - Moderate |
Excel 4
| Number | Item | State | Company | Task Type | Assigned to |
| RITM02166 | Make A General Request | Fulfilled | A | Request | engineer |
| RITM02166 | Make A General Request | Fulfilled | A | Request | engineer |
Hi Anonymous ,
Are there any relationships between the four tables?
If they are parts of one table, you could use "Append Queries" feature.
Well I have to get the tables seperatly but as you can see, they do share a lot of similar column headers but obviously there will be some that will have different ones (i.e some columns from the change table will not feature in the incident table) but I guess thats ok as in the example you have given above, we would just append these and no data would be there but thats fine as I wouldnt expect it to be and the visuals/graphs I want to create wouldnt require it. I will try this out and let you know if it works
Thank you