Forum Discussion
Helper ICreate a new table by dividing some columns from two tables
Hey,
not sure if I totally understand your requirement, but maybe this will work.
In the Query Editor mark one table and choose "Merge Queries", this allows you to pull columns from the second table into the first table. Be aware, that the Merge Operation does not create a third table. If you really need three tables, copy the queri of one table first.
You have to select column in both tables (the keys), these table identify the same rows, whereas it is not necessary that there are same number of rows in each table identified by the key columns.
In a second step you can expand the newly content and just select the missing columns.
Now you can create custom columns where you divide the columns accordingly.
Hope this helps
Super UserHey,
not sure if I totally understand your requirement, but maybe this will work.
In the Query Editor mark one table and choose "Merge Queries", this allows you to pull columns from the second table into the first table. Be aware, that the Merge Operation does not create a third table. If you really need three tables, copy the queri of one table first.
You have to select column in both tables (the keys), these table identify the same rows, whereas it is not necessary that there are same number of rows in each table identified by the key columns.
In a second step you can expand the newly content and just select the missing columns.
Now you can create custom columns where you divide the columns accordingly.
Hope this helps
Helper IThanks! It works, but I see in the Advanced Editor that it runs the query of the original table behind the scenes. As I've already got a separate query for the other table, I think it is unnecessary to run the query twice. Is it not possible to only reference to the tables?
- TomMartensSure, referencing is sufficient.
- jomikk
How do I do that? :-) Not exactly a power user here, hehe.
- TomMartens
Hey, no problem.
In the Query Editor mark the query you want to reference in the queries pane and choose "Reference" from the context menu
After that you have 2 queries, you should rername the new query properly :-)
rename the new query
Regards