Hi Viewers, :D
Please give me a thought on this requirement
I have one input dataset, from that I have to create one sequential file report which will contains 30 aggregate count columns, There are 4 key columns and 30 additional columns in source file, I have to calculate non missing values on every column based on group of this 4 key columns. Non missing in the sense which are not null. So for 30 columns I am using 30 aggregators, Is there any way to achieve this with out using this many aggregators
Too Many Aggregators
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 62
- Joined: Sat Mar 07, 2009 4:59 am
- Location: Chicago
- Contact:
Too Many Aggregators
Suresh Reddy
ETL Developer
Research Operations
"its important to know in which direction we are moving rather than where we are"
ETL Developer
Research Operations
"its important to know in which direction we are moving rather than where we are"
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
-
- Participant
- Posts: 62
- Joined: Sat Mar 07, 2009 4:59 am
- Location: Chicago
- Contact:
The function need to perform in aggregator is Non Missing Columns, It is not allowing for multiple columns, even though grouping columns are same but non missing column is calculated on each column, Could any one help..?
Suresh Reddy
ETL Developer
Research Operations
"its important to know in which direction we are moving rather than where we are"
ETL Developer
Research Operations
"its important to know in which direction we are moving rather than where we are"
You can certainly do what you want in a single aggregator.
For each column you want to calculate an aggregation on, add the "Column for Calculation" option. Then under that option, specify the type of aggregation and the output column it will be placed in.
For example:
Column for Calculation = A
Non-missing Values Count Output Column = CountA
Column for Calculation = B
Non-missing Values Count Output Column = CountB
You can't specify the Non-missing Values Count aggregation multiple times under a single "Column for Calculation". I suspect this is what you were trying to do.
Regards,
For each column you want to calculate an aggregation on, add the "Column for Calculation" option. Then under that option, specify the type of aggregation and the output column it will be placed in.
For example:
Column for Calculation = A
Non-missing Values Count Output Column = CountA
Column for Calculation = B
Non-missing Values Count Output Column = CountB
You can't specify the Non-missing Values Count aggregation multiple times under a single "Column for Calculation". I suspect this is what you were trying to do.
Regards,
- james wiles
All generalizations are false, including this one - Mark Twain.
All generalizations are false, including this one - Mark Twain.
-
- Participant
- Posts: 62
- Joined: Sat Mar 07, 2009 4:59 am
- Location: Chicago
- Contact: