Multiple Value trace?

[ganeshreddy]

Hi All,

How to find multiple values in a specific field in script, as mentioned below.

C_No          D_No        Grade

23125          2345            A

45689          2345            C

89089          4568            A

32576          2345            B

90976          1234            C

In the above table D_No repeated 3 times, here how to identify the repetition. If it is repeated i need to perform some operations. Please help me on this.

Cheers,

Ganesh

[sunny_talwar · Accepted solution]

Try this script:

Table:

LOAD * INLINE [

    C_No, D_No, Grade

    23125, 2345, A

    45689, 2345, C

    89089, 4568, A

    32576, 2345, B

    90976, 1234, C

];

Join(Table)

LOAD D_No,

  Count(D_No) as Count

Resident Table

Group By D_No;

Output:

[Gysbert_Wassenaar]

Perhaps you can use the Exists function:

LOAD

     C_No,

     D_No,

     Grade,

     if(Exist(D_No), 0, 1) as IsNew

FROM ...