Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?