on 01-24-2012 9:17 AM
Hi all,
I have a requirement to count the number of mapped fields and put the result in the last element of the target structure, ie if a map (from the source structure) 35 fields, the last element on the target strucure is Counter = 36 (35 + the counter element).
Can this be achieved in graphical mapping? How do I do it?
kind regards,
Glenn
if a map (from the source structure) 35 fields, the last element on the target strucure is Counter = 36 (35 + the counter element).
as per my understanding, u ll try below logic
source filed1 + count-> s.f2 + count + add->target field (like ans 2)
s.f3 + count + add
s.f4 + count + add
..
.
.
.
.
..
s.f35 + count + add -> target
if above mapping is satisfied for ur requirement :
check second point in below link:
http://sapxitutorials.blogspot.com/2009/04/count-of-records-count-on-easiest-way.html
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
HI,
if your business rules are easy (all source info to target), you can use the graphic function "COUNT" (under statistic).
even if this one is mainly to count the occurence of a source field.
Mickael
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi,
You can define a variable and add 1 to its value each time you map some field, then map the value of this variable to your last field. This will require quite a lot of manual work, but I don't know any simpler way to do this using graphical mapping.
Hope you'll find this useful,
Greg
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
82 | |
10 | |
10 | |
9 | |
6 | |
6 | |
5 | |
5 | |
4 | |
3 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.