2 Replies Latest reply: Nov 16, 2012 1:53 PM by Gysbert Wassenaar RSS

    Field Names must be unique in CONCATENATE Table

    Jaime Marines

      Hello QV Community;

       

      When I try to reload below script in order to get matching and non matching fileds, I get message:

      Field Names must be unique in CONCATENATE Table

       

      What am I doing wrong?

      Directory;
      TablaA:
      LOAD *
      ,'Table 1' as Table,
          REMISION as remision,
          AEROPUERTO as idestacion,
          LITROS as vnatural
      FROM
      [C:\Users\jmarinesc\Downloads\SIAMCO\01_DATA\SQL\QVD\PedidosVentas1Jun2010.qvd](qvd);

      CONCATENATE

      //***************MOVIMIENTO TABLE******************

      LOAD*
      ,'Table 2' as Table,
          remision,
          idestacion,
          vnatural
      FROM
      [C:\Users\jmarinesc\Downloads\SIAMCO\01_DATA\SQL\QVD\Movs1Jun2010.qvd](qvd);

      //******************INNER JOIN*************************
      INNER JOIN (Table)
      LOAD *
      WHERE "Only in One Table?"
        OR  "idestacion Different?"
        OR  "vnatural Different?"
      ;
      LOAD
      remision
      ,if(count(remision)<2,-1) as "Only in One Table?"
      ,if(maxstring(idestacion)<>minstring(idestacion),-1) as "idestacion Different?"
      ,if(max(vnatural)<>min(vnatural),-1) as "vnatural Different?"
      RESIDENT Table
      GROUP BY remision;

      STORE Table INTO C:\Users\jmarinesc\Downloads\SIAMCO\01_DATA\SQL\QVD\ESLK1JJOINA.qvd; 

       

      Regards

       

      James

        • Re: Field Names must be unique in CONCATENATE Table

          Dear Jaime.

           

           

          the error is due to Load *.

           

          no need to Write * after load ,

          if you write * it will take all the fileds from that table.

          if you write * then no need to write all the fields names.

           

          either you can you Load * or Load fieldnames.

           

          you can't use both .

          like,

          Table:

          LOAD

          *

          FROM

          C:\Users\pss\Desktop\Test.xlsx

          (ooxml, embedded labels, table is Sheet1);

           

           

          Or

           

           

          LOAD SNO,

               NAME

          FROM

          C:\Users\pss\Desktop\Test.xlsx

          (ooxml, embedded labels, table is Sheet1);

           

          both the above statement will give the same result.

           

          your script should be like these

           

          TablaA:
          LOAD
          'Table 1' as Table,
              REMISION as remision,
              AEROPUERTO as idestacion,
              LITROS as vnatural
          FROM
          [C:\Users\jmarinesc\Downloads\SIAMCO\01_DATA\SQL\QVD\PedidosVentas1Jun2010.qvd](qvd);

          CONCATENATE(TablaA)

          //***************MOVIMIENTO TABLE******************

          LOAD
          'Table 2' as Table,
              remision,
              idestacion,
              vnatural
          FROM
          [C:\Users\jmarinesc\Downloads\SIAMCO\01_DATA\SQL\QVD\Movs1Jun2010.qvd](qvd);

           

           

           

          Thanks,

          Mukram

          • Re: Field Names must be unique in CONCATENATE Table
            Gysbert Wassenaar

            You load all fields from Movs1Jun2010.qvd with * and then you additionally load the fields remision, idestacion and vnatural again without renaming them. So you try to load these fields twice with the same name. I think that's the problem qlikview complains about.

             

            LOAD*

            ,'Table 2' as Table,

                remision,

                idestacion,

                vnatural

            FROM

            [C:\Users\jmarinesc\Downloads\SIAMCO\01_DATA\SQL\QVD\Movs1Jun2010.qvd](qvd);