another expression im stuck with

[rjhe22]

if RTG_SP = AA+ and RTG_MOODY = Aa3
the load code is AAP

how do i wirte this does anyone know

 

[notadba]

Hi, Assume this one is also using the derived column stage. There is a pick list of the expressions when you build the derived column which should serve as a start point - but they are sometimes a little confusing.

Your example does not provide an opt out clause where RTG_SP and RTG_MOODY do not equal the values....so have added a no match at the end

Without testing, the syntax would be something like:
RTG_SP == "AA+" && RTG_MOODY == "Aa3" ? "AAP" : "No Match"

If you are just looking to load a AAP value, then the derived column just needs to be the expression "AAP"