ODATA Join Two Tables in Excel

In the video, the process of joining two tables in Excel using ODATA is demonstrated. The focus is on combining the Account Table and the General Ledger (GL) table to enhance the key table with additional information. To begin, navigate to the Data Queries and Connections section, then double-click on the GL query. From there, access the Home tab, select the "Merge Queries" dropdown, and choose "Merge Queries." This action will display the two data sources, defaulting to GL on the top and Account on the bottom. The next step involves selecting the columns to join on, typically the Company Source and the count ID. By holding down the control key, you can select both fields to establish the join. After configuring the join settings, clicking OK will integrate the FIN statement account table into the GL query.

Once the tables are merged, you can expand the joined data and choose specific columns to include. After selecting the desired columns, click OK to finalize the merge. Returning to Excel, select "Close and Load" to begin loading the data into the spreadsheet. This process effectively combines the data from both tables, allowing for a comprehensive view in your GL query. The tutorial simplifies the steps, making it straightforward to enhance your Excel data analysis with additional insights from multiple tables.