Forum Discussion
Combine values from two tables
I want to do some time intelligence on two unrelated tables. Both have department code and item number. My goal is to add the dollars from both tables and present the totals by FY month. So thinking I need to create a new table and add columns from both.
Table 1 = Department Code, Posting Date, Item Amount
Table 2 = Department Code, Expected Date, Item Amount
Hi PBrainNWH,
Account to your snapshot, it seems like each 'department code' has multiple rows of records with different date values.
For this scenario, you can't directly union these two table records, they may combine with the wrong records.
Does these any other fields in your tables to help accurate mapping two table records? Please share some more detail information about this.
How to Get Your Question Answered Quickly
Regards,
Xiaoxin Sheng
1 Reply
Hi PBrainNWH,
Account to your snapshot, it seems like each 'department code' has multiple rows of records with different date values.
For this scenario, you can't directly union these two table records, they may combine with the wrong records.
Does these any other fields in your tables to help accurate mapping two table records? Please share some more detail information about this.
How to Get Your Question Answered Quickly
Regards,
Xiaoxin Sheng