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

gouse

• May 26th, 2016

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

ahamed

• Mar 21st, 2016

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

Answer Question  Select Best Answer