topic Re: Add flag in script for duplicate ids in QlikView

Add flag in script for duplicate ids

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

Hello I would like to add a flag in my script that captures duplicate ids. How can this be done within the script?

ID Indicator

1 x

4 x

sunny_talwar — Mon, 07 Mar 2016 18:26:59 GMT

Something like this:

Table:

LOAD * Inline [

];

Left Join (Table)

LOAD ID,

If(Count(ID) > 1, 'x') as Indicator

Resident Table

Group By ID;