Forum Discussion
combinar consultas
rdiazd73
If you want to create report to include both tables values, you can create a many to one relationship for table 1=>table 2 using [codigo[ column, then you can put the column in one table visual and do calculation on table 2 using related(table1[column]).If you want to put 2 tables in 1 table, you can just use merge or append feature in query editor.
Paul Zheng _ Community Support Team
If this post helps, please Accept it as the solution to help the other members find it more quickly.
rdiazd73
If you want to create report to include both tables values, you can create a many to one relationship for table 1=>table 2 using [codigo[ column, then you can put the column in one table visual and do calculation on table 2 using related(table1[column]).
If you want to put 2 tables in 1 table, you can just use merge or append feature in query editor.
Paul Zheng _ Community Support Team
If this post helps, please Accept it as the solution to help the other members find it more quickly.