2 Replies Latest reply: Nov 7, 2018 12:07 PM by Mark Little RSS

    Loading into multiples qlikSense tables keep only the first one

    Marcelo Caetano Goncalves

      Hi Guys.

       

      Executing the following script makes QlikSense keep only the fist table. What I'm doing wrong?

      See attachments.

       

      [DescontosAtivosItem]:

      Load *;

      SQL Select * FROM dbo.VW_DESCONTOS WHERE Ativo = 'S' AND TipoDescontoId = 0;

      [DescontosAtivosPromoProd]:

      Load *;

      SQL Select * FROM dbo.VW_DESCONTOS WHERE Ativo = 'S' AND TipoDescontoId = 1;

      [DescontosAtivosPromo]:

      Load *;

      SQL Select * FROM dbo.VW_DESCONTOS WHERE Ativo = 'S' AND TipoDescontoId = 2;

      [DescontosAtivosProdCli]:

      Load *;

      SQL Select * FROM dbo.VW_DESCONTOS WHERE Ativo = 'S' AND TipoDescontoId = 3;

      [DescontosAtivosCli]:

      Load *;

      SQL Select * FROM dbo.VW_DESCONTOS WHERE Ativo = 'S' AND TipoDescontoId = 4;

      [DescontosAtivosCanal]:

      Load *;

      SQL Select * FROM dbo.VW_DESCONTOS WHERE Ativo = 'S' AND TipoDescontoId = 5;

      [DescontosAtivosClientePromo]:

      Load *;

      SQL Select * FROM dbo.VW_DESCONTOS WHERE Ativo = 'S' AND TipoDescontoId = 6;

       

      LOAD LOG:

       

      Connected

      DescontosAtivosItem << VW_DESCONTOS

      Lines fetched: 829.832

      DescontosAtivosItem << VW_DESCONTOS

      Lines fetched: 883.381

      DescontosAtivosItem << VW_DESCONTOS

      Lines fetched: 883.381

      DescontosAtivosItem << VW_DESCONTOS

      Lines fetched: 932.640

      DescontosAtivosItem << VW_DESCONTOS

      Lines fetched: 1.021.923

      DescontosAtivosItem << VW_DESCONTOS

      Lines fetched: 1.021.923

      DescontosAtivosItem << VW_DESCONTOS

      Lines fetched: 1.025.203