Question
Stratosphere Technical Consulting
US
Last activity: 2 Nov 2016 23:15 EDT
Group By and Proposition Properties
I use a group by component with Interaction History to get a count of a specific outcome by propositon, grouping by pyname. while the count gets computed correctly , values are not populated for properties such as pyName. How do I access the value for pyName after the group by? It is blank along with other properties after the aggregating.
Accepted Solution
Stratosphere Technical Consulting
US
Update: Ok found this documentation:
In the online DME course they just do a count and then they no longer need properties so they just put none. Since they are grouped, there can be multiple values for each group, since it is aggregate of multiple records
Properties that are not mapped in the component are automatically copied. In the For remaining properties setting, define how to handle the remaining properties by selecting one of the options from the drop-down. When using the options that copy with the highest/lowest value, specify which property in the SR class corresponding to the level of the strategy in the proposition hierarchy provides the value.
- First: copy with first value.
- None: empty.
- With highest: copy with highest value.
- With lowest: copy with lowest value.
Pegasystems Inc.
NL
Hello Bellerophon,
If you group by .pyName, then .pyName should be part of the results. In addition the results contain the property that you map the aggregations to as well as any of the other properties (depending on how you chose to get them from the groups, e.g. the first one).
Which version are you on? And does your strategy look like this, with an explicit IH import?
Thanks
Otto
Stratosphere Technical Consulting
US
I have join and some filters between IH and Group By , I join on proposition data because I need some properties to filter on prior to the group by.
if I select First "for remaining properties" I have pyName however , if I select None , pyName is not there. Can you clarify what this means?
Version 7.1.9
Accepted Solution
Stratosphere Technical Consulting
US
Update: Ok found this documentation:
In the online DME course they just do a count and then they no longer need properties so they just put none. Since they are grouped, there can be multiple values for each group, since it is aggregate of multiple records
Properties that are not mapped in the component are automatically copied. In the For remaining properties setting, define how to handle the remaining properties by selecting one of the options from the drop-down. When using the options that copy with the highest/lowest value, specify which property in the SR class corresponding to the level of the strategy in the proposition hierarchy provides the value.
- First: copy with first value.
- None: empty.
- With highest: copy with highest value.
- With lowest: copy with lowest value.