Forum Discussion
Single Visualization from Separate Tables
Hi,
The video at this link should help - Power Query #08: Import Multiple Excel Sheets From Multiple Excel Workbooks - YouTube.
If possible, the best thing to do would be to append your four tables together. Rename the columns in all 4 queries to make them the same, so when you append they all go into the same columns. Hopefully you have similar columns in each (Date, Amount, EmployeeID, etc.). You can add a custom column to each before the append with a constant text value to indicate the source (Lyft, etc.). Once appended, you can uncheck Enable Load on the 4 source queries. Your analysis and visualization will be much simpler if you can do that.
Regards,
Pat
That makes sense to simplify the input to the visual...If you're (@mahoneypat) able, I have a follow up question. I looked at the Microsoft User Docs for Appending (https://docs.microsoft.com/en-us/power-query/append-queries). It does not appear that I have the menu available that is shown in the document in order to append. Are there troubleshooting steps to add this?
Hi,
The video at this link should help - Power Query #08: Import Multiple Excel Sheets From Multiple Excel Workbooks - YouTube.