How to use CASE Function in SAPDS Query Field Mapping

[dunncrew]

I am using SAPDS Data Services Designer, moving data from 1 table to another. I want to use the CASE statement for a particular field, so that if the incoming field MATCH is 1, convert to 'TRUE' in the target field, else 'FALSE'.

In the field MAPPING box, I entered

CASE WHEN MATSCANRECORDS.MATCH = 1 then 'TRUE' else 'FALSE' END

(I have tried a few variations also)

But a Red X displays. Is my syntax wrong ? Or is CASE not supported ?

How can I achieve my result ?

[dunncrew]

I think I found my answer. DECODE

DECODE((MATCH = 1), 'TRUE', 'FALSE')

[Julian_Riegel]

Hi there,

correct - decode() or ifthenelse() functionality should serve you well!

BR