How to combine two fields to get a cartesian product?

[Douwe_KB]

Hi,

I have two fields: CProductgroep and ABAC06. ABAC06 stores a 3 letter code which represents the category of a business, for example CAT. CProductgroep represents a code which represents a product's group. I have the following load: 

Perc:
LOAD
    ABAC06,
    CProductgroep,
    [CProductgroep] & [ABAC06] As Kopp
   
Resident Omzetdata;

 I want to combine the values of CProductgroep and ABAC06 to a combination which represents the possible productgroups and business categories (Klantgroep). For example you could have CAT010, 

CAT030,

CAT050.....

BRB010,

BRB030,

BRB050...

Etc.

The above code does not give me a combination, but instead only gives me the following: 

I want to use this combination later on to do an applymap, where the combination of these two fields is the key.

Any tips are welcome!

[Or]

Load Field1 from Sometable;

Join

Load Field2 from Sometable;

[Douwe_KB]

Can you elaborate?

[BrunPierre · Accepted solution]

Noconcatenate
Tmp:
LOAD CProductgroep Resident Omzetdata;

Left Join

LOAD ABAC06 Resident Omzetdata;

Noconcatenate
"Cartesian product":
LOAD CProductgroep & ABAC06 as Kopp

Resident Tmp;

DROP Table Tmp;