|
PDFs keep only a single value (selected at random) per ID value, regardless of the number of times an ID value occurs in the data. Thus, when the output includes no table fields (and includes an IBM® ID), there will be only one record per ID value.
|
Highest_purchase_amount = groupby(CID, maxof, Purch_Amt)
ModelX_score = groupby(CID, maxof, if(Model = 'X', 1, 0), Score)
Bad_ModelX_score = if(Model = 'X', Score, NULL)
Copyright IBM Corporation 2015. All Rights Reserved.
|