DSXchange

Posted: **Sun Feb 14, 2016 11:01 am**

That just needs to be one if-then-else, specifically the last one.

Posted: **Sun Feb 14, 2016 8:36 pm**

IF isnotNull(FROM_ACCT_NUM)
   then right(FROM_ACCT_NUM,2)
    else if 
          isnotNull(FROM_ACCT_NUM)
          then right(FROM_ACCT_NUM,2):'XXXXX' 
   else if 
          isnotNull(FROM_ACCT_NUM)
          then left((right(FROM_ACCT_NUM,2):'XXXXX'):FROM_ACCT_NUM,12)    ELSE
 FROM_ACCT_NUM

Posted: **Sun Feb 14, 2016 9:08 pm**

Most of your ELSE expressions won't be evaluated because they include the same IF test as was processed in the THEN clause.

All you need is:

Code: Select all

If IsNotNull(InLink.ACCT_NUM) Then Left(InLink.ACCT_NUM,2) : "XXXXX" : Right(InLink.ACCT_NUM,12) Else InLink.ACCT_NUM

Posted: **Sun Feb 14, 2016 11:34 pm**

In other words... the last one.

Posted: **Mon Feb 15, 2016 4:13 pm**

... except that the syntax given by naveenkumar.ssn (even in the last one) will not create the required result.

Posted: **Mon Feb 15, 2016 4:57 pm**

... was going to let them realize and attempt to correct that. Was also going to go back and edit my answer to say 'a variation of the last one' but decided to just let it stand.

Posted: **Wed Feb 17, 2016 2:49 am**

Hi Hargun,

Please use below logic to get the desired output.

If IsNotNull(FROM_ACCT_NUM) Then Left(FROM_ACCT_NUM,2):'XXXXX':Right(FROM_ACCT_NUM,12) Else FROM_ACCT_NUM

Posted: **Wed Feb 17, 2016 7:31 am**

Ray has already given that answer above...

Posted: **Wed Feb 17, 2016 10:46 am**

Seems to be a bit of a serial repeater.

DSXchange

Logic required for If / then / else in tranformer

Re: Logic required for IF and else in tranformer