Forum Discussion
Solved
Create table getting data from table hosted in another query
Hi all, I need to create a table with 3 columns getting data from another tables that are in another queries. I would like to use advanced editor to create this table. Example: Column...
Hi, Please follow the Image:
If you need a New Merge Table Select Merge Queries as New
Hi,
I have the column Product Name that I can use to create the relationship.
Follow the sample about the tables:
Table 1:
| Product Name | Contracted |
| Product1 | 100 |
| Product2 | 200 |
| Product3 | 300 |
| Product4 | 400 |
| Product5 | 500 |
Table 2:
| User | Product Name | Computer | Last Logon | |
| User1 | [email protected] | Product1 | Computer1 | User1 |
| User2 | [email protected] | Product3 | Computer2 | User2 |
| User3 | [email protected] | Product5 | Computer3 | User3 |
| User4 | [email protected] | Product2 | Computer4 | User4 |
| User5 | [email protected] | Product4 | Computer5 | User5 |
| User6 | [email protected] | Product2 | Computer6 | User6 |
| User7 | [email protected] | Product4 | Computer7 | User7 |
| User8 | [email protected] | Product1 | Computer8 | User8 |
| User9 | [email protected] | Product5 | Computer9 | User9 |
| User10 | [email protected] | Product5 | Computer10 | User10 |
| User11 | [email protected] | Product1 | Computer11 | User11 |
| User12 | [email protected] | Product5 | Computer12 | User12 |
| User13 | [email protected] | Product2 | Computer13 | User13 |
| User14 | [email protected] | Product5 | Computer14 | User14 |
| User15 | [email protected] | Product4 | Computer15 | User15 |
| User16 | [email protected] | Product1 | Computer16 | User16 |
| User17 | [email protected] | Product3 | Computer17 | User17 |
| User18 | [email protected] | Product2 | Computer18 | User18 |
| User19 | [email protected] | Product4 | Computer19 | User19 |
| User20 | [email protected] | Product1 | Computer20 | User20 |
Table that I need:
| Product Name | Contracted | In Use |
| Product1 | 100 | 5 |
| Product2 | 200 | 4 |
| Product3 | 300 | 2 |
| Product4 | 400 | 4 |
| Product5 | 500 | 5 |
I need do drill down in the last column from in this last table.
Tks,
Hi, Please follow the Image:
If you need a New Merge Table Select Merge Queries as New
Hi Vvelarde
In this example you merger 2 tables.
Is it possible merge another one using the same column name?
Then we will use 3 tables.
Tks!!
Hi baironaguillera,
As I tested, we are unable to merge three table at one time. You can merge the two tables to one new table, then merge new table to third table.
Best Regards,
Angelia
