Forum Discussion
Combine subsets from two existing tables in one new table.
Community ChampionHi Guataha
You can use Merge Queries as per the video below.
https://www.youtube.com/watch?v=dTdFt9AvDHA
Mariusz
If this post helps, then please consider Accepting it as the solution.
Please feel free to connect with me.
Thanks for the hint
Tried the following:
Duplicate my existing tabels 1 and 2.
Merge Table 4 with Table 1. Added only 1 colom. Filter on the data added from Table 4, so I only keep the account I want to use.
Merge Table 6 with Table 2. Added only 1 colom. Filter on the data added from Table 6, so I only keep the account I want to use.
Deleted every colom from the duplicate table 1 and 2, that I did not need.
I aligned the colom names between duplicate 1 and 2.
Append table 1 with table 2.
Seems to be working. Need to test the data. Only thing I forgot, was that I need to flip the sign for the data in table 2.
One more question. Do I want to keep the duplicate table 2, after appending this with duplicate table 1. Or can I delete this table?
- Mariusz