cancel
Showing results for 
Search instead for 
Did you mean: 

FixValues Mapping

elko_hasse
Participant
0 Kudos

Hi all,

I use the FixValues Function in graphical mapping. I have one mapping ST to PCE, all other values should be passed through.

That mean if source is ST, it schould be mapped to PCE. If source is XX it schould be mapped to XX and so on. If the Source is not ST, the source should be mapped to target.

How can I do that. At the moment the target is empty if the source is not ST.

Tanks.

Elko

Accepted Solutions (1)

Accepted Solutions (1)

Shabarish_Nair
Active Contributor
0 Kudos

<i>That mean if source is ST, it schould be mapped to PCE. If source is XX it schould be mapped to XX and so on. If the Source is not ST, the source should be mapped to target.</i>

>>

if its only one value ST that u have to take care then dont use fix values.

Use a simple IF-ELSE design and use the logic if ST then PCE else the source.

use the IF else function to achieve this.

elko_hasse
Participant
0 Kudos

Ok, for one value this is easy. But is there a way to use FixValues function for this, in generall ?

Elko

Shabarish_Nair
Active Contributor
0 Kudos

well it would be better to not use fix value in such a scenario and rather go in for UDF to achieve the results.

elko_hasse
Participant
0 Kudos

So, I assume, that FixValue only works, if every value in source field needs to be mapped.

Regards,

Elko

Answers (0)