Mapping field

[Former Member]

Hi

I have three fields in source, A, B and C. One will have a value and other two would be blank. The one that has a value should be mapped to the target field X. I used exist and two if then else conditions and its giving me this error. I get an error cant cast to float. Please suggest me a way to do this without using UDF

Regards

[Former Member · Accepted solution]

u2018Existsu2019 checks the existence of the field/node. Even if the node is there in the xml without a value, the result would be true. Instead you can check if the field is blank (Field != u2018u2019).

First check for the first field to be blank, and if yes, check the second field. If this also is blank, check the third field and pass on the value to the target field.

[Former Member · Accepted solution]

Hi

How do we check if the field is blank ?

I didnt get that function

Regards

[former_member200962 · Accepted solution]

Field -->
        --> equalS --> Not --> IfWithoutElse (Field --> Then) --> Target
Constant() -->

Above logic will check if Field is not blank.....if not then Field will be mapped to target field.....keep the constant blank...no value not even space.

Regards,

Abhishek.

[Former Member · Accepted solution]

Thanks a lot Abhishek

It worked perfectly

Regards

Midhun