need UDF

[nageswararao_v2]

Hi Experts,

i have a requirement.

we have 1-10 fields if 10 fields if all are exists and it contains empty values then we don't need to create the target root node.

if we have any one of the filed contains the value then we have to create the target node.

field 1=""

filed2=""

.

.

filed10=""

then no need to create target root node.

filed1=""

filed2=""

.

.

filed5="123afd"  (some value)

.

.

filed10=""

if any one of them having any value then we have to create the target root node.

Please suggest UDF code for this.

Regards,

Nagesh

[pvishnuvardan_reddy · Accepted solution]

Hi Nageswar,

You can achieve this using plain graphical functions itself, but it will be a length one.. ..

If you want to go for udf approach, then use the sample udf which I have written for three fields, for your case just adjust accordingly for 10 fields.

if( ((!(inp1[0].equals("NULL"))) && (!(inp1[0].equals("")))) || ((!(inp2[0].equals("NULL"))) && (!(inp2[0].equals("")))) || ((!(inp3[0].equals("NULL"))) && (!(inp3[0].equals("")))) )

     result.addValue("");

else

   result.addValue(ResultList.SUPPRESS);

Regards