Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in Toronto Sept 9th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
mestredigital
Contributor
Contributor

Loading into multiples qlikSense tables keep only the first one

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

2 Replies
Lisa_P
Employee
Employee

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

Mark_Little
Luminary
Luminary

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