on 06-16-2008 10:24 AM
HI experts
I have to create target file based on source field.
the source field should not be mapped to the target field.
Condition: If source field exsist create target file else error.
Any one has any idea???
Dear Mahesh,
In mapping editor, do like this:
use If then else
compare sourse field with the constant (XYZ, use constant function for this in the same mapping area.)
Right click and assign it as xyz and compare two strings if source and constant are equal then map else reject.
Hope this will help you.
Best of Luck
Regards
Praveen
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi,
Use if then else or EXIST funtion to find out the source field exists or not.
Regards,
Phani
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
hi mahesh,
make use of standard function EXISTS
We can handle the error by checking whether the source tag exists and if it does not we can pass an empty value, which generates the required target field.
regards
chandra
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi,
you could map the source to the exist-function and the result in if without else
if true then -> source value
Regards
Patrick
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
use standard function Boolean Function - IF (with Else) for this problem,
regards,
Sandeep Kaushik
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
84 | |
23 | |
11 | |
9 | |
8 | |
5 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.