on 05-14-2007 2:21 PM
Hi all,
I am working with Idoc to file scenario(FCC).
I need to map one of the field with a recound count ie.., count of the total lines of the file (including the file header).
Eg:Record Count-- mapping area:Total number of records in the file including file header The total line of the file (including the file header).
Can i get a help on this.
Thanks and Regards,
Manoj
Hi !
If there is a tag of your IDOC that occurs the same quantity of times as file lines you have to create in your target file, you could make a Java user defined function in graphical mapping that "caches the entire queue" (use the corresponding option button), that receives as input that field of the IDOC, and returns the "lenght" (.length property value) of that input parameter (it is an array) as output..that should be the file line quantity..you may also add 1 to that count, for the header.
Hope it helps.
Regards,
Matias.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hello,
Use counter in the mapping and map the source node to target element Counter.
For every iteration of the node Counter is incremented.
When mapping is done you will get the last value populated in the element and thats the count.
Regards,
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
78 | |
10 | |
7 | |
6 | |
6 | |
6 | |
6 | |
6 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.