Discussion Board for collaboration on QlikView Scripting.
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.
SQL SELECT *
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.
Go to Solution.
I have found the problem.
There are 3 and 000003 as item code and Qlikview change the first in 000003.
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?
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?
text(FIELD) as FIELD,
if you need to distinguish between 3 and 000003