How to find sum of record in file

[Former Member]

HI all,

I am doing idoc to file scenario file has three structre Header,Data ,Footer

in footer one field is number where i have to put sum off all records in the file can we achieve this using standard function count or i have to go for any other approch

Plz share ur view on this issue.

Regards

Neha

[Former Member · Accepted solution]

Hi,

You can do this by using standard function only.I think there is a function called count.map this with the node in IDoc with the filed of your message of receiving file.

You can test this also by duplicating the node element.

Regards,

Ramesh P

[Former Member · Accepted solution]

Hi ramesh

I found count function in xi standard list but unable to find count.map function and if iam using count after my source node am getting only one record as target.

Regards

Neha

[prabhu_s2 · Accepted solution]

set the context of the field to the immediate parent or as per ur req and test.

[Former Member · Accepted solution]

Hi neha,

count function will do the trick for you.

I want to know how you are testing.

If you are using Test tab in message mapping, then use duplicate subtree option and then test it.

Regards,

Ramesh P

[prabhu_s2]

make use of COUNT node function.

source ->COUNT-> target