-
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