Parameters in the constraint

[DSGuru]

Thank you very much in advance for your help.

I'd like to use parameters in the constraint of a transformer. When I put in parameters DS doesn't like it and says "expected constraint". If I hard code then it accepts.

Hardcode example, compare(field1,"Bad", "L") = 0
Parameter example, compare(field1,#inputfield#, "L") = 0

Has anyone experienced the same thing, and how do we work around it?


Thanks again.

Leonardo

[nigel]

Hi,

I've never encountered that problem sofar.

You should reference the parameter in your constraint without the "#" prefix and suffix.

eg. Field(PARAM,",",1) instead of Field(#PARAM#,",",1) where PARAM is your parameter.

Hope this helps and that I've understood your problem

Regards

Nigel

Nigel