I have the following step built by co-grouping 2 datasets on their SIC codes so that the display shows the sum of Amount for each SIC Code Description. This works as I need it to.
q1 = load "Opportunity"; q2 = load "Industry_Mapping_Dataset"; q2 = group q2 by ('SIC_Code', 'Sub_industry', 'Sic_Code_Description'); q3 = cogroup q1 by 'SIC_CD', q2 by 'SIC_Code'; q3 = foreach q3 generate q2.'Sub_industry' as 'Sub_industry', q2.'Sic_Code_Description' as 'Sic_Code_Description', sum(q1.'Amount') as 'sum_Amount'; q3 = order q3 by ('Sub_industry' asc, 'sum_Amount' desc);
The problem I'm having is, the following selection bindings I have pulling data from this step comes out blank every time.
I was wondering, are you able to do a selection binding on a co-grouped step? Thanks for your help.