![]() ![]() Now we are ready to join these two lists together using a Merge query. ![]() Join the Two Connection Only Queries with a Merge Query You should have two connection only queries called List1 and List2. In the Import Data dialog box, select Only Create Connection and then press the OK button. ![]() Go to the Home tab in the query editor and press the lower part of the Close & Load button then select Close & Load To from the menu. Add a constant to the Custom column formula.This can be any text or number, just make sure it’s the same in both list queries. In the Custom Column dialog box add a constant formula. Select a cell in your list and then go to the Data tab and select the From Table/Range command in the Get & Transform Data section.įrom the query editor go to the Add Column tab and select Custom Column from the menu. We will then use this column to join our two tables together using a merge query. Download Example File Create a Connection Only Query for the Two Listsįor each table, we’re going to create a connection only query that adds a column with the same constant value in each row. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. Archives
January 2023
Categories |