Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
If all the field names are the same, each table will automatically concatenate (append) the first table.
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