Loading into multiples qlikSense tables keep only the first one

[mestredigital]

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

[Lisa_P]

If all the field names are the same, each table will automatically concatenate (append) the first table.

[Mark_Little]

Hi

As Lisa has said as all the tables have the same field that have automatically been concatenated.

how you fix this is depends on how you need your data model.

If you want multiple tables you want to add

Qualify *;

At the start of your script.

Mark