cancel
Showing results for 
Search instead for 
Did you mean: 

message mapping

Former Member
0 Kudos

hi, i have a situation in mapping where..

the sourec field is : field id

the target field is : timeseries

mapping logic is:

field Id + u2018,u2019 +

3rd Char of field Id + u2019,u2019+

Value Identifier.

how to map ?

Accepted Solutions (0)

Answers (2)

Answers (2)

baskar_gopalakrishnan2
Active Contributor
0 Kudos

Source field is field id Target field is timeseries



           field id         ----->1
                                           concat-------------->3
          constant [,]  ------->2                                   concat-----------> 5
                                                                                concat ---------------->7
                                                                                concat ->  timeseries   9
           field id     -----> substring(2,3)------> 4       constant[,]--> 6         value identifier--->8

1 & 2 inputs to concat o/p 3

3 and 4 inputs to concat o/p 5

5 and 6 inputs to concat o/p 7

7 and 8 inputs to concat o/p 9

map 9 to timeseries

Note: substing (2.3) start position 2 char count 1

Edited by: Baskar Gopal on Apr 27, 2011 10:17 AM

markangelo_dihiansan
Active Contributor
0 Kudos

Hello,

field Id + u2018,u2019 +

3rd Char of field Id + u2019,u2019+

Value Identifier.

You can use this mapping:


fieldID ----------------> concat: , -> concat: , -> timeseries
fieldID -> substring(2,3) -> / ValueID ->/

Hope this helps,

Mark

Edited by: Mark Dihiansan on Apr 27, 2011 9:55 AM

Former Member
0 Kudos

hi,

field Id + u2018,u2019 +

3rd Char of field Id + u2019,u2019+

Value Identifier.

You can use this mapping:

fieldID -


> concat: , -> concat: , -> timeseries

fieldID -> substring(2,3) -> / ValueID ->/

as you said i mapped field id to concat .....and concat to timeseries,

then i mapped filedid to substring (startposition-0 and character count 2 , as we need 3rd char of field id correct me if i am wrong) but i got a doubt here i dont have value identifier in source how to map it? to timeseries(targetfield)

manikandan_shanmugam3
Active Participant
0 Kudos
then i mapped filedid to substring (startposition-0 and character count 2  

as you need only third character you should use starting position as 2 and ending position as 3. if you use 0-2 then result will be the first two character

  but i got a doubt here i dont have value identifier in source how to map it? 

you mean to say you don't have the field? if yes then create it if needed.. then double click it and map to the second input of the second concat function

Regards,

Manikandan