Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Not applicable

Synthetic Keys Issue

Hello friends,

I am facing a problem with synthetic keys, and memory.

what I want is to create keys (but not synthetics ones) between the tables. The alternative of using 'concatenate' before the LOAD statement transforms the model to one table. The problem is the number of tables I need to load (12 tables), I cannot use concatenate because of the memory problem (imagine all the tables concatenated into one, the execution would be very slow) .

Here is my script:

SET ThousandSep=' ';
SET DecimalSep=',';
SET MoneyThousandSep=' ';
SET MoneyDecimalSep=',';
SET MoneyFormat='# ##0,00 €;-# ##0,00 €';
SET TimeFormat='hh:mm:ss';
SET DateFormat='DD/MM/YYYY';
SET TimestampFormat='DD/MM/YYYY hh:mm:ss[.fff]';
SET FirstWeekDay=0;
SET BrokenWeeks=0;
SET ReferenceDay=4;
SET FirstMonthOfYear=1;
SET CollationLocale='fr-FR';
SET CreateSearchIndexOnReload=1;
SET MonthNames='janv.;févr.;mars;avr.;mai;juin;juil.;août;sept.;oct.;nov.;déc.';
SET LongMonthNames='janvier;février;mars;avril;mai;juin;juillet;août;septembre;octobre;novembre;décembre';
SET DayNames='lun.;mar.;mer.;jeu.;ven.;sam.;dim.';
SET LongDayNames='lundi;mardi;mercredi;jeudi;vendredi;samedi;dimanche';


LIB CONNECT TO 'ole db';

LOAD `A/C Family`,
    CDT,
    `Champ_NEO`,
    `Commodity group`,
    `Commodity PROC`,
    `Cons MRP Controller`,
    `Cons Ordering Org`,
    `Consumer Plant`,
    Field10,
    Field12,
    Field15,
    Field17,
    Field22,
    Field24,
    Field26,
    Field29,
    Field5,
    Field7,
    `Fulfilment Rate`,
    `Indicator: Critical`,
    Location,
    Material,
    `Missing char`,
    `Nb MP`,
    `Nb MP 7 days`,
    `Nb WOL 7 days`,
    Plant,
    Program,
    `Program Family`,
    `Prov MRP Controller`,
    `Prov Ordering Org`,
    `Requirement Date`,
    `Requirement Week`,
    Station,
    `Storage Location`,
    `Supplier Type`,
    Vendor,
    `Work Order Material`,
    `Work Order Number`,
    `Work order type`,
    `Work Package`;

FROM `Req_FR`;

LOAD `A/C`,
    `A/C Family`,
    Cat,
    CDT,
    `Consuming Plant`,
    `Consuming Plant Desc`,
    `Days Missing`,
    `Entité client`,
    `Entité responsable`,
    `Fab_Element`,
    `Flux Tiré Cons`,
    `Flux Tiré Fourn`,
    `Fourn# Ordering Org#`,
    `LEGACY Prog`,
    `Ligne de produit`,
    Material,
    `Material Desc`,
    `Missing Qty`,
    `MP Date Range`,
    `MP Flag Set Date`,
    `MRP Controller client`,
    `MRP Controller client Desc`,
    `MRP Controller responsable`,
    `MRP Controller responsable Desc`,
    MSN,
    `Nb j en Mqt`,
    `Part_type`,
    `Pièce Critique`,
    Plant,
    `Product_Line`,
    Program,
    `Program Family`,
    `Qté Mqt`,
    `Required Quantity`,
    `Requirement Date`,
    `Reservation Item`,
    `Reservation No`,
    `SAP_system`,
    Semaine,
    `Site client`,
    `Station (incl stage)`,
    `Storage Location`,
    `Supplier Type`,
    `TOTAL`,
    `Type APPRO`,
    Vendor,
    `Week`,
    `Work Order Material`,
    `Work Order Material Desc`,
    `Work Order Number`,
    `Work Order type`,
    `Work Package`;

FROM `Req_MP`;

the model

Capture.JPG

1 Solution

Accepted Solutions
Highlighted
Not applicable

Re: Synthetic Keys Issue

Concatenation.

1 Reply
Highlighted
Not applicable

Re: Synthetic Keys Issue

Concatenation.