Post a reply

Write your message and submit

Options

Click in the dark area of the image to send your post.

Go back

Topic review (newest first)

Volker Brehm
2008-04-09 21:29:00

You can use a tJavaRow and add the java code or use the ?:-Operator in a tMap (code not tested):

Code:

rowX.FIELD1 == null ? (rowX.FIELD2 == null ? rowX.FIELD3 : rowX.FIELD2) : rowX.FIELD1

Bye
Volker

johnvkumar
2008-04-09 21:16:53

Hi, I am not able figure out how to do the following

IF FIELD1 is NULL THEN
   IF FIELD2 is NULL THEN
         IF FIELD3 is NULL THEN
              PUT  NULL into OUT1
         ELSE
                PUT  FIELD3 into OUT1
         END
   ELSE
     PUT  FIELD2 into OUT1
   END
ELSE
  put FIELD1 into OUT1
END

thx and appreciate your help.

Board footer

Powered by FluxBB