Forum Discussion
Group All Rows - Possible to keep table Relationships?
I have a fact table that has multiple elements associated with it, these elements have their own relationship tables. Table 1 - Elements in model Key Name Type 1 Table 4x6' 2 Cha...
Hi SamuelAB ,
Not very clear about your expected result, but why not just use Home>Merge Queries instead of Group By.
Then both select the Key column as matching column. As there're more keys in the second table, you can choose Right Outer join kind here.
After merge, they are in the same table.
If you don't want to change the original table, you can choose Merge Queries as New.
Best Regards,
Community Support Team _ kalyj
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.