Count number records from input file

[dstx_1]

Hello everyone,
I need help to count number of records from my source file and write it to the output.. The format of my source file is as follow:

I have multiple record types in my file. RecordTypes 2,3 & 4 are under a Loop . For instance

RecordType1 (1:1)
Loop(1:9999)
RecordType2 (1:1)
RecordType3 (1:1)
RecordType4 (1:9999)

I need to be able to get a count all the recordType3 + recordType4. I have tried using Count function but haven't been able to get the desired results. Not sure how I can get a total count of RecordType4 that occurs multiple times in the Loop.

Thanks for all your help in advance...



Thanks

[janhess]

How did you specify your COUNT rule? It looks as though a simple COUNT would work but it needs to be done against the file object ie file input card.

[kumar_s]

Have you solved your own query? If so, do mind sharing it for the further searchers.

[dstx_1]

I was able to use the count function as follow:

SUM(COUNT(RecordType3 Loop:File) + COUNT(RecordType4:Loop:File))

and I was able to get the desired results..


Thanks!

[kumar_s]

Thanks for sharing this.