Combine values from two tables

[PBrainNWH]

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

[Anonymous · Accepted solution]

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