Frequency of a record in a sequential file

chitrangadsingh · Post by **chitrangadsingh** » Mon Jul 18, 2005 4:38 am

Hi,

I have to read a sequential file with some fields and the output should contain the frequency of occurence of values in one of the fields.
For eg. lets assume file has 3 fields A,B and C.
the sample data is

A B C
e t g
e w p
r u g
s t p

Now the output file should have :
C Count
g 2
p 2
How this can be achieved in PX without any sql (since the input is a sequential file)

Thanx,
Chits

hexa · Post by **hexa** » Mon Jul 18, 2005 4:49 am

Welcome ABROAD

Use Aggregator Stage to achive.

refer doc for more information

hexa

elavenil · Post by **elavenil** » Mon Jul 18, 2005 5:01 am

As hexa mentioned, group the required column in AGGR and use the count function to achieve this.

Take care of Sort the input data and partitioning.

HTWH.

Regards
Saravanan

chitrangadsingh · Post by **chitrangadsingh** » Mon Jul 18, 2005 5:16 am

Hey thanx for the warm welcome and the soln.

Any idea regd any docs freely available on net for Datastage??

(i'm kinda on leave and thus dont have access to any docs)

ray.wurlod · Post by **ray.wurlod** » Mon Jul 18, 2005 2:42 pm

Currently there are no manuals available for download.

This may change now that IBM has acquired the products, as their model includes publishing manuals on a web site.

But not yet.