Forum Discussion
Creating/merging a table so that it shows data from multiple tables
I have four excel sheets that contain a lot of similar but different columsn names as well on four different task types (Incidents, Request, Problems and Changes). I have seen it done but cant figure out myself how to create an ‘All cases’ table that sort of links them together so I can create graphs and visuals where I will be able to show multiple task types on one graph or choosing to filter out some using the filter options etc. I have tried this using ‘Merge/Append’ queries when loading in the data but cant quite seem to understand what to do. I have tried loading the data in separately and then trying to manage a relationship between them but I don’t think that’s right either. There is a task type column in each excel which defines which task each thing is so don’t know if that means I could use that as a point of reference. I think I need to merge/append them somehow into one table then link the tables together but getting stuck, any ideas? Thank you
Hi Anonymous ,
Are there any relationships between the four tables?
If they are parts of one table, you could use "Append Queries" feature.
7 Replies
Thank you for responding so quick, I have put the four excels into 4 tabs of one excel sheet but unsure if I can attach here, I will look to find you on LinkedIn to send an email with the document. Ideally need to load this data into Power BI so I guess I would have 4 tables, one for each task type that I would hide and they would all link together into one 'All Cases' table that I would use for my graphs and visuals. As they share some columns but not all, I assume the 'All Cases' would need to have every unique column name right?
