on 04-27-2011 8:25 AM
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 ?
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
hi,
field Id + u2018,u2019 +
3rd Char of field Id + u2019,u2019+
Value Identifier.
You can use this mapping:
fieldID -
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)
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
User | Count |
---|---|
83 | |
24 | |
12 | |
9 | |
7 | |
6 | |
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.