Ab Initio - Counting Records

Using ROLLUP in Ab Initio, need to count the number of sites for each account e.g.
Input file:
SiteId, AcctId, Address
675765, 1, Smit Street
768768, 2, Orange Road
767876, 1, New Road
989898, 1, Jones Street
878787, 3, Ele Lodge
118768, 2, Red Street
Output:
AcctId, NoOfSites
1, 3
2, 2
3, 1

Questions by Bubbi

Showing Answers 1 - 6 of 6 Answers

ahamed

  • Mar 21st, 2016
 

Input file-->rollup{acctId}(input need not be sorted, out.acctid::in.acctid, out.count::count(in.siteId))-->Output file

  Was this answer useful?  Yes

gouse

  • May 26th, 2016
 

Rollup component key-acctid, no-of sites per accountid-count(acctid)

  Was this answer useful?  Yes

Give your answer:

If you think the above answer is not correct, Please select a reason and add your answer below.

 

Related Answered Questions

 

Related Open Questions