Hi sap pi getting records from proxy has to send in a fixedfield length

[Former Member]

Hi ,

I have a requirement where data is coming from proxy to the pi system and has to map the source counter records fields to the target field counter record fields , these field is under the trailer node ..please find the sample record how i need to generate this in message mapping , can some one tell me

Ex:
Proxy source field name Total -> Target field name Count of Detail Records

sample data need to generate the record for this field   ex: 00400 

[giridhar_vegi · Accepted solution]

Hi kiran,

            Does it needs to be incrimented ? if that is the case please let me know.

Thanks

Giridhar

[Former Member · Accepted solution]

Yes that need to be incremented based on the total records

[Former Member · Accepted solution]

Hi Kiran,

After putting source value in one context use 'count' function to count total number of records. Then use 'format number' function to get the desired output.

Regards,

Soumyadip

[giridhar_vegi · Accepted solution]

Hi Kiran,

               do the mapping as follows

Total-->counter-->formatNumber-->Count of DetailRecords

Double click on the counter and specify the count increment value.

Thanks

Giridhar

[giridhar_vegi · Accepted solution]

Hi Kiran ,

          Please find the below mapping

Result

Result Output

Thanks

Giridhar

[Former Member · Accepted solution]

My doubt is for Proxy source field name Total -> Target field name Count of Detail Records

How can i map the counter to the source field Total to Count of records receiver field as counter has target side mapping option

[giridhar_vegi · Accepted solution]

Hi kiran,

          Please let me know whether you want to count the total no of records or record incrimentation

Thanks

Giridhar

[Former Member · Accepted solution]

Hi Kiran,

Total (one context above) -> count (under statistic function) -> formatNumber (under arithmetic function) -> Count of Detail Records

Regards,

Soumyadip

[giridhar_vegi · Accepted solution]

Hi kiran

          Please find the below mapping

Thanks

Giridhar

[Former Member · Accepted solution]

Ok fine , i will implement this logic and get back to you if any issues .. Thanks for your answers

[Former Member]

Hi reopening the issues , But how can i count the details records total under trailer records field

[former_member182412]

Hi Kiran,

SourceField(make it one context)->sum(under statistic)->targetField.

Regards,

Praveen.

[Former Member]

Hi Kiran,

You can use arithmatic function 'Format Number' and give the number format as '00000'(to make the value as 5 digit).

Regards,

Soumyadip

[Former Member]

Hi

Just the Pictorial view of Soumyadip's reply

Thanks,

Indrajit