DSXchange

hi all

the logic is like this

BALLOON_INDICATOR = 'Y' if PRODUCT_TYPE like '%alloon%'

I have translated it to the below in the Transformer it does not seem to work

If tpo_loan_orig_out.PRODUCT_DESCRIPTION Matches "%alloo%" Then "Y" Else "N"

i also tried

If tpo_loan_orig_out.PRODUCT_DESCRIPTION Matches "alloo" Then "Y" Else "N"

how do i do this logic


basically i need an equivalent to the LIKE operator in ORacle

thanks

rxs0005

Why don't you try:

if Index (tpo_loan_orig_out.PRODUCT_DESCRIPTION , 'alloo', 1) > 0 then 'Y' else 'N'

Rob Wierdsma

Here, try this. It works for me. I bet it will work for you

If trim(tpo_loan_orig_out.PRODUCT_DESCRIPTION) Matches "...alloo..." Then "Y" Else "N"

DataStage server job expressions do not use SQL wildcards. DataStage server job expressions have a more flexible set of pattern matching capabilities which you can read about in on line Help (topic Pattern Matching Operators) or in the DataStage BASIC manual.

DSguru2B

that worked !!

thanks!!

rxs0005