topic Unique combination of fields in QlikView

Unique combination of fields

Wed, 23 Oct 2013 16:19:02 GMT

My qlikview-file exists of 1 big table.

In this table a combination of fields should be unique.(However the input has to be correct)

What would be a good way to check if a combination of fields within a table is indeed unique?

Let's say I want t check if the combination of the fields:

[Date], [department], [activity], [uom]

is unique at the time the script is reloaded

rwunderlich — Wed, 23 Oct 2013 16:38:04 GMT

There are a couple of ways to do it depending on what you want to do if you have duplicates.

CountTable:

LOAD Sum(1) as ComboCount

RESIDENT MyTable

GROUP BY [Date], [department], [activity], [uom]

;

IF NoOfRows('CountTable') < NoOfRows('MyTable') THEN

TRACE Non-Uniques values in MyTable;

ENDIF

tresB — Wed, 23 Oct 2013 17:08:32 GMT

Perhaps using DISTINCT, like:

Load DISTINCT

[Date],

[department],

[activity],

[uom]

From <>;