14 Replies Latest reply: Jun 3, 2014 9:44 AM by João Paulo Kuramoto RSS

    Synthetic Keys not created automatically

      People, I started working with Qlikview last week, and there's my problem bellow.

       

      I have to load 2 tables with finance information, and they have 3 columns in common. When I load, give me an error: 'Execution of Script Failed. Reload old data?'

       

      Check the statements bellow:

       

      SQL SELECT

      MONTHY,

      QUARTER,

      YEAR

      FROM "DBM_MKT".dbo."TIME";

       

       

      SQL SELECT

      PK_AGENCY,

      NAME_AGENCY,

      DISTRICT,

      SR,

      SUAT,

      REGION,

      WORKERID,

      NAME_WORKER

      FROM "DBM_MKT".dbo."GEO"

      WHERE SUAT LIKE 'AREA%';

       

       

      SQL SELECT

      PK_AGENCY,

      MONTHY,

      PRODUCT,

      TRANSACTION,

      QUALITYSELL,

      AMOUNT

      FROM "DBM_MKT".dbo."QUALITY_SELL";

       

       

      SQL SELECT

      PK_AGENCY,

      MONTHY,

      PRODUCT,

      SUMVALUE

      FROM "DBM_MKT".dbo."SELL_VALUE";

       

      Someone can help me?