Like operation

Post questions here relative to DataStage Server Edition for such areas as Server job design, DS Basic, Routines, Job Sequences, etc.

Moderators: chulett, rschirm, roy

Post Reply
arnie_nits
Participant
Posts: 101
Joined: Mon Aug 13, 2007 2:32 am

Like operation

Post by arnie_nits »

Hi

I have a requirement where if the description is "abc /1 ml" or "abc/ml" or "abc/1ml @ 10 min" then I need to multiply the other column i.e the value to 100.

Please suggets. Is it possible in transformer??

Regards,
Arnie.
Top
anbu
Premium Member
Premium Member
Posts: 596
Joined: Sat Feb 18, 2006 2:25 am
Location: india

Post by anbu »

Check Index()
You are the creator of your destiny - Swami Vivekananda
Top
ray.wurlod
Participant
Posts: 54607
Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:
Contact ray.wurlod

Post by ray.wurlod »

From your description (exact text for description) I'd suggest a simple If..Then..Else construct would suffice.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Top
Post Reply

Return to “IBM<sup>®</sup> Infosphere DataStage Server Edition”