on 2010 Nov 19 8:50 AM
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
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
66 | |
10 | |
10 | |
10 | |
10 | |
8 | |
6 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.