Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
I have found the problem.
There are 3 and 000003 as item code and Qlikview change the first in 000003.
Vincen
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
I have found the problem.
There are 3 and 000003 as item code and Qlikview change the first in 000003.
Vincen
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
Use
LOAD
text(FIELD) as FIELD,
...
if you need to distinguish between 3 and 000003