Mapping doubt

[Former Member]

I want to have a value like this. Target field is X

X will be 0, if  A is blank at source

X will be 0, if B is blank at source

X will be 0, if C is blank at source

X will be 1, if D has any value at source. (is, not blank)

A, B, C and D are values at source

X is the field at target which I need to populate

Please help

[Former Member · Accepted solution]

Hi Midhun

This is the graphical view of the mapping which needs to be done

[Former Member]

Hi,

As Sudha said there are so many cases like that .so briefly describe your requirement.

BR,

Anirban

[former_member680603]

Hi Midhun,

Am little bit confused with your requirement.

We have 4 values at sources and we need to get only one value at target 'X'.

can you tell me out put for below set of values to understand your requiremnet

Case 1:

A-not blank

B-blank

C-blank

D- not blank

X-??

Case 2:

A- Blank

B-Blank

C-Blank

D-Blank

X-??

Case 3

A-Blank

B-Blank

C-Blank

D-Not Blank

X-??

Regards,

Sudha

[Harish]

Hi Midhun,

Please map the field like below

D--> Map with defauld (blank) --> Equals Blank (constant) --> Not (Boolean)

--> If

Then Map constant 1

Else

If without else

A--> Map with Default blank --> Equal (blank)

     OR

B--> Map with Default blank --> Equal (blank)

          OR

C--> Map with Default blank --> Equal (blank)

then map 0 to else part

and map the if to X.

Hope it is clear.

Regards,

Harish