How to link category group values to category group?

[Douwe_KB]

Hello,

I have a field called [Klantinformatie], which stores data about customers, such as to which category of businesses they belong: 

[Klantinformatie]:
LOAD
                [ABAN8]                                                                                                            as "Klantnummer",
                [ABALPH]                                                                                                           as "Klantnaam",
                //[ABAT1]                                                                                                         as "Klanttype",
                [ABAC01],
    ApplyMap('MapDC', ABAC01,'-')                                                                          as "Vestiging",
                [ABAC03],                                                                                                                                                                        
    ApplyMap('MapVertegenwoordiger', ABAC03,'Intern')                             As "Vertegenwoordiger",
                [ABAC06],
    ApplyMap('MapKlantgroep', ABAC06,'-')                                                         as "Klantgroep"
FROM [lib://QlikView JDE extractie/F0101.QVD]
(qvd);

I also have a seperate file which stores the category of business + product category and the desired percentage of sales per product category, which looks as follows: 

Which I load in as follows: 

Koppelingen:
LOAD
Koppeling,
Percentage
FROM [lib://AttachedFiles/Koppelinggg.xlsx]
(ooxml, embedded labels, table is Blad1);

Suppose I have a company "Test" which belongs to the "CAT" category of businesses. How do I map these values for all product categories to the "CAT" category?

All help is appreciated!

[Or]

The above doesn't seem to contain a field called Klantinformatie (that's the internal name of the table, but not a field), nor a field called Company, so I'm a bit confused as to what you're trying to do exactly.

Generally speaking, if you have a table that contains Company and Koppeling, it will automatically create a key to the Koppeling field in the existing load by virtue of identical field names.