Meliorainsights.com
  • Home
  • Tableau CRM
  • Blog
  • Non-Profits
  • Our Clients
  • About
  • Trading Studio

​Meliora Insights, LLC

​Data Cloud | CRM Analytics  (TCRM / Einstein Analytics) Consulting
​meliora - 'for the pursuit of the better'


A blog series distilling quantitative concepts /use-cases in CRM Analytics  (Einstein Analytics).

Picture

Salesforce CRM Recipes vs. Dataflow -- by Dan Alindogan, April 25,2022

4/25/2022

0 Comments

 
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:

Dataflows:
case when  
Grade_High__c ==  “13th ”  then 13 when  Grade_High__c ==  “14th ”  then 14 else 0 end
Recipes:

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.
​
Picture
Picture
Picture
0 Comments

    Archives

    June 2025
    April 2025
    January 2025
    November 2024
    August 2024
    April 2024
    March 2024
    February 2024
    January 2024
    December 2023
    June 2023
    May 2023
    April 2023
    March 2023
    February 2023
    December 2022
    October 2022
    September 2022
    July 2022
    April 2022
    March 2022
    January 2022
    November 2021
    June 2021
    April 2021
    March 2021

Site powered by Weebly. Managed by Hostwinds
  • Home
  • Tableau CRM
  • Blog
  • Non-Profits
  • Our Clients
  • About
  • Trading Studio