Page 1 of 1
How to get 10% records out of Aggregator Stage.
Posted: Tue Jun 20, 2017 11:59 am
by pradeep5
I have a file with 100 records and out of those records I need to get 10% of records in file 1 and 90% of records in file 2. Please advise me on how to achieve this.
Posted: Tue Jun 20, 2017 1:16 pm
by chulett
If it doesn't matter which records go where, I'd look into the MOD function based on the record number... which you can generate if needed. Mod by 10 and assign any one of the remainder values to the 10% link and the other nine to the 90% link.
Posted: Thu Jun 22, 2017 9:36 am
by pradeep5
Thanks Craig for the info.