Nice, how would you go about to do an exclusive left outer join in the recipe? As you mentioned that this could be done at data preparation level? In the recepies aI only have the option of a "left join"?
q = load "account"; q1 = load "OppOwnerAccnt_Final"; final = group q by 'Name' left, q1 by 'AccountId.Name'; final = foreach final generate q.'Name' as 'Name', q1.'AccountId.Name' as 'OppAccntName', count('q') as 'count'; final = filter final by 'OppAccntName' is null; realfinal = foreach final generate 'Name' as 'Name', count('final') as 'count';
Nice, how would you go about to do an exclusive left outer join in the recipe? As you mentioned that this could be done at data preparation level? In the recepies aI only have the option of a "left join"?
From where i can get all the files which are used in this entire Playlist
Hi, there. I follow this exercise very precise, but for some reason Bar (y - axis) not displaying in chart mode. What've I done wrong?
q = load "account";
q1 = load "OppOwnerAccnt_Final";
final = group q by 'Name' left, q1 by 'AccountId.Name';
final = foreach final generate q.'Name' as 'Name', q1.'AccountId.Name' as 'OppAccntName', count('q') as 'count';
final = filter final by 'OppAccntName' is null;
realfinal = foreach final generate 'Name' as 'Name', count('final') as 'count';