Add flag in script for duplicate ids

[Anonymous]

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

1         x

2

3

4        x

4        x

[sunny_talwar · Accepted solution]

Something like this:

Table:

LOAD * Inline [

ID

1

1

2

3

4

4

];

Left Join (Table)

LOAD ID,

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

Resident Table

Group By ID;