Case statement in transformer

[deesh]

Hi,

Please explain the situation resolvation

Now i am getting data -1,-12,-13,-1,-1

data started with 1 should be flip sign, if getting '-' should be '+' or '+' should be'-'. except data start with 12, remaining start with 1 should be change.

i have to get the data like +1,-12,+13,+1,+1

How to do in transformer, please provide me the guidance

[deesh]

Hi i experimented will do with below logic even fine.

( Left(column,1) ='1' and Left(column,2) <>'12')

but looking any other way we can filter.

[ray.wurlod]

Seems like a straightforward If..Then..Else expression to me, encapsulating pretty much the logic you already have. Is "-" always present?

[rkashyap]

If incoming datatype is numeric then ... Abs function may also work.

[ray.wurlod]

Still need an If..Then..Else to isolate the -12 case.

[vinothkumar]

How about multiplying the number with -1 to flip the sign wherever required.

[priyadarshikunal]

why you are putting a filter condition when you want to just flip the sign?

Code: Select all

if (column = '-12') then column else (if (left(convert('+-','',column),1) = '1') then column * -1 else column)

if (left(convert('+- ','',column),1) = '1' and (left(convert('+- ','',column),2) <> '12') then column * -1 else column

if (left(abs(column),1) = '1' and (left(abs(column),2) <> '12') then column * -1 else column