if else logic

[deesh]

Hi Friends

I have one if else logic, can share with me how to implement below condition in data stage.


if 1st character of okcucl = 5 then 020
else two first character of okcucl = 65 then 030 else 001

[jhmckeever]

Assuming you mean in a parallel transformer:

Code: Select all

If Left(InLink.okcucl,1) = '5'  Then '020'
Else If Left(InLink.okcucl, 2) = '65' Then '030'
Else '001' 

[deesh]

Assuming you mean in a parallel transformer:

Code: Select all

If Left(InLink.okcucl,1) = '5'  Then '020'
Else If Left(InLink.okcucl, 2) = '65' Then '030'
Else '001' 

Hi,
When I tried this logic, not given sufficient result It's giving wrong

I need below kind of data, Please send proper logic

5612 ------020612
6589 --------03089

[ray.wurlod]

John's response was a COMPLETE ANSWER to your question, which only sought a three-character string.

if 1st character of okcucl = 5 then 020
else two first character of okcucl = 65 then 030 else 001

You have now changed the question.

We at DSXchange are not in the business of supplying a complete solution (though a number of people here are in that business, but only for money).

How about you give some thought to how YOU might go about it (apart from requesting/demanding that someone else solves your problems)?

[shalini11]

Try this

If Trim(DSLink1.okcucl[1,1])='5' Then '020':Trim(DSLink1.okcucl[2,len(DSLink1.okcucl)])
Else If Trim(DSLink1.okcucl[1,2])='65' Then '030':Trim(DSLink1.okcucl[3,len(DSLink1.okcucl)])
Else '001'

[Kryt0n]

Hi,
When I tried this logic, not given sufficient result It's giving wrong

I need below kind of data, Please send proper logic

5612 ------020612
6589 --------03089

Unbelievable!

[datastage_learner]

Try this

If Trim(DSLink1.okcucl[1,1])='5' Then '020':Trim(DSLink1.okcucl[2,len(DSLink1.okcucl)])
Else If Trim(DSLink1.okcucl[1,2])='65' Then '030':Trim(DSLink1.okcucl[3,len(DSLink1.okcucl)])
Else '001'

mate...perfect answer!