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.
Hi Anonymous
If you looking to Append these tables then having the same names is crucial so the data is in the same column, otherwise, it would be a separate column.
Mariusz
If this post helps, then please consider Accepting it as the solution.
Please feel free to connect with me.
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