Deriving a New table from existing tables

george456 — Thu, 04 Feb 2021 12:37:55 GMT

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

Re: Deriving a New table from existing tables

melghandour89 — Thu, 04 Feb 2021 13:35:20 GMT

Hello Try Load ... Resident

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

Thanks