topic Line duplication SQL Select in QlikView

Line duplication SQL Select

Anonymous — Fri, 20 Dec 2013 11:00:29 GMT

Hello,

I'm extracting a table from SQL and the generated table has duplicated lines. The SQL table has no duplicated lines.

I only running the following script, no table before or after and no join just the database connection before.

Item:

LOAD *;

SQL SELECT *

From MDTestDatabase.SAP.ViewItem;

if i use a ditinct, i have the following results:

- LOAD Distinct *: no duplication

- SQL SELECT Distinct *: duplications

So, duplication is generated by LOAD statement and not SQL query.

Any idea?

Thks

Re: Line duplication SQL Select

Peter_Cammaert — Fri, 20 Dec 2013 11:16:38 GMT

Omit the LOAD *; It doesn't do anything, or rather - it isn't supposed to do anything. The Item-table will be created by just executing the SQL SELECT

Weird phenomenon. Are you sure the View isn't populated with too many lines?

Peter

Re: Line duplication SQL Select

Anonymous — Fri, 20 Dec 2013 11:21:29 GMT

I have found the problem.

There are 3 and 000003 as item code and Qlikview change the first in 000003.

Vincen

Re: Line duplication SQL Select

rbecher — Fri, 20 Dec 2013 11:22:45 GMT

It's hard to believe that SQL SELECT Distinct or LOAD Distinct will give a resultset with duplicate rows. Maybe it's related to an associated table in the model?

Could you upload an example?

- Ralf

Re: Line duplication SQL Select

swuehl — Fri, 20 Dec 2013 11:23:51 GMT

Use

LOAD

text(FIELD) as FIELD,

...

if you need to distinguish between 3 and 000003