topic Re: Load Distinct in QlikView

Load Distinct

shakeeb_mohammed — Sat, 16 Nov 2024 04:05:45 GMT

Hi Can anyone help me with the below please?

I am loading in data from a SQL database and i have 2 duplicated values - To try to get rid of this I used SELECT DISTINCT in my SQL Query in load editor but i still get the duplicate values?

I have a field (Job_Number) in my database which is always distinct (in theory) but in the odd occasion within the database its duplicated due to human error. is there a way of telling Qlik to only load data with a distinct Job number?

Re: Load Distinct

HirisH_V7 — Thu, 21 Mar 2019 12:35:19 GMT

when loading into QV you can do a distinct load, but it will work on complete table beside on one column as you specified.

Either other occurrence may have different data in other fields, it will not work. Make sure you identify such cases with a flag in DB itself or by any other means and bring it in resident with a where condition, by excluding not required fields.

My suggestion is to rectify in DB itself, In Qlik it will be performance issue.

HTH,
HirisH