Skip to Content
Former Member
Aug 10, 2011 at 06:30 AM

Masterdata derivations repeats outcome of previous derivation when no MD


When I use in a transformation masterdata derivation outcome values are repeated from the previous line when the key is not in the masterdata table I want to derive from. For example 0CS_ORDER = 25 has 0funct_loc = 27.

When in the first line CS_order 25 is used I receive for 0funct_loc the value 27.

When in te second line CS_order is A which does not exist I receive for 0funct_loc also the value 27,I expected ''.

I keep receiving for the next line 27 for 0funct_loc untill the moment a line has a valid 0cs_order.

I expected that when their is no masterdata the masterdata derivation returns no values.

How to solve this not expected behaviour?