on 08-01-2006 9:43 PM
I want to map concatenated 1 header source field and 2 detail source fields into 1 target detail row field. Is it possible? I am getting message mapping error in SXMB_MONI. I changed the DT_Detail_Row.fieldFixedLengths, still getting error. Any suggestions or ideas how I can map these fields?
Thanks.
Rajan,
Are you using the standard CONCAT function?
There has been a known issue with the same.
Use it as folllows,
SORUCEFIELD1 -- MAPWITHDEFAULT --
CONCAT
SOURCEFIELD2 -- MAPWITHDEFAULT --
Regards,
Bhavesh
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Thanks to those who helped/replied. Closing this thread as no further replies.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hey,
y cant u use 2 Staandard concat functions
where u concat ur two source fields using one concat and concat that output with the header source field using another concat fucntion and map that output to target field.
detail1
Concat----
>
detail2 concat----->target
Header----
>
cheers
jithesh
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hey Rajan,
Please post an example of the source n target structures, this will help in figuring out how it can be done. If not graphical, you should be able to achieve it with the help of a udf.
Regards,
Sushumna
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
I'm not sure how to cut and paste graphical mapping but here is what I am trying to achieve:
Source - Header Row field + Detail Row Field1 + Detail Row Field2 -> Target - Detail Row Field.
If I do Source - Detail Row Field1 + Detail Row Field2 -> Target - Detail Row Field I don't get any errors but if Add Source Header Row Field, and concat, I get Message Mapping error in SXMB_MONI.
Thanks.
User | Count |
---|---|
87 | |
10 | |
10 | |
10 | |
7 | |
6 | |
6 | |
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.