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...
Hi Anonymous ,
Are there any relationships between the four tables?
If they are parts of one table, you could use "Append Queries" feature.
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?
