Filtering depending on field values in rows

[former_member209575]

Hi All,

I have ROW which is 0...unbounded containing 10 fields.

In my reuirement, one of the field, suppose field1 is starting with "A" then i have to delete complete row and go to next row.

Please help me in doing this.

Regards

Pradeep

[former_member191531 · Accepted solution]

Hi Pradeep,

you need the following UDF (ExecutionType: All Values of a Context) for the node ROW:

boolean flag = true;
for (int i = 0; i < var1.length; i++) {
    if (var1<i>.startsWith("A")) {
        flag = false;
     }
}
if (flag) {
    result.addValue("");
} else {
    result.addSuppress();
}

Then create the following mapping: Field --> UDF --> removeContext --> ROW

Regards,

Juergen

Edited by: Juergen Grallert on Sep 8, 2010 1:31 PM

[former_member209575 · Accepted solution]

Thank Juergen,

It worked...:)

regards

Pradeep P N

[Former Member]

Hi Pradeep,

Try with if with else,not equlas,and create if

it may slove your problem.

Smile...

Giriii

[Former Member]

Hi Pradeep,

What do you mean by deleting the whole row and go to the next?

Didn't understand your requirement.

-Supriya.