on 03-05-2010 10:15 AM
Hi,
I am working on EDI 850 data to flat file conversion scenario.
Here i am getting struck in this case.
If data present in input field then I need to map that field to output field
else i need to map output field as a space.
How would I map.
Thanks,
Singh.
Hi,
if mapwithDefault does not work..then try with the exists function...
as if element exists then map to target else map constant(with blank values ) to target...
HTH
Rajesh
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi,
thanks for ur reply.
Suppose In input side i have record rec which has 4 fields.
field 1 ha length 2 value ab
field 2 has length 60 but no value in input file
field3 has length 2 value CD
field 4 has length 10 has value 123456789
FOr this in Receiver CC How would i give in FCC.
RECORD.field FixedLength values-------> 2,2, 10
or
2,6,2,10
here 2 nd field has mapped like space as constant.
Plzz help me on this issue
Thanks,
Singh.
Edited by: vcpsingh on Mar 5, 2010 4:18 PM
Edited by: vcpsingh on Mar 5, 2010 4:24 PM
Hi,
mapWithDefault is correct. This is the documentaion of this function:
Replaces empty contexts in the inbound queue with a default value, which you specify in the function properties.
Example:
If u201CDefaultu201D is the default value and
A|B1,B2| |C| |D
is the inbound queue,
mapWithDefault returns the following outbound queue:
A | B1,B2 | Default | C | Default |D.
The function corresponds to the following combination of standard functions:
If(
[]field,
exists([]field),
Constant([value=default]))
you could find the documentation of the standard functions here:
http://help.sap.com/saphelp_nw04/helpdata/en/43/c4cdfc334824478090739c04c4a249/frameset.htm
Regards
Patrick
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi,
Use std fun called "MapWithDefault" in between your source and target. Double click on MapWithDefault and just give one space.
Regards,
Sarvesh
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
87 | |
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.