There are several key differences between dataflows and recipes and I will be going over a few of them.
#1) slight variation in case statements:
case when Grade_High__c == “13th ” then 13 when Grade_High__c == “14th ” then 14 else 0 end
case when Grade_High__c = ‘13th’ then 13 when Grade_High__c = ‘14th’ then 14 else 0 end
#2) Creating outer/inner joins more straightforward in recipes using selection buttons.
Be careful to distinguish between ‘lookups’ and left joins. (hint: lookups return the first instance of matching rows while left outer returns all..
#3) Data preview INSIDE the recipe reduces the need to create intermediate datasets to verify contents of dataset as it goes thru the different transformations.