locked
Record Count Functoid in mapping RRS feed

  • Question

  • I need to count the total number of lines in the output file.I am using the record count functoid in the map like


    The issue is I am mapping the elements in the Benefit record (output) only the EmployeeID in RecordMemeber (input) is equal to the EmployeeID in RecordBenefit (input). If the input

    RecordMemeber                                                           RecordBenefit

    12,MEMBER,007609952,007609952,12,05                        12,BENEFIT,MEA,001,0100189
    14,MEMBER,004482352,004482352,14,05                        12,BENEFIT,DEN,002,0100189
                                                                                      14,BENEFIT,DEN,002,0100189
                                                                                      14,BENEFIT,MEA,001,0100189
    Output will be

    12,MEMBER,007609952,007609952,12,05
    12,BENEFIT,MEA,001,0100189
    12,BENEFIT,DEN,002,0100189
    14,MEMBER,004482352,004482352,14,05
    14,BENEFIT,DEN,002,0100189
    14,BENEFIT,MEA,001,0100189
    TRAILER,7

    But if the

    RecordMemeber                                                           RecordBenefit

    12,MEMBER,007609952,007609952,12,05                        12,BENEFIT,MEA,001,0100189
    14,MEMBER,004482352,004482352,14,05                        12,BENEFIT,DEN,002,0100189
                                                                                        14,BENEFIT,DEN,002,0100189
                                                                                        14,BENEFIT,MEA,001,0100189
                                                                                         1,BENEFIT,DEN,002,0100189
                                                                                         2,BENEFIT,DEN,002,0100189

     No.of output lines will be the same but the count is changing to 9. As it is counting the no.of records in the RecordBenefit and RecordMember.

    Output will be

    12,MEMBER,007609952,007609952,12,05
    12,BENEFIT,MEA,001,0100189
    12,BENEFIT,DEN,002,0100189
    14,MEMBER,004482352,004482352,14,05
    14,BENEFIT,DEN,002,0100189
    14,BENEFIT,MEA,001,0100189
    TRAILER,9

    I understand that the RecordCount functoid is functioning correctly but I am not sure how will count the no.of records that are in the output. Is there a way without creating any custom send pipeline component to get the count and do something in the map. Any help is greatly appreciated.                                                                 


    • Edited by vdha Thursday, January 19, 2017 10:11 PM
    Thursday, January 19, 2017 10:04 PM

Answers

All replies