Forum Discussion
Combine two tables
hi, dennis1994 acanepa
1. Import the data from TABLE1
2. Import the data from TABLE2
3. Edit the query in TABLE2 and remove the duplicates
4. Combine tables TABLE1 and TABLE2
5. Group the values (as pictured)
Please try and test using it. And please mark the right answer as answer if your issue has been resolved, otherwise, please feel free to ask if you have any other issue.
Best Regards,
Rfranca
Hello acanepa,
Thanks for the fast reply. Where exactly do i need to input the code? When i try to create a new table i get following error:
Ok i found my mistake.
The outcome is not completely how i would like to have it. What i get is a table with 7 rows:
What i want is a table with just 4 rows and the added column. As for several dates there are multiple rows in both tables, i get more rows then i want, what later falsifies my measures.
Another way i could think of is to "sum" table 1 something like:
If there are multiple values of column x for one date (e.g.: 09.01 has value 1 and value 0 -->two differnt rows) sum them so that there is just one row for that date
Something like this: