Deriving a New table from existing tables

[george456]

Dear Community

I have a typical star schema layout and I need to create a summarized table from two resident tables in order to link another input file 

Table A                                                     Table B

Customers                                             Customer Groups

Sales                                                         Customers

Product Code

The New Table must be:

Customer Groups

Product code

Sales ( Group by Customer Groups)

Please can you assist me in this. 

Thanks

[melghandour89 · Accepted solution]

Hello Try Load ... Resident 

Noconcatenate
MergeTable:
LOAD *
resident TableA;
LEFT JOIN (MergeTable)
LOAD *
resident TableB;
Drop Table TableA, TableB;

Thanks