UDF to remove unique value

[former_member203104]

Hi,

Can anyone please help in the following logic, Where we need to delete unique values of queue and replace with X.

We have incoming structure like

1

2

3

5

1

4

5

output should be like

1

X

X

X

1

X

X

TIA

[Former Member · Accepted solution]

Hi ,

Please try this:

for (int i = 0 ; i < var1.length; i++)
{
boolean flag = false;
for (int j = 0 ; j< var1.length; j++)
{
if ( (i != j)  && (var1[i].equals(var1[j])) )
{    flag= true;
break;
}

}
if (flag == false)
  result.addValue("X");
else
result.addValue(var1[i]);
}

[former_member203104 · Accepted solution]

Thanks Beena

[smavachee]

Use of if-else..

if <value=1>

  value = <pass"1">

else

  value = <constant"X">

end

Hope it helps.!

Regards,

Sunil

[former_member203104]

Hi Sunil,

Thanks. But the values i gave are not constants, They will change from file to file. I would have used if else , if they are constant.