Skip to main content

Einstein Analytics Data Preparation Specialist Superbadge - 4,5,6

My little brother is practicing his walking... If I am going to get the Einstein Analytics superbadge completed before he starts trying to play tag, I had better hurry!  Challenge 4 is not difficult if you follow the instructions precisely! Start by uploading the dataset then create the dataflow.  If you encounter this error....

You are, perhaps, taking the instructions too literally and need to tweak the formula.

Step 5 - A quiz.  You're on your own!

Step 6 - The monitor function was crucial in diagnosing dataflow issues!  If you get stuck, this thread on the developer community is a lifesaver: https://developer.salesforce.com/forums/?id=9060G0000005d3yQAA

Example issues:


In case you get stuck, here is a layout of the nodes.... The trickiest part is the formulas for Definie Temp Range and Add TempClass.  Hint - The TempClass formula is different for each of the dataflows.

Load Seed Bank w/ Temperature Classification

Load Seed Bank Agencies w/Climate Data

Comments

  1. smithaApril 7, 2019 at 10:53 AM

    Hi
    I am completely new this superbadges. I have done ADMIN & PD1. Can you suggest which super badge i should start with?

    ReplyDelete
    Replies
    1. Trailhead BabyApril 8, 2019 at 5:22 AM

      If you are up to a challenge- I'd do the Process Automation Specialist. If you would like to start with something a little easier, I'd go for the Security Specialist. The best of luck!

      Delete
    2. AnonymousDecember 23, 2022 at 9:44 AM

      I am stuck at Challenge 6,7 . Here is my JSON:
      {
      "Add Temp Class": {
      "action": "computeExpression",
      "parameters": {
      "source": "Define Temp Range",
      "mergeWithSource": true,
      "computedFields": [
      {
      "name": "TempClass",
      "saqlExpression": "case when LowTemp < 25 and HighTemp < 25 then \"Polar\"\nwhen LowTemp >= 25 and HighTemp <= 50 then \"Cool\"\nwhen LowTemp >= 51 and HighTemp <= 85 then \"Continental\"\nwhen LowTemp >= 85 then \"Tropical\" end",
      "label": "TempClass",
      "type": "Numeric"
      }
      ]
      }
      },
      "Calculate Acreage": {
      "action": "computeExpression",
      "parameters": {
      "source": "Load Seed Chart",
      "mergeWithSource": true,
      "computedFields": [
      {
      "precision": 18,
      "saqlExpression": "(Seeds_Pound*Spacing)/6272640 ",
      "name": "Acreage",
      "scale": 6,
      "label": "Acreage",
      "type": "Numeric"
      }
      ]
      }
      },
      "Create Seed Bank": {
      "action": "sfdcRegister",
      "parameters": {
      "name": "Seed Bank",
      "alias": "seed_bank",
      "source": "CleanUp"
      }
      },
      "Load Seed Chart": {
      "action": "edgemart",
      "parameters": {
      "alias": "Seed_Chart"
      }
      },
      "Augment Temp Class": {
      "action": "augment",
      "parameters": {
      "right_key": [
      "TempClass"
      ],
      "left": "Add Temp Class",
      "left_key": [
      "TempClass"
      ],
      "right_select": [
      "TempClass",
      "TempKey"
      ],
      "right": "Load Temp Class Mapping",
      "relationship": "Climate",
      "operation": "LookupSingleValue"
      }
      },
      "Load Temp Class Mapping": {
      "action": "edgemart",
      "parameters": {
      "alias": "Temperature_Classes_Mapping"
      }
      },
      "CleanUp": {
      "action": "sliceDataset",
      "parameters": {
      "mode": "drop",
      "source": "Augment Temp Class",
      "fields": [
      {
      "name": "HighTemp"
      },
      {
      "name": "LowTemp"
      },
      {
      "name": "Climate.TempClass"
      },
      {
      "name": "Climate.TempKey"
      },
      {
      "name": "TempClass"
      }
      ]
      }
      },
      "Define Temp Range": {
      "action": "computeExpression",
      "parameters": {
      "source": "Calculate Acreage",
      "mergeWithSource": true,
      "computedFields": [
      {
      "defaultValue": "0",
      "saqlExpression": "string_to_number(substr(Temperature, 1, 2))\n\n",
      "name": "LowTemp",
      "label": "LowTemp",
      "type": "Numeric"
      },
      {
      "name": "HighTemp",
      "saqlExpression": "string_to_number(substr(Temperature, -2, 2))",
      "label": "HighTemp",
      "type": "Numeric"
      }
      ]
      }
      }
      }

      Delete
  2. UnknownMay 9, 2019 at 2:12 PM

    I am so lost on step 6. I have the same nodes as you, but I dont understand how you are supposed to multi join or the two nodes before that. First I create a min and max temp, then how do I use two fields to get a temperature category? Can you please post your JSON for the dataflow or at least the Define Temp Range and Add Temp Class nodes? Thank you

    ReplyDelete
    Replies
    1. Trailhead BabyMay 10, 2019 at 10:03 AM

      Step 6 is tricky! (full disclosure-- I did this superbadge twice because I didn't fully understand the first time...so don't feel bad about being lost!)

      https://developer.salesforce.com/forums/?id=9060G0000005d3yQAA ---> This thread was very heplful!

      Define Temp Range- I needed help to figure this one out as well!
      string_to_number( substr(Temperature,1,2)) for Low
      string_to_number(substr(Temperature,-2,2)) for High

      Adding the Temp Class: The SAQL starts with
      case
      when lowTemp < 25 and highTemp < 25 then "Polar"
      - then you define the rest of the ranges.

      Delete
    2. UnknownMay 3, 2020 at 4:05 AM

      Hi All, Need help for the below:



      I am trying to complete "Einstein Analytics Data Preparation Specialist" superbadge Challenge 4, I followed all the steps and cross checked multiple times still getting below error:



      Challenge Not yet complete... here's what's wrong:

      We can't find the 'Load Seed Chart' node in the dataflow. Confirm the node name matches the name as described in the challenge.



      can anyone help me out in this?

      Delete
    3. AnonymousMay 3, 2020 at 3:53 PM

      I am getting this error from step 4

      Challenge Not yet complete... here's what's wrong:
      We can't find the 'Load Seed Chart' node in the dataflow. Confirm the node name matches the name as described in the challenge.

      Delete
    4. steveMay 3, 2020 at 3:56 PM

      I am getting this error from step 4

      Challenge Not yet complete... here's what's wrong:
      We can't find the 'Load Seed Chart' node in the dataflow. Confirm the node name matches the name as described in the challenge.

      Here is the JSON

      {
      "Load Seed Chart": {
      "action": "edgemart",
      "parameters": {
      "alias": "Load_Seed_Chart"
      }
      },
      "Calculate Acreage": {
      "action": "computeExpression",
      "parameters": {
      "mergeWithSource": true,
      "source": "Load Seed Chart",
      "computedFields": [
      {
      "type": "Numeric",
      "precision": 18,
      "scale": 6,
      "saqlExpression": " (Seeds_Pound*Spacing)/6272640",
      "name": "Acreage",
      "label": "Acreage"
      }
      ]
      }
      },
      "Create Seed Bank": {
      "action": "sfdcRegister",
      "parameters": {
      "alias": "CreateSeedBank",
      "name": "CreateSeedBank",
      "source": "Calculate Acreage"
      }
      }
      }

      Delete
    5. Trailhead BabyMay 4, 2020 at 8:32 AM

      "Load Seed Chart": {
      "action": "edgemart",
      "parameters": {
      "alias": "Load_Seed_Chart"

      - Change the alias name to "Seed_Chart" - Don't ask me why.... :)


      "Create Seed Bank": {
      "action": "sfdcRegister",
      "parameters": {
      "alias": "CreateSeedBank",
      "name": "CreateSeedBank",
      "source": "Calculate Acreage"

      - Change Name and Alias name

      Delete
    6. steveMay 4, 2020 at 3:17 PM

      Thanks, after fixing the alias it worked, Now I am stuck with step # 6 Determine Optimal Climates, getting an error

      We can't find the 'Load Climate' node in the dataflow. Confirm the node name matches the name as described in the challenge.

      Here is the JSON,

      "Load Climate": {
      "action": "edgemart",
      "parameters": {
      "alias": "Load_Climate"
      }
      },

      Delete
    7. steveMay 4, 2020 at 8:02 PM

      Now I am getting this lens error,

      Challenge Not yet complete... here's what's wrong:
      We can't confirm these are the correct values in the lens. Please check your work.

      Delete
    8. Trailhead BabyMay 5, 2020 at 8:05 AM

      "Load Climate": {
      "action": "edgemart",
      "parameters": {
      "alias": "Global_Climates"

      The syntax on this challenge was a bit.... insane.
      It took a ton of trial and error to get the right Alias names.

      Delete
    9. steveMay 5, 2020 at 11:45 AM

      I was able to pass the above step and stuck at step # 6 for creating the lens.

      Challenge Not yet complete... here's what's wrong:
      We can't confirm these are the correct values in the lens. Please check your work.

      Delete
    10. Trailhead BabyMay 5, 2020 at 12:40 PM

      What do you have in the lens currently?

      Delete
    11. steveMay 5, 2020 at 3:01 PM

      I have created lens for Agency Temp Class, it has Continental 155, Polar 120 and Cool 66 based on Seed Bank Agencies Data Set.

      Another lens Seed Bank Temp Class based on Seed Bank Data Set has
      Cool-Continental-Tropical 3
      Continental-Tropical 2
      Cool-Continental 2
      Continental 1
      Cool 1

      Delete
    12. steveMay 5, 2020 at 6:17 PM

      After fixing lens configurations, now I am getting this error,

      Challenge Not yet complete... here's what's wrong:
      We can't confirm your lens displays the top climate class.

      Delete
    13. Trailhead BabyMay 6, 2020 at 9:53 AM

      It's been a while.... so I hope this is good advice! I only see one temp.class on my lens- just the one with 155.

      Delete
    14. steveMay 6, 2020 at 5:36 PM

      I was able to complete Data Preparation Super badge, now I am doing Einstein Analytics and Discovery Insights Specialist and stuck at step # 3 (Calculate Subscriber Acquisition Costs)

      Challenge Not yet complete... here's what's wrong:
      We can't confirm the Subscriber Revenue chart is filtering by the Tenure Length toggle. Confirm there's a binding that filters attrition costs displayed in the reference line.

      Appreciate if you provide any help.

      Delete
    15. Trailhead BabyMay 7, 2020 at 10:28 AM

      Hi Steve- I can't give you any help on this one... I haven't done that superbadge yet! (Working on the advanced billing specialist!)

      Delete
    16. AnonymousMay 16, 2020 at 8:51 PM

      Hi Steve - How did you fix the "We can't confirm these are the correct values in the lens. Please check your work." error in challenge 6

      Delete
    17. AnonymousMay 24, 2020 at 10:39 PM

      I was able to complete the challenge
      For Agency Temp Class Lens values should be -
      Continental - 155(and Polar - 120, Cool - 66)

      For Seed Bank Temp Class Lens Values should be -
      Continental - 26(and Cool - 15)

      You would only focus Continental in the lens before Saving.

      Delete
    18. AnonymousDecember 17, 2020 at 2:03 PM

      This is regarding Challenge 6. I am getting this error despite all the dataflows successful. please help, I have tried everything but getting the same error since 3 days now -

      Challenge Not yet complete... here's what's wrong:
      We can't validate the 'Create Seed Bank Agencies' node was created correctly. Check the required fields, field types, node name, and alias are correct.

      Delete
  3. Little BigginAugust 18, 2019 at 9:20 AM

    mistake was for the case statement I had an upper case "C" in Case (which is how its always done in VC++ and VB

    ReplyDelete
    Replies
    1. Trailhead BabyAugust 19, 2019 at 8:50 AM

      Glad you figured it out! (Trailhead Baby was 'gone fishing' this weekend, and didn't check for comments!)

      Delete
    2. UnknownFebruary 2, 2022 at 12:23 AM

      Hi please help in update the data flow.i can't update my data flow..show errors in that

      Delete
  4. AnonymousSeptember 30, 2019 at 2:03 PM

    I am stuck at the SAQL Expression field for 'Calculate Acreage'. Its giving me a syntax error.

    ReplyDelete
  5. AnonymousDecember 27, 2019 at 1:44 AM

    Could you please let me know the issue in challenge 4:

    {
    "Load Seed Chart": {
    "action": "edgemart",
    "parameters": {
    "alias": "Load_Seed_Chart"
    }
    },
    "Calculate Acreage": {
    "action": "computeExpression",
    "parameters": {
    "mergeWithSource": true,
    "source": "Load Seed Chart",
    "computedFields": [
    {
    "type": "Numeric",
    "name": "Acreage",
    "label": "Acreage",
    "saqlExpression": "(Seeds_Pound*Spacing)/6272640",
    "precision": 18,
    "scale": 6
    }
    ]
    }
    },
    "Create Seed Bank": {
    "action": "sfdcRegister",
    "parameters": {
    "alias": "seed_bank",
    "source": "Calculate Acreage",
    "name": "Create Seed Bank"
    }

    ReplyDelete
    Replies
    1. Trailhead BabyDecember 27, 2019 at 8:08 AM

      "Load Seed Chart": {
      "action": "edgemart",
      "parameters": {
      "alias": "Load_Seed_Chart"

      Wrong Alias

      Delete
  6. Trailhead BabyJanuary 13, 2020 at 8:26 AM

    Try leaving Precision and Scale blank for both low and high temp.

    ReplyDelete
  7. Trailhead BabyJanuary 13, 2020 at 10:53 AM

    hmm Could you post the json for the dataflow? These challenges are super tricky with syntax!

    ReplyDelete
  8. Trailhead BabyJanuary 13, 2020 at 12:03 PM

    "Create Seed Bank": {
    "action": "sfdcRegister",
    "parameters": {
    "name": "Seed Bank Agencies",
    "alias": "seed_bank_agencies",
    "source": "CleanUp"

    - You need a different name and alias. I didn't look through the whole JSON yet, but that's my bet.

    ReplyDelete
  9. Trailhead BabyJanuary 13, 2020 at 2:39 PM

    Yay!!!!!

    ReplyDelete
  10. LilyApril 5, 2020 at 11:11 AM

    Could you please give me the final json? thanks.~

    ReplyDelete
  11. Trailhead BabyApril 6, 2020 at 9:18 AM

    No. That would be cheating--- I'm happy to provide hints, but will never share answers. This would take away from the purpose of the superbadge.

    ReplyDelete
  12. sai kiranApril 20, 2020 at 11:24 AM

    hi ,
    unable to find error in step 4

    {
    "Calculate Acreage": {
    "action": "computeExpression",
    "parameters": {
    "mergeWithSource": true,
    "source": "Load Seed Chart",
    "computedFields": [
    {
    "type": "Numeric",
    "name": "Acreage",
    "label": "Acreage",
    "saqlExpression": "(Seeds_Pound*Spacing)/6272640",
    "precision": 18,
    "scale": 6
    }
    ]
    }
    },
    "Load Seed Chart": {
    "action": "edgemart",
    "parameters": {
    "alias": "Seed_Chart"
    }
    },
    "Create Seed Bank": {
    "action": "sfdcRegister",
    "parameters": {
    "source": "Calculate Acreage",
    "name": "Create Seed Bank",
    "alias": "CreateSeedBank"
    }
    }
    }

    ReplyDelete
  13. UnknownApril 27, 2020 at 1:01 AM

    Hi,

    Can you please let me know the correct values of both lens. I am getting exception like :
    Challenge Not yet complete... here's what's wrong:
    We can't confirm these are the correct values in the lens. Please check your work.

    Many thanks.

    ReplyDelete
  14. MithileshApril 27, 2020 at 4:22 AM

    Hi,

    i'm facing an issue in Challenge-4. i'm not able to understand what exactly is wrong with my approach.

    My approach:

    1. uploaded Seed Chart.txt from resource to create a dataset in mosiac app.
    2. created a dataflow with name "Load Seed Bank" . Please find JSON below:

    {
    "Load Seed Chart": {
    "action": "edgemart",
    "parameters": {
    "alias": "Seed_Chart"
    }
    },
    "Calculate Acreage": {
    "action": "computeExpression",
    "parameters": {
    "mergeWithSource": true,
    "source": "Load Seed Chart",
    "computedFields": [
    {
    "type": "Numeric",
    "saqlExpression": "(Seeds_Pound*Spacing)/6272640",
    "precision": 18,
    "scale": 6,
    "name": "Acreage",
    "label": "Acreage"
    }
    ]
    }
    },
    "Create Seed Bank": {
    "action": "sfdcRegister",
    "parameters": {
    "source": "Calculate Acreage",
    "alias": "seed_bank",
    "name": "Create Seed Bank"
    }
    }
    }

    then ran this dataflow and created a lens with the dataset created. When validating the challenge, i'm getting an error stating this:-

    "Challenge Not yet complete... here's what's wrong:
    We can't find the Seed Bank dataset or required fields are missing. Check the challenge and confirm the node name and required fields."

    Awaiting a helpful response.

    Thanks,
    Mithilesh

    ReplyDelete
    Replies
    1. Trailhead BabyApril 27, 2020 at 8:30 AM

      "name": "Create Seed Bank" - This is incorrect.

      Delete
    2. MithileshApril 27, 2020 at 10:40 AM

      Hi,

      Thanks for your reply. i changed "name" to "seed bank". still i'm facing the same issue. not sure what is wrong here as i followed the same approach for challenge-3.

      Delete
    3. MithileshApril 27, 2020 at 10:46 AM

      oops... i got it solved. i was doing a silly mistake. My bad. Thanks for your help again.

      Delete
    4. Trailhead BabyApril 27, 2020 at 2:41 PM

      Perfect!!!

      Delete
    5. ShruthiMay 18, 2020 at 6:32 AM

      Hi Mithilesh, Can you please tell me what was the mistake you were doing because even i followed the same steps and i am still facing the error.

      Delete
  15. UnknownApril 28, 2020 at 12:33 AM

    Hi Trailhead Baby,

    Please help me. I am stuck at step 6 of Einstein Analytics Data Preparation Specialist super badge.

    Message:

    Challenge Not yet complete... here's what's wrong:
    We can't confirm these are the correct values in the lens. Please check your work.

    What should be the values for both lens ?

    Waiting for your response.

    Thanks

    ReplyDelete
  16. MithileshMay 4, 2020 at 2:53 AM

    Hi,

    i'm on challenge-6 and i created a dataflow called "Load Seed Bank Agencies w/Climate Data" but this dataflow is failing when i'm trying to run it.

    Error:

    Something went wrong while executing the Filter 2015 node: invalid field expression for field 'Date_Year': Syntax Error at position [line 1: column 11] after token Unexpected character ':' :: ;Date_Year:EQ:2015;
    posting JSON in other comment.

    ReplyDelete
  17. MithileshMay 4, 2020 at 2:55 AM

    JSON for filter node:

    "Filter 2015": {
    "action": "computeExpression",
    "parameters": {
    "source": "Load Climate",
    "mergeWithSource": true,
    "computedFields": [
    {
    "saqlExpression": "Date_Year:EQ:2015",
    "name": "Date_Year",
    "label": "Date_Year",
    "type": "Text"
    }
    ]
    }
    },

    Thanks

    ReplyDelete
    Replies
    1. Trailhead BabyMay 4, 2020 at 8:42 AM

      I have the action as "filter", not "computeExpression"

      Delete
    2. MithileshMay 5, 2020 at 2:13 AM

      such a silly mistake it was and i was stuck there for long. BTW thanks.

      Delete
    3. Trailhead BabyMay 5, 2020 at 8:05 AM

      Glad you are past it!

      Delete
  18. UnknownMay 7, 2020 at 5:17 AM

    Hi Rebecca,

    in Step 4 , i am getting this error :: "We can't find the Acreage field. Check the challenge and confirm required field setting." let me know what i am missing here.

    {
    "Calculate Acreage": {
    "action": "computeExpression",
    "parameters": {
    "source": "Load Seed Chart",
    "mergeWithSource": true,
    "computedFields": [
    {
    "precision": 18,
    "saqlExpression": " (Seeds_Pound*Spacing)/6272640",
    "name": "Acreage",
    "scale": 6,
    "label": "Acreage",
    "type": "Numeric"
    }
    ]
    }
    },
    "Create Seed Bank": {
    "action": "sfdcRegister",
    "parameters": {
    "name": "Create Seed Bank",
    "alias": "Create_Seed_Bank",
    "source": "Calculate Acreage"
    }
    },
    "Load Seed Chart": {
    "action": "edgemart",
    "parameters": {
    "alias": "Seed_Chart"
    }
    }
    }

    ReplyDelete
    Replies
    1. UnknownMay 7, 2020 at 6:46 AM

      I just checked the seed chart flat file, and i could see that Acreage filed itself is not present, so i downloaded the zip file again and found that there is no filed called Acreage in it as well , i found this when i clicked on output fields of Load Seed Chart: edgemart.

      please let me know if this is the case and if yes how can i fix it?


      Delete
    2. Trailhead BabyMay 7, 2020 at 11:43 AM

      There is not a field named Acreage in the zip file - It is a field you create by calculation within the data flow.

      The error is in this - A name/alias is not correct:

      "Create Seed Bank": {
      "action": "sfdcRegister",
      "parameters": {
      "name": "Create Seed Bank",
      "alias": "Create_Seed_Bank",
      "source": "Calculate Acreage"

      Delete
    3. UnknownMay 7, 2020 at 12:16 PM

      thank you for the light, tried the below ways nothing worked

      "Create Seed Bank": {
      "action": "sfdcRegister",
      "parameters": {
      "name": "Seed Bank",
      "alias": "Seed_Bank",
      "source": "Calculate Acreage"
      }
      },


      "Create Seed Bank": {
      "action": "sfdcRegister",
      "parameters": {
      "name": "seed bank",
      "alias": "seed_bank",
      "source": "Calculate Acreage"
      }
      },

      Delete
    4. Trailhead BabyMay 7, 2020 at 12:55 PM

      So close! Name capitalized, alias not capitalized.

      Delete
    5. UnknownMay 7, 2020 at 1:03 PM

      I just checked in my data sets i kind of uploaded twice for seed chart file, so i deleted the first version of it, kept the latest version under Mosiac app, named it as " Seed Chart" and api name is "Seed_Chart"

      here is new error ""

      and my jason is ::We can't find the Seed Bank dataset or required fields are missing. Check the challenge and confirm the node name and required fields.

      {
      "Calculate Acreage": {
      "action": "computeExpression",
      "parameters": {
      "source": "Load Seed Chart",
      "mergeWithSource": true,
      "computedFields": [
      {
      "name": "Acreage",
      "saqlExpression": "(Seeds_Pound*Spacing)/6272640",
      "label": "Acreage",
      "type": "Numeric",
      "precision": 18,
      "scale": 6
      }
      ]
      }
      },
      "Create Seed Bank": {
      "action": "sfdcRegister",
      "parameters": {
      "name": "Seed_Bank",
      "alias": "Seed Bank",
      "source": "Calculate Acreage"
      }
      },
      "Load Seed Chart": {
      "action": "edgemart",
      "parameters": {
      "alias": "Seed_Chart"
      }
      }
      }

      do i need to delete the flat file and need to upload with seed_bank as the api name?

      Delete
    6. UnknownMay 7, 2020 at 1:28 PM

      So much banging and so silly of me, i had the issues fixed, i passed the step 4

      Delete
    7. Trailhead BabyMay 7, 2020 at 1:59 PM

      Good to hear!!!

      Delete
    8. AnonymousMay 23, 2020 at 2:52 AM

      Even though i have done everything as mentioned, while creating the lens i am not able to see the acreage field under Bar length

      Delete
    9. Trailhead BabyMay 26, 2020 at 9:15 AM

      Which of the Lenses are you working to create?

      Delete
  19. Shouldnt be this difficultMay 11, 2020 at 10:38 AM

    Trailhead Baby,

    I'm having an issue with Load Seed Bank w/Temperature Classification
    I keep getting this error after running the data flow and there is no data in the lens. Im not sure were to start.

    The dataflow was completed, but the LookupSingleValue node didn't augment any columns. Either the node didn't find any matches, or a join key contains only null values.

    ReplyDelete
    Replies
    1. Trailhead BabyMay 11, 2020 at 12:04 PM

      I'm happy to take a look at your json.

      Delete
    2. Shouldnt be this difficultMay 11, 2020 at 1:21 PM

      Thanks Ill have to put this in two post.

      {
      "Add Temp Class": {
      "action": "computeExpression",
      "parameters": {
      "source": "Define Temp Range",
      "mergeWithSource": true,
      "computedFields": [
      {
      "name": "TempClass",
      "saqlExpression": "\"case \\nwhen lowTemp < 25 and highTemp < 25 then \\\"Polar\\\" \\nwhen lowTemp >= 25 and lowTemp <= 50 and highTemp >= 25 and highTemp <= 50 then \\\"Cool\\\"\\nwhen lowTemp >= 51 and lowTemp <= 85 and highTemp >= 51 and highTemp <= 85 then \\\"Continental\\\"\\nwhen lowTemp > 85 and highTemp > 85 then \\\"Tropical\\\"\\nwhen lowTemp < 25 and (highTemp >= 25 and highTemp <= 50) then \\\"Polar-Cool\\\" \\nwhen lowTemp < 25 and (highTemp >= 25 and highTemp <= 85) then \\\"Polar-Cool-Continental\\\" \\nwhen lowTemp < 25 and highTemp > 85 then \\\"Polar-Cool-Continental-Tropical\\\" \\nwhen (lowTemp >= 25 and lowTemp <= 50) and (highTemp >= 51 and highTemp <= 85) then \\\"Cool-Continental\\\" \\nwhen (lowTemp >= 25 and lowTemp <= 50) and highTemp >= 85 then \\\"Cool-Continental-Tropical\\\" \\nwhen (lowTemp >= 51 and lowTemp <= 85) and highTemp > 85 then \\\"Continental-Tropical\\\" \\nend\"",
      "label": "TempClass",
      "type": "Text"
      }
      ]
      }
      },
      "Calculate Acreage": {
      "action": "computeExpression",
      "parameters": {
      "source": "Load Seed Chart",
      "mergeWithSource": true,
      "computedFields": [
      {
      "precision": 18,
      "name": "Acreage",
      "saqlExpression": "(Seeds_Pound*Spacing)/6272640",
      "scale": 6,
      "label": "Acreage",
      "type": "Numeric"
      }
      ]
      }
      },
      "Create Seed Bank": {
      "action": "sfdcRegister",
      "parameters": {
      "name": "Seed Bank",
      "alias": "seed_bank",
      "source": "CleanUp"
      }
      },
      "Load Seed Chart": {
      "action": "edgemart",
      "parameters": {
      "alias": "Seed_Chart"
      }
      },

      Delete
    3. Shouldnt be this difficultMay 11, 2020 at 1:22 PM

      "Augment Temp Class": {
      "action": "augment",
      "parameters": {
      "left": "Load Temp Class Mapping",
      "right": "Add Temp Class",
      "relationship": "Climate",
      "operation": "LookupSingleValue",
      "left_key": [
      "TempKey"
      ],
      "right_key": [
      "TempClass"
      ],
      "right_select": [
      "Acreage",
      "hightemp",
      "Lifecycle",
      "lowtemp",
      "Quantity_Pounds",
      "Seed",
      "Seeds_Pound",
      "Seed_ID",
      "Seed_Type",
      "Spacing",
      "TempClass",
      "Temperature"
      ]
      }
      },
      "Load Temp Class Mapping": {
      "action": "edgemart",
      "parameters": {
      "alias": "Temperature_Classes_Mapping"
      }
      },
      "CleanUp": {
      "action": "sliceDataset",
      "parameters": {
      "mode": "drop",
      "source": "Augment Temp Class",
      "fields": [
      {
      "name": "TempClass"
      },
      {
      "name": "TempKey"
      },
      {
      "name": "Climate.lowtemp"
      },
      {
      "name": "Climate.hightemp"
      }
      ]
      }
      },
      "Define Temp Range": {
      "action": "computeExpression",
      "parameters": {
      "source": "Calculate Acreage",
      "mergeWithSource": true,
      "computedFields": [
      {
      "defaultValue": "0",
      "precision": 18,
      "name": "lowtemp",
      "saqlExpression": "string_to_number( substr(Temperature, 1, 2))",
      "scale": 2,
      "label": "lowtemp",
      "type": "Numeric"
      },
      {
      "defaultValue": "0",
      "precision": 18,
      "name": "hightemp",
      "saqlExpression": "string_to_number(substr(Temperature, -2, 2))",
      "scale": 2,
      "label": "hightemp",
      "type": "Numeric"
      }
      ]
      }
      }
      }

      Delete
    4. Trailhead BabyMay 11, 2020 at 1:47 PM

      "left_key": [
      "TempKey"
      ],
      "right_key": [
      "TempClass"

      I think this is the issue. Key value should be the same.

      Delete
  20. Shouldnt be this difficultMay 11, 2020 at 2:03 PM

    I just tried that and it I still keep getting this error.

    The dataflow was completed, but the LookupSingleValue node didn't augment any columns. Either the node didn't find any matches, or a join key contains only null values

    ReplyDelete
    Replies
    1. Trailhead BabyMay 12, 2020 at 8:17 AM

      If you post your revised JSON, I'll take a look.

      Delete
  21. UnknownMay 12, 2020 at 2:28 PM

    Hi Rebecca,

    in #6 for building Seed Bank Temp Class lens, they mentioned the dataset as " Seed Bank" but from the zip i do not see any flat file with that name, i could see only seed chart and seed bank orders please let me know which file i need to upload for dataset?

    ReplyDelete
    Replies
    1. Trailhead BabyMay 18, 2020 at 11:59 AM

      The dataset is created by the dataflow that you create.

      Delete
  22. UnknownMay 12, 2020 at 3:08 PM

    Hi ,

    Load Seed Bank w/Temperature Classification when ran ,getting an error like below
    " The dataflow was completed, but the LookupSingleValue node didn't augment any columns. Either the node didn't find any matches, or a join key contains only null values."

    {
    "Add Temp Class": {
    "action": "computeExpression",
    "parameters": {
    "source": "Define Temp Range",
    "mergeWithSource": true,
    "computedFields": [
    {
    "defaultValue": "Continental",
    "name": "TempClass",
    "saqlExpression": "\"case when Temperature < 25 then \\\"Polar\\\" when Temperature >= 25 and Temperature <= 50 then \\\"Cool\\\" when Temperature >= 51 and Temperature <= 85 then \\\"Continental\\\" when Temperature > 85 then \\\"Tropical\\\" end\"",
    "label": "TempClass",
    "type": "Text"
    }
    ]
    }
    },
    "Calculate Acreage": {
    "action": "computeExpression",
    "parameters": {
    "source": "Load Seed Chart",
    "mergeWithSource": true,
    "computedFields": [
    {
    "precision": 18,
    "name": "Acreage",
    "saqlExpression": "(Seeds_Pound*Spacing)/6272640",
    "scale": 6,
    "label": "Acreage",
    "type": "Numeric"
    }
    ]
    }
    },
    "Create Seed Bank": {
    "action": "sfdcRegister",
    "parameters": {
    "name": "Seed Bank Agencies",
    "alias": "seed_bank_agencies",
    "source": "CleanUp"
    }
    },
    "Load Seed Chart": {
    "action": "edgemart",
    "parameters": {
    "alias": "Seed_Chart"
    }
    },
    "Augment Temp Class": {
    "action": "augment",
    "parameters": {
    "right_key": [
    "TempClass"
    ],
    "left": "Add Temp Class",
    "left_key": [
    "TempClass"
    ],
    "right_select": [
    "TempKey",
    "TempClass"
    ],
    "right": "Load Temp Class Mapping",
    "relationship": "Climate",
    "operation": "LookupSingleValue"
    }
    },

    i am posting remaining half in another comment due to html limit error

    ReplyDelete
  23. UnknownMay 12, 2020 at 3:09 PM

    contd...

    "Load Temp Class Mapping": {
    "action": "edgemart",
    "parameters": {
    "alias": "Temperature_Classes_Mapping"
    }
    },
    "CleanUp": {
    "action": "sliceDataset",
    "parameters": {
    "mode": "drop",
    "source": "Augment Temp Class",
    "fields": [
    {
    "name": "HighTemp"
    },
    {
    "name": "LowTemp"
    }
    ]
    }
    },
    "Define Temp Range": {
    "action": "computeExpression",
    "parameters": {
    "source": "Calculate Acreage",
    "mergeWithSource": true,
    "computedFields": [
    {
    "defaultValue": "0",
    "precision": 18,
    "name": "LowTemp",
    "saqlExpression": "string_to_number(substr(Temperature, 1, 2))",
    "scale": 2,
    "label": "LowTemp",
    "type": "Numeric"
    },
    {
    "defaultValue": "0",
    "precision": 18,
    "name": "HighTemp",
    "saqlExpression": "string_to_number(substr(Temperature, -2, 2))",
    "scale": 2,
    "label": "HighTemp",
    "type": "Numeric"
    }
    ]
    }
    }
    }
    please share me your insights to fix my code or data.

    ReplyDelete
    Replies
    1. UnknownMay 14, 2020 at 2:28 AM

      deleted the data flow and re executed flow still the same old error, i made some corrections with the alias names and spaces issues but nothing is heping me to move forward ! :(

      Delete
    2. Trailhead BabyMay 18, 2020 at 12:06 PM

      {
      "defaultValue": "Continental",
      "name": "TempClass",
      "saqlExpression": "\"case when Temperature < 25 then \\\"Polar\\\" when Temperature >= 25 and Temperature <= 50 then \\\"Cool\\\" when Temperature >= 51 and Temperature <= 85 then \\\"Continental\\\" when Temperature > 85 then \\\"Tropical\\\" end\"",
      "label": "TempClass",
      "type": "Text"

      I see an issue with the SAQL

      Delete
  24. AntonioLMay 14, 2020 at 6:50 AM

    Hi,
    I'm stuck at step 6... Before focus, I have: Polar 93, Continental 91, Cool 42. Are this numbers correct?

    Thanks,
    Antonio

    ReplyDelete
    Replies
    1. Trailhead BabyMay 14, 2020 at 11:13 AM

      Agency Temp Class lens? I have higher numbers for all.

      Delete
    2. AntonioLMay 14, 2020 at 2:28 PM

      Yes! For Agency Temp Class lens... I think I have the correct dataflow "Load Seed Bank Agencies w/Climate Data"... What could it be? wrong data?

      Delete
    3. Trailhead BabyMay 14, 2020 at 2:54 PM

      hmmm I'm happy to take a look at the json if you like.

      Delete
    4. AntonioLMay 14, 2020 at 3:40 PM

      Here it goes! Thanks!!

      I can't copy here all the code, so I have copy in Gdrive.
      https://docs.google.com/document/d/1RaNsOtQZlsL_yVTd0NWkox9kpyV1LLJ60fWBEVQwsLI/edit?usp=sharing

      Delete
    5. Trailhead BabyMay 15, 2020 at 8:36 AM

      If you could just post the JSON for your data flow, I will take a look.

      Delete
    6. AntonioLMay 15, 2020 at 10:41 AM

      "Add Temp Class": {
      "action": "computeExpression",
      "parameters": {
      "source": "Filter 2015",
      "mergeWithSource": true,
      "computedFields": [
      {
      "defaultValue": "Continental",
      "name": "TempClass",
      "saqlExpression": "case when Temperature < 25 then \"Polar\" when Temperature >= 25 and Temperature <= 50 then \"Cool\" when Temperature >= 51 and Temperature <= 85 then \"Continental\" when Temperature > 85 then \"Tropical\" end",
      "label": "TempClass",
      "type": "Text"
      }
      ]
      }
      },
      "Filter Agency Records": {
      "action": "filter",
      "parameters": {
      "filter": "IsAgency:EQ:TRUE",
      "source": "ID Agency Records"
      }
      },
      "Load Account": {
      "action": "sfdcDigest",
      "parameters": {
      "fields": [
      {
      "name": "AccountNumber"
      },
      {
      "name": "Name"
      },
      {
      "name": "Phone"
      },
      {
      "name": "ShippingCity"
      },
      {
      "name": "ShippingCountry"
      },
      {
      "name": "ShippingPostalCode"
      },
      {
      "name": "ShippingState"
      },
      {
      "name": "ShippingStreet"
      }
      ],
      "object": "Account"
      }
      },
      "Create Seed Bank Agencies": {
      "action": "sfdcRegister",
      "parameters": {
      "name": "Seed Bank Agencies",
      "alias": "seed_bank_agencies",
      "source": "Augment TempClass"
      }
      },
      "Load Climate": {
      "action": "edgemart",
      "parameters": {
      "alias": "Global_Climates"
      }
      },
      "Add Agency Fields": {
      "action": "augment",
      "parameters": {
      "right_key": [
      "AccountNumber"
      ],
      "left": "Load Account",
      "left_key": [
      "AccountNumber"
      ],
      "right_select": [
      "Acres",
      "Currency",
      "Latitude",
      "Longitude",
      "Region",
      "SubRegion"
      ],
      "right": "Load Agency Detail",
      "relationship": "AgencyDetail",
      "operation": "LookupSingleValue"
      }
      },

      Delete
    7. AntonioLMay 15, 2020 at 10:42 AM

      "Filter 2015": {
      "action": "filter",
      "parameters": {
      "filter": "Date_Year:EQ:2015",
      "source": "Load Climate"
      }
      },
      "Augment TempClass": {
      "action": "augment",
      "parameters": {
      "right_key": [
      "Country"
      ],
      "left": "Filter Agency Records",
      "left_key": [
      "ShippingCountry"
      ],
      "right_select": [
      "Country",
      "Date",
      "TempClass",
      "Temperature"
      ],
      "right": "Add Temp Class",
      "relationship": "Climate",
      "operation": "LookupSingleValue"
      }
      },
      "Load Agency Detail": {
      "action": "edgemart",
      "parameters": {
      "alias": "Agency_Detail"
      }
      },
      "ID Agency Records": {
      "action": "computeExpression",
      "parameters": {
      "source": "Add Agency Fields",
      "mergeWithSource": true,
      "computedFields": [
      {
      "name": "IsAgency",
      "saqlExpression": "case when Phone is not null then \"TRUE\" else \"FALSE\" end",
      "label": "IsAgency",
      "type": "Text"
      }
      ]
      }
      }
      }

      I had to copy in two comments, it was to large.
      Thanks for your help.

      Delete
    8. Trailhead BabyMay 15, 2020 at 1:55 PM

      },
      "Add Agency Fields": {
      "action": "augment",
      "parameters": {
      "right_key": [
      "AccountNumber"
      ],
      "left": "Load Account",
      "left_key": [
      "AccountNumber"
      ],
      "right_select": [
      "Acres",
      "Currency",
      "Latitude",
      "Longitude",
      "Region",
      "SubRegion"

      One field is missing. Hint: You can't match on a field that isnt' selected for both data sets.

      Delete
    9. AntonioLMay 16, 2020 at 9:53 AM

      I've added at the right select AccountNumber at Add Agency Fields and propagated, but still it isn't work.. this is blowing my mind!

      Delete
    10. Trailhead BabyMay 18, 2020 at 12:26 PM

      Want to post the revised json? I didn't dig any further once I saw the AccountNumber issue.

      Delete
  25. UnknownMay 14, 2020 at 12:10 PM

    Hi ,

    i am getting " The dataflow was completed, but the LookupSingleValue node didn't augment any columns. Either the node didn't find any matches, or a join key contains only null values."
    when i validate my step 6, i checked with existing suggestion via above posts i have corrected alias name and left key and right key for same name nothing worked and struck with from some now, please let me know what else i am missing !

    thanks
    kiran

    ReplyDelete
    Replies
    1. Trailhead BabyMay 14, 2020 at 12:32 PM

      Could you post the JSON?

      Delete
    2. UnknownMay 16, 2020 at 9:39 AM

      Thank you , please find my Json file , with the html limits i will be posting in 2 comments


      {
      "Add Temp Class": {
      "action": "computeExpression",
      "parameters": {
      "source": "Define Temp Range",
      "mergeWithSource": true,
      "computedFields": [
      {
      "name": "TempClass",
      "saqlExpression": "\"case \\nwhen lowTemp < 25 and highTemp < 25 then \\\"Polar\\\" \\nwhen lowTemp >= 25 and lowTemp <= 50 and highTemp >= 25 and highTemp <= 50 then \\\"Cool\\\"\\nwhen lowTemp >= 51 and lowTemp <= 85 and highTemp >= 51 and highTemp <= 85 then \\\"Continental\\\"\\nwhen lowTemp > 85 and highTemp > 85 then \\\"Tropical\\\"\\nwhen lowTemp < 25 and (highTemp >= 25 and highTemp <= 50) then \\\"Polar-Cool\\\" \\nwhen lowTemp < 25 and (highTemp >= 25 and highTemp <= 85) then \\\"Polar-Cool-Continental\\\" \\nwhen lowTemp < 25 and highTemp > 85 then \\\"Polar-Cool-Continental-Tropical\\\" \\nwhen (lowTemp >= 25 and lowTemp <= 50) and (highTemp >= 51 and highTemp <= 85) then \\\"Cool-Continental\\\" \\nwhen (lowTemp >= 25 and lowTemp <= 50) and highTemp >= 85 then \\\"Cool-Continental-Tropical\\\" \\nwhen (lowTemp >= 51 and lowTemp <= 85) and highTemp > 85 then \\\"Continental-Tropical\\\" \\nend\"",
      "label": "TempClass",
      "type": "Text"
      }
      ]
      }
      },
      "Calculate Acreage": {
      "action": "computeExpression",
      "parameters": {
      "source": "Load Seed Chart",
      "mergeWithSource": true,
      "computedFields": [
      {
      "precision": 18,
      "name": "Acreage",
      "saqlExpression": "(Seeds_Pound*Spacing)/6272640",
      "scale": 6,
      "label": "Acreage",
      "type": "Numeric"
      }
      ]
      }
      },
      "Create Seed Bank": {
      "action": "sfdcRegister",
      "parameters": {
      "name": "Seed Bank",
      "alias": "seed_bank",
      "source": "CleanUp"
      }
      },

      Delete
    3. UnknownMay 16, 2020 at 9:39 AM

      "Load Seed Chart": {
      "action": "edgemart",
      "parameters": {
      "alias": "Seed_Chart"
      }
      },
      "Augment Temp Class": {
      "action": "augment",
      "parameters": {
      "right_key": [
      "TempClass"
      ],
      "left": "Load Temp Class Mapping",
      "left_key": [
      "TempClass"
      ],
      "right_select": [
      "Acreage",
      "hightemp",
      "Lifecycle",
      "lowtemp",
      "Quantity_Pounds",
      "Seed",
      "Seeds_Pound",
      "Seed_ID",
      "Seed_Type",
      "Spacing",
      "TempClass",
      "Temperature"
      ],
      "right": "Add Temp Class",
      "relationship": "Climate",
      "operation": "LookupSingleValue"
      }
      },
      "Load Temp Class Mapping": {
      "action": "edgemart",
      "parameters": {
      "alias": "Temperature_Classes_Mapping"
      }
      },
      "CleanUp": {
      "action": "sliceDataset",
      "parameters": {
      "mode": "drop",
      "source": "Augment Temp Class",
      "fields": [
      {
      "name": "TempClass"
      },
      {
      "name": "TempKey"
      },
      {
      "name": "Climate.lowtemp"
      },
      {
      "name": "Climate.hightemp"
      }
      ]
      }
      },
      "Define Temp Range": {
      "action": "computeExpression",
      "parameters": {
      "source": "Calculate Acreage",
      "mergeWithSource": true,
      "computedFields": [
      {
      "defaultValue": "0",
      "precision": 18,
      "name": "lowtemp",
      "saqlExpression": "string_to_number( substr(Temperature, 1, 2))",
      "scale": 2,
      "label": "lowtemp",
      "type": "Numeric"
      },
      {
      "defaultValue": "0",
      "precision": 18,
      "name": "hightemp",
      "saqlExpression": "string_to_number( substr(Temperature, -2, 2))",
      "scale": 2,
      "label": "hightemp",
      "type": "Numeric"
      }
      ]
      }
      }
      }

      Delete
    4. UnknownMay 16, 2020 at 2:07 PM

      @trailhead baby,
      i just updated one alias name in above posts

      from :::
      "name": "Seed Bank",
      "alias": "seed_bank"

      to:::
      "name": "Seed Bank",
      "alias": "Seed_Bank"

      and re ran the dataflow still have the same old issue no progress !

      Delete
    5. Trailhead BabyMay 18, 2020 at 12:22 PM

      },
      "CleanUp": {
      "action": "sliceDataset",
      "parameters": {
      "mode": "drop",
      "source": "Augment Temp Class",
      "fields": [
      {
      "name": "TempClass"
      },
      {
      "name": "TempKey"
      },
      {
      "name": "Climate.lowtemp"
      },
      {
      "name": "Climate.hightemp"
      }

      this is incorrect

      Delete
    6. UnknownMay 19, 2020 at 7:19 AM

      Thank you for the pointers i made some new changes the data flow ran fine finally after the drill. but when checked the challenge i am getting this error mentioned below

      Challenge Not yet complete... here's what's wrong:
      We can't find the 'Create Seed Bank Agencies' node or required fields, such as 'TempClass', are missing. Check the challenge and confirm the node name and required fields


      {
      "Calculate Acreage": {
      "action": "computeExpression",
      "parameters": {
      "source": "Load Seed Chart",
      "mergeWithSource": true,
      "computedFields": [
      {
      "precision": 18,
      "name": "Acreage",
      "saqlExpression": " (Seeds_Pound*Spacing)/6272640",
      "scale": 6,
      "label": "Acreage",
      "type": "Numeric"
      }
      ]
      }
      },
      "Load Seed Chart": {
      "action": "edgemart",
      "parameters": {
      "alias": "Seed_Chart"
      }
      },
      "Load Temp Class Mapping": {
      "action": "edgemart",
      "parameters": {
      "alias": "Temperature_Classes_Mapping"
      }
      },
      "Define Temp Range": {
      "action": "computeExpression",
      "parameters": {
      "mergeWithSource": true,
      "source": "Calculate Acreage",
      "computedFields": [
      {
      "type": "Numeric",
      "name": "LowTemp",
      "label": "LowTemp",
      "saqlExpression": "string_to_number(substr(Temperature, 1, 2))",
      "precision": 18,
      "scale": 2
      },
      {
      "type": "Numeric",
      "name": "HighTemp",
      "label": "HighTemp",
      "saqlExpression": "string_to_number(substr(Temperature, -2, 2))",
      "precision": 18,
      "scale": 2
      }
      ]
      }
      },

      Delete
    7. UnknownMay 19, 2020 at 7:19 AM

      contd...

      "Add Temp Class": {
      "action": "computeExpression",
      "parameters": {
      "mergeWithSource": true,
      "source": "Define Temp Range",
      "computedFields": [
      {
      "type": "Text",
      "name": "TempClass",
      "label": "TempClass",
      "saqlExpression": "case when Temperature < \"25\" then \"Polar\" \nwhen Temperature >= \"25\" and Temperature <= \"50\" then \"Cool\" when Temperature >= \"51\" and Temperature <= \"85\" then \"Continental\" \nwhen Temperature > \"85\" then \"Tropical\" \nend",
      "precision": 18
      }
      ]
      }
      },
      "Augment Temp Class": {
      "action": "augment",
      "parameters": {
      "operation": "LookupSingleValue",
      "left": "Add Temp Class",
      "relationship": "Climate",
      "right": "Load Temp Class Mapping",
      "left_key": [
      "TempClass"
      ],
      "right_key": [
      "TempKey"
      ],
      "right_select": [
      "TempClass"
      ]
      }
      },
      "CleanUp": {
      "action": "sliceDataset",
      "parameters": {
      "mode": "drop",
      "fields": [
      {
      "name": "HighTemp"
      },
      {
      "name": "LowTemp"
      },
      {
      "name": "TempClass"
      }
      ],
      "source": "Augment Temp Class"
      }
      },
      "Create Seed Bank": {
      "action": "sfdcRegister",
      "parameters": {
      "source": "CleanUp",
      "alias": "Seed_Bank",
      "name": "Seed Bank"
      }
      }
      }

      Delete
    8. Trailhead BabyMay 19, 2020 at 8:20 AM

      "Create Seed Bank": {
      "action": "sfdcRegister",
      "parameters": {
      "source": "CleanUp",
      "alias": "Seed_Bank",
      "name": "Seed Bank"

      alias punctuation.

      Delete
    9. UnknownMay 20, 2020 at 1:44 AM

      Thank you so much Rebeca, My step 6 is resolved finally today. i have completed my step 7 already but could not proceed because of step 6 issues. I have finally made the super badge today ! yipeeeee !

      Delete
    10. Trailhead BabyMay 20, 2020 at 8:57 AM

      woooohooo!!!!!!

      Delete
  26. ShruthiMay 15, 2020 at 2:57 PM

    Can anyone please help on Step 4. PFB for the json
    {
    "Calculate Acreage": {
    "action": "computeExpression",
    "parameters": {
    "source": "Load Seed Chart",
    "mergeWithSource": true,
    "computedFields": [
    {
    "precision": 18,
    "saqlExpression": " (Seeds_Pound*Spacing)/6272640",
    "name": "Acreage",
    "scale": 6,
    "label": "Acreage",
    "type": "Numeric"
    }
    ]
    }
    },
    "Create Seed Bank": {
    "action": "sfdcRegister",
    "parameters": {
    "name": "Seed Bank",
    "alias": "Seed_Chart",
    "source": "Calculate Acreage"
    }
    },
    "Load Seed Chart": {
    "action": "edgemart",
    "parameters": {
    "alias": "Seed_Chart"
    }
    }
    }

    I am getting the below error even after adding the lens correctly.
    We can't find the Seed Bank dataset or required fields are missing. Check the challenge and confirm the node name and required fields.

    ReplyDelete
    Replies
    1. UnknownMay 16, 2020 at 9:45 AM

      @shruthi

      "name": "Seed Bank",
      "alias": "Seed_Chart",

      alias has to be Seed_Bank as well , let me know if that works out !

      Delete
    2. ShruthiMay 18, 2020 at 5:27 AM

      No Even after that it is not working it says We can't find the 'Load Seed Chart' node in the dataflow. Confirm the node name matches the name as described in the challenge.

      Delete
    3. UnknownMay 19, 2020 at 7:35 AM

      Name and alias element are really painful with this challenges i had this worked out by trial and error method and it worked back then, please try below and let me know if that knows

      "name": "Seed Chart",
      "alias": "Seed_Chart",

      Delete
    4. BalajiMay 21, 2020 at 2:01 AM

      @Shruthi, did you got the issue fixed? Can you please let me know what was the root cause?

      Delete
  27. UnknownMay 16, 2020 at 9:44 AM

    This comment has been removed by the author.

    ReplyDelete
  28. UnknownMay 17, 2020 at 7:23 AM

    Getting the following warning when running the dataflow:
    Load Seed Bank Agencies w/Climate Data

    The dataflow was completed, but the LookupSingleValue node didn't augment any columns. Either the node didn't find any matches, or a join key contains only null values.

    Add Agency Fields augment Less than 1 second success 1,384 0
    1,384 0

    Filter 2015 filter Less than 1 second success 31,200 0
    0 0

    ID Agency Records computeExpression Less than 1 second success 1,384 0
    1,384 0

    Temp Class computeExpression Less than 1 second success 0 0
    0 0

    Filter Agency Records filter Less than 1 second success 1,384 0
    383 0

    Augment TempClass augment Less than 1 second warning 0 0
    0 0

    optimize-Create Seed Bank Agencies optimizer Less than 1 second success 0 0
    0 0

    Create Seed Bank Agencies sfdcRegister 40 seconds success 0 0
    0 0



    ReplyDelete
  29. UnknownMay 17, 2020 at 11:26 PM

    This comment has been removed by the author.

    ReplyDelete
    Replies
    1. UnknownMay 17, 2020 at 11:26 PM

      This comment has been removed by the author.

      Delete
  30. GabrieleMay 18, 2020 at 12:03 PM

    Hi, i'm stuck at #4.
    I get the error We can't find the Seed Bank dataset or required fields are missing. Check the challenge and confirm the node name and required fields.
    I'm checking the Dataflow Alias: Seed Bank Name: Seed_Bank and seems ok to me, but i guess i'm wrong in a way i don't understand. If someone could be so kind to support, that would really be helpful.
    Thanks a lot.

    ReplyDelete
    Replies
    1. GabrieleMay 18, 2020 at 12:04 PM

      Just in case my JSON
      {
      "Load Seed Chart": {
      "action": "edgemart",
      "parameters": {
      "alias": "Seed_Chart"
      }
      },
      "Calculate Acreage": {
      "action": "computeExpression",
      "parameters": {
      "mergeWithSource": true,
      "source": "Load Seed Chart",
      "computedFields": [
      {
      "type": "Numeric",
      "name": "Acreage",
      "label": "Acreage",
      "saqlExpression": "(Seeds_Pound*Spacing)/6272640",
      "precision": 18,
      "scale": 6
      }
      ]
      }
      },
      "Create Seed Bank": {
      "action": "sfdcRegister",
      "parameters": {
      "source": "Calculate Acreage",
      "alias": "Seed Bank",
      "name": "Seed_Bank"
      }
      }
      }

      Delete
    2. Trailhead BabyMay 18, 2020 at 12:23 PM

      "Create Seed Bank": {
      "action": "sfdcRegister",
      "parameters": {
      "source": "Calculate Acreage",
      "alias": "Seed Bank",
      "name": "Seed_Bank"

      Wrong alias and name....

      Delete
    3. GabrieleMay 18, 2020 at 12:27 PM

      First of all , thanks for prompt reply. Appreciated! Sorry but where i can get the right alias and name, and this goes beyond the question. In the superbadge there's no indication of what naming convention to follow. If you could kindly give me some insight as i fear i'm missing something here. Thanks!

      Delete
    4. GabrieleMay 18, 2020 at 12:52 PM

      I understood! Beside changing the alias and name the thing i wasn't realizing is that the process was creating a dataset... but in the SHARED APP! What a sun of gun... i had to change the dataset association and now works!! Anyway, sorry for bothering. Thanks a lot!

      Delete
    5. Trailhead BabyMay 18, 2020 at 1:39 PM

      Good!! I am so glad you figured it out!

      Delete
  31. GabrieleMay 19, 2020 at 10:08 AM

    This comment has been removed by the author.

    ReplyDelete
    Replies
    1. GabrieleMay 19, 2020 at 10:10 AM

      This comment has been removed by the author.

      Delete
    2. GabrieleMay 19, 2020 at 10:11 AM

      This comment has been removed by the author.

      Delete
  32. काजवाMay 19, 2020 at 11:58 AM

    This comment has been removed by the author.

    ReplyDelete
  33. SouravMay 24, 2020 at 6:38 AM

    {
    "Calculate Acreage": {
    "action": "computeExpression",
    "parameters": {
    "mergeWithSource": true,
    "computedFields": [
    {
    "precision": 18,
    "saqlExpression": "(Seeds_Pound*Spacing)/6272640 ",
    "name": "Acreage",
    "scale": 6,
    "label": "Acreage",
    "type": "Numeric"
    }
    ],
    "source": "Load Seed Chart"
    }
    },
    "Create Seed Bank": {
    "action": "sfdcRegister",
    "parameters": {
    "name": "Seed Bank",
    "alias": "seed_bank",
    "source": "Calculate Acreage"
    }
    },
    "Load Seed Chart": {
    "action": "edgemart",
    "parameters": {
    "alias": "Seed_Bank1"
    }
    }
    }


    The above on the json for my dataflow.By using the dataset i am not able to create the lens.I cant see Sum | Acreage.Can Any one help me on this

    ReplyDelete
    Replies
    1. AnkitaMay 25, 2020 at 2:25 PM

      I am also stuck in Challenge4. Getting below error. I am not able to find out where i missed.
      If anyone knows please help me.
      Challenge Not yet complete... here's what's wrong:
      We can't find the Acreage field. Check the challenge and confirm required field setting.
      {
      "Load Seed Chart": {
      "action": "edgemart",
      "parameters": {
      "alias": "Seed_Chart"
      }
      },
      "Calculate Acerage": {
      "action": "computeExpression",
      "parameters": {
      "source": "Load Seed Chart",
      "mergeWithSource": true,
      "computedFields": [
      {
      "precision": 18,
      "name": "Acreage",
      "saqlExpression": "(Seeds_Pound*Spacing)/6272640",
      "scale": 6,
      "label": "Acreage",
      "type": "Numeric"
      }
      ]
      }
      },
      "Create Seed Bank": {
      "action": "sfdcRegister",
      "parameters": {
      "name": "Seed Bank",
      "alias": "Seed_Bank",
      "source": "Calculate Acerage"
      }
      }
      }

      It will be helpful for me if someone tells me why I am getting this.

      Delete
    2. Trailhead BabyMay 26, 2020 at 9:28 AM

      Alias - is incorrect. (It's a capitalization issue)
      },
      "Create Seed Bank": {
      "action": "sfdcRegister",
      "parameters": {
      "name": "Seed Bank",
      "alias": "Seed_Bank",
      "source": "Calculate Acerage"

      Delete
  34. Sumanth1494May 28, 2020 at 7:07 AM

    Hi,

    I am stuck in step 6 Load Seed Bank Agencies w/Climate Data while running the data flow.
    Below is the Error

    Something went wrong while executing the Augment TempClass node: Duplicate field TempClass (02K2x000000EEiPEAW_03C2x000000BNimEAG)

    Below is the Json :

    {
    "Add Temp Class": {
    "action": "computeExpression",
    "parameters": {
    "source": "Filter 2015",
    "mergeWithSource": true,
    "computedFields": [
    {
    "defaultValue": "Continental",
    "name": "TempClass",
    "saqlExpression": "case when Temperature < 25 then \"Polar\" when Temperature >=25 and Temperature <=50 then \"Cool\" when Temperature >=51 and Temperature <=85 then \"Continental\" when Temperature > 85 then \"Tropical\" end",
    "label": "TempClass",
    "type": "Text"
    }
    ]
    }
    },
    "Create Seed Bank Agencies": {
    "action": "sfdcRegister",
    "parameters": {
    "name": "Seed Bank Agencies",
    "alias": "seed_bank_agencies",
    "source": "Augment TempClass"
    }
    },
    "Load Climate": {
    "action": "edgemart",
    "parameters": {
    "alias": "Global_Climates"
    }
    },
    "Load Seed Bank Agencies": {
    "action": "edgemart",
    "parameters": {
    "alias": "seed_bank_agencies"
    }
    },
    "Filter 2015": {
    "action": "filter",
    "parameters": {
    "filter": "Date_Year:R:2015",
    "source": "Load Climate"
    }
    },
    "Augment TempClass": {
    "action": "augment",
    "parameters": {
    "left": "Load Seed Bank Agencies",
    "right": "Add Temp Class",
    "relationship": "Climate",
    "operation": "LookupSingleValue",
    "left_key": [
    "ShippingCountry"
    ],
    "right_key": [
    "Country"
    ],
    "right_select": [
    "TempClass"
    ]
    }
    }
    }

    ReplyDelete
    Replies
    1. Trailhead BabyMay 28, 2020 at 9:09 AM

      },
      "Augment TempClass": {
      "action": "augment",
      "parameters": {
      "left": "Load Seed Bank Agencies",
      "right": "Add Temp Class",
      "relationship": "Climate",
      "operation": "LookupSingleValue",
      "left_key": [
      "ShippingCountry"
      ],
      "right_key": [
      "Country"
      ],
      "right_select": [
      "TempClass"

      This is not correct.

      Delete
    2. Sumanth1494May 29, 2020 at 5:51 AM

      Tried this

      },
      "Augment TempClass": {
      "action": "augment",
      "parameters": {
      "right_key": [
      "Country"
      ],
      "left": "Load Seed Bank Agencies",
      "left_key": [
      "ShippingCountry"
      ],
      "right_select": [
      "TempClass"
      ],
      "right": "Add Temp Class",
      "relationship": "Climate",
      "operation": "LookupSingleValue"

      But Still throwing the same error.

      Delete
    3. Sumanth1494May 29, 2020 at 6:41 AM

      "Augment TempClass": {
      "action": "augment",
      "parameters": {
      "left": "Filter 2015",
      "right": "Add Temp Class",
      "relationship": "Climate",
      "operation": "LookupSingleValue",
      "left_key": [
      "Country"
      ],
      "right_key": [
      "Country"
      ],
      "right_select": [
      "TempClass",
      "Country",
      "Date",
      "Temperature"

      This Worked. Thanks much :)

      Delete
  35. ChinmayaMay 28, 2020 at 11:38 PM

    Hi I am getting the bellow error. And correct me if i am wrong any where.
    Challenge Not yet complete... here's what's wrong:
    We can't find the Seed Bank dataset or required fields are missing. Check the challenge and confirm the node name and required fields.

    Below is my JSON details.

    {
    "Calculate Acreage": {
    "action": "computeExpression",
    "parameters": {
    "source": "Seed Chart",
    "mergeWithSource": true,
    "computedFields": [
    {
    "precision": 18,
    "name": "Acreage",
    "saqlExpression": " (Seeds_Pound*Spacing)/6272640",
    "scale": 6,
    "label": "Acreage",
    "type": "Numeric"
    }
    ]
    }
    },
    "Seed Bank": {
    "action": "sfdcRegister",
    "parameters": {
    "rowLevelSecurityFilter": "",
    "name": "seedbank",
    "alias": "seedbank",
    "source": "Calculate Acreage"
    }
    },
    "Seed Chart": {
    "action": "edgemart",
    "parameters": {
    "alias": "Seed_Chart"
    }
    }
    }

    ReplyDelete
    Replies
    1. Sumanth1494May 29, 2020 at 6:39 AM

      This comment has been removed by the author.

      Delete
    2. Trailhead BabyMay 29, 2020 at 8:38 AM

      },
      "Seed Bank": {
      "action": "sfdcRegister",
      "parameters": {
      "rowLevelSecurityFilter": "",
      "name": "seedbank",
      "alias": "seedbank",
      "source": "Calculate Acreage"

      Wrong alias and name

      Delete
    3. Trailhead BabyMay 29, 2020 at 8:39 AM

      and wrong parameters

      Delete
  36. ChinmayaMay 29, 2020 at 2:41 PM

    This comment has been removed by the author.

    ReplyDelete
  37. CJJune 17, 2020 at 9:53 PM

    Hi all
    I am having a really hard time with Step 6. I made it through all of the tempkey/temp class definitions, and everything appears to run fine but when I go to check the step in trailhead I get this "We can't validate the 'Create Seed Bank Agencies' node was created correctly" error. I've recreated the steps a number of times, and I am pretty sure all of my nomenclature is correct. I can't find any instance of this same error anywhere. Has anyone seen this?

    CJ

    ReplyDelete
    Replies
    1. Trailhead BabyJune 18, 2020 at 9:03 AM

      I will take a look at the JSON if you post it

      Delete
    2. CJJune 18, 2020 at 3:24 PM

      {"AddTempClass":{
      "action":"computeExpression",
      "parameters":{
      "source":"Filter2015",
      "mergeWithSource":true,
      "computedFields":[
      {
      "defaultValue":"Continental",
      "name":"TempClass",
      "saqlExpression":"casewhenTemperature<25then\"Polar\"whenTemperature>=25andTemperature<=50then\"Cool\"whenTemperature>=51andTemperature<=85then\"Continental\"whenTemperature>85then\"Tropical\"end",
      "label":"TempClass",
      "type":"Text"
      }
      ]
      }
      },
      "FilterAgencyRecords":{
      "action":"filter",
      "parameters":{
      "filter":"ISAgency:EQ:TRUE",
      "source":"IDAgencyRecords"
      }
      },
      "LoadAccount":{
      "action":"sfdcDigest",
      "parameters":{
      "fields":[
      {
      "name":"AccountNumber"
      },
      {
      "name":"Name"
      },
      {
      "name":"Phone"
      },
      {
      "name":"ShippingCity"
      },
      {
      "name":"ShippingCountry"
      },
      {
      "name":"ShippingPostalCode"
      },
      {
      "name":"ShippingState"
      },
      {
      "name":"ShippingStreet"
      }
      ],
      "object":"Account"
      }
      },
      "CreateSeedBankAgencies":{
      "action":"sfdcRegister",
      "parameters":{
      "name":"SeedBankAgencies",
      "alias":"seed_bank_agencies",
      "source":"AugmentTempClass"
      }
      },
      "LoadClimate":{
      "action":"edgemart",
      "parameters":{
      "alias":"global_climates"
      }
      },
      "AddAgencyFields":{
      "action":"augment",
      "parameters":{
      "right_key":[
      "AccountNumber"
      ],
      "left":"LoadAccount",
      "left_key":[
      "AccountNumber"
      ],
      "right_select":[
      "Acres",
      "Currency",
      "Latitude",
      "Longitude",
      "Region",
      "SubRegion"
      ],
      "right":"LoadAgencyDetail",
      "relationship":"AgencyDetail",
      "operation":"LookupSingleValue"
      }
      },
      "Filter2015":{
      "action":"filter",
      "parameters":{
      "filter":"Date_Year:R:2015",
      "source":"LoadClimate"
      }
      },
      "AugmentTempClass":{
      "action":"augment",
      "parameters":{
      "right_key":[
      "Country"
      ],
      "left":"FilterAgencyRecords",
      "left_key":[
      "ShippingCountry"
      ],
      "right_select":[
      "TempClass",
      "Country",
      "Date"
      ],
      "right":"AddTempClass",
      "relationship":"Climate",
      "operation":"LookupSingleValue"
      }
      },
      "LoadAgencyDetail":{
      "action":"edgemart",
      "parameters":{
      "alias":"Agency_Detail"
      }
      },
      "IDAgencyRecords":{
      "action":"computeExpression",
      "parameters":{
      "source":"AddAgencyFields",
      "mergeWithSource":true,
      "computedFields":[
      {
      "saqlExpression":"casewhenPhoneisnotnullthen\"TRUE\"else\"FALSE\"end",
      "name":"ISAgency",
      "label":"ISAgency",
      "type":"Text"
      }
      ]
      }
      }
      }

      Delete
    3. CJJune 18, 2020 at 3:25 PM

      Thank you for the quick reply! Looks like Naveen is having the same issue below! I guess I am glad I am not the only one? Lol

      Delete
    4. Trailhead BabyJune 19, 2020 at 10:12 AM

      },
      "AddAgencyFields":{
      "action":"augment",
      "parameters":{
      "right_key":[
      "AccountNumber"
      ],
      "left":"LoadAccount",
      "left_key":[
      "AccountNumber"
      ],
      "right_select":[
      "Acres",
      "Currency",
      "Latitude",
      "Longitude",
      "Region",
      "SubRegion"
      ],

      --- Can't match on field that is not in both data sets. :)

      Delete
    5. CJJune 22, 2020 at 7:49 PM

      I don't understand what you mean. Can you elaborate? This part is the JSON from the original Load Seed Bank challenge which executed without error.

      Delete
    6. Trailhead BabyJune 23, 2020 at 1:07 PM

      I'll look again through it... Are your Latitude and Longitude uploads dimensions or measures?

      Delete
    7. Trailhead BabyJune 23, 2020 at 1:12 PM

      },
      "CreateSeedBankAgencies":{
      "action":"sfdcRegister",
      "parameters":{
      "name":"SeedBankAgencies",
      "alias":"seed_bank_agencies",
      "source":"AugmentTempClass"

      I have different spacing in the name.

      My original thought was with the "augument" step- because I have seen this throw errors a ton of times if "account number" was not explicitly selected in both data sets. (IE- I don't see it in your right select)

      I also have one additional character in this SAQL

      "saqlExpression":"casewhenPhoneisnotnullthen\"TRUE\"else\"FALSE\"end",

      Delete
    8. CJJune 23, 2020 at 3:03 PM

      Eureka! It was the Long/Lat settings in the Agency Detail upload. How frustrating! I couldn't get through challenge 3 because I changed them to dimensions, and then now I had to change them back! On to the next error LOL

      Delete
  38. Naveen kumar singhJune 18, 2020 at 12:24 PM

    Hi All,
    I am having a really hard time with Step 6. I made it through all of the tempkey/temp class definitions, and everything appears to run fine but when I go to check the step in trailhead I get this "We can't validate the 'Create Seed Bank Agencies' node was created correctly" error.

    My JSON :
    {
    "Add Temp Class": {
    "action": "computeExpression",
    "parameters": {
    "source": "Filter 2015",
    "mergeWithSource": true,
    "computedFields": [
    {
    "defaultValue": "Continental",
    "name": "TempClass",
    "saqlExpression": "case when Temperature < 25 then \"Polar\" when Temperature >= 25 and Temperature <= 50 then \"Cool\" when Temperature >=51 and Temperature <=85 then \"Continental\" when Temperature > 85 then \"Tropical\" end",
    "label": "TempClass",
    "type": "Text"
    }
    ]
    }
    },
    "Create Seed Bank Agencies": {
    "action": "sfdcRegister",
    "parameters": {
    "name": "Seed Bank Agencies",
    "alias": "seed_bank_agencies",
    "source": "Augment TempClass"
    }
    },
    "Load Climate": {
    "action": "edgemart",
    "parameters": {
    "alias": "Global_Climates"
    }
    },
    "Load Seed Bank Agencies": {
    "action": "edgemart",
    "parameters": {
    "alias": "seed_bank_agencies"
    }
    },
    "Filter 2015": {
    "action": "filter",
    "parameters": {
    "filter": "Date_Year:R:2015",
    "source": "Load Climate"
    }
    },
    "Augment TempClass": {
    "action": "augment",
    "parameters": {
    "right_key": [
    "Country"
    ],
    "left": "Load Seed Bank Agencies",
    "left_key": [
    "ShippingCountry"
    ],
    "right_select": [
    "TempClass"
    ],
    "right": "Add Temp Class",
    "relationship": "Climate",
    "operation": "LookupSingleValue"
    }
    }
    }

    ReplyDelete
    Replies
    1. Trailhead BabyJune 19, 2020 at 10:17 AM

      It looks like the order of operations is a tiny bit out of order.
      },
      "Augment TempClass": {
      "action": "augment",
      "parameters": {
      "right_key": [
      "Country"
      ],
      "left": "Load Seed Bank Agencies",
      "left_key": [
      "ShippingCountry"
      ],
      "right_select": [
      "TempClass"


      My "left": "Load Seed Bank Agencies", is different plus several additional right select items.

      Delete
    2. Naveen kumar singhJune 20, 2020 at 2:12 AM

      Can you post your Json?

      Delete
  39. Maulik VadodariyaJune 20, 2020 at 1:53 PM

    I have invested a lot of time solving the step 6 but seems no luck from last 2 weeks.

    Challenge Not yet complete... here's what's wrong:
    We can't validate the 'Create Seed Bank Agencies' node was created correctly. Check the required fields, field types, node name, and alias are correct.

    Posting json in 2 parts...

    {
    "Add Temp Class": {
    "action": "computeExpression",
    "parameters": {
    "source": "Filter 2015",
    "mergeWithSource": true,
    "computedFields": [
    {
    "defaultValue": "Continental",
    "name": "TempClass",
    "saqlExpression": "case when Temperature < 25 then \"Polar\" when Temperature >= 25 and Temperature <= 50 then \"Cool\" when Temperature >= 51 and Temperature <= 85 then \"Continental\" when Temperature > 85 then \"Tropical\" end",
    "label": "TempClass",
    "type": "Text"
    }
    ]
    }
    },
    "Filter Agency Records": {
    "action": "filter",
    "parameters": {
    "filter": "IsAgency:EQ:TRUE",
    "source": "ID Agency Records"
    }
    },
    "Load Account": {
    "action": "sfdcDigest",
    "parameters": {
    "fields": [
    {
    "name": "AccountNumber"
    },
    {
    "name": "Name"
    },
    {
    "name": "Phone"
    },
    {
    "name": "ShippingCity"
    },
    {
    "name": "ShippingCountry"
    },
    {
    "name": "ShippingPostalCode"
    },
    {
    "name": "ShippingState"
    },
    {
    "name": "ShippingStreet"
    }
    ],
    "object": "Account"
    }
    },
    "Augment Temp Class": {
    "action": "augment",
    "parameters": {
    "right_key": [
    "Country"
    ],
    "left": "Filter Agency Records",
    "left_key": [
    "ShippingCountry"
    ],
    "right_select": [
    "Country",
    "Date",
    "Temperature",
    "TempClass"
    ],
    "right": "Add Temp Class",
    "relationship": "Climate",
    "operation": "LookupSingleValue"
    }
    },
    "Create Seed Bank Agencies": {
    "action": "sfdcRegister",
    "parameters": {
    "name": "Seed Bank Agencies",
    "alias": "seed_bank_agencies",
    "source": "Augment Temp Class"
    }
    },
    "Load Climate": {
    "action": "edgemart",
    "parameters": {
    "alias": "Global_Climates"
    }
    },

    ReplyDelete
  40. Maulik VadodariyaJune 20, 2020 at 1:53 PM

    "Add Agency Fields": {
    "action": "augment",
    "parameters": {
    "right_key": [
    "AccountNumber"
    ],
    "left": "Load Account",
    "left_key": [
    "AccountNumber"
    ],
    "right_select": [
    "Currency",
    "Acres",
    "Latitude",
    "Longitude",
    "Region",
    "SubRegion"
    ],
    "right": "Load Agency Detail",
    "relationship": "AgencyDetail",
    "operation": "LookupSingleValue"
    }
    },
    "Filter 2015": {
    "action": "filter",
    "parameters": {
    "filter": "Date_Year:EQ:2015",
    "source": "Load Climate"
    }
    },
    "Load Agency Detail": {
    "action": "edgemart",
    "parameters": {
    "alias": "Agency_Detail"
    }
    },
    "ID Agency Records": {
    "action": "computeExpression",
    "parameters": {
    "source": "Add Agency Fields",
    "mergeWithSource": true,
    "computedFields": [
    {
    "name": "IsAgency",
    "saqlExpression": "case when Phone is not null then \"TRUE\" else \"FALSE\" end\n",
    "label": "IsAgency",
    "type": "Text"
    }
    ]
    }
    }
    }

    ReplyDelete
    Replies
    1. Trailhead BabyJune 22, 2020 at 9:58 AM

      "Add Agency Fields": {
      "action": "augment",
      "parameters": {
      "right_key": [
      "AccountNumber"
      ],
      "left": "Load Account",
      "left_key": [
      "AccountNumber"
      ],
      "right_select": [
      "Currency",
      "Acres",
      "Latitude",
      "Longitude",
      "Region",
      "SubRegion"

      Missing something here

      Delete
  41. Naveen kumar singhJune 22, 2020 at 10:01 AM

    @Trailhead Baby Can you post your JSON for the same?

    ReplyDelete
    Replies
    1. Trailhead BabyJune 22, 2020 at 11:41 AM

      No. That is against Trailhead's terms of use. I'm happy to look at what you have and make suggestions.

      Delete
  42. Naveen kumar singhJune 23, 2020 at 7:08 AM

    @Maulik Vadodariya Just follow instruction .My issue been resolved .
    https://success.salesforce.com/answers?id=9063A000000lixEQAQ

    ReplyDelete
  43. AnonymousJune 28, 2020 at 6:51 AM

    I am so lost on step 6. I have the same nodes as you. Getting the below error:
    Challenge Not yet complete... here's what's wrong:
    We can't validate the 'Create Seed Bank Agencies' node was created correctly. Check the required fields, field types, node name, and alias are correct.

    here is my json
    Einstein
    Data Manager
    Load Seed Bank Agencies w/Climate Data
    DATAFLOW
    Load Seed Bank Agencies w/Climate Data

    Run Dataflow
    JSON for 'Load Seed Bank Agencies w/Climate Data'

    Download JSON
    {
    "Add Temp Class": {
    "action": "computeExpression",
    "parameters": {
    "source": "Filter 2015",
    "mergeWithSource": true,
    "computedFields": [
    {
    "defaultValue": "Continental",
    "name": "TempClass",
    "saqlExpression": "case when Temperature < 25 then \"Polar\" when Temperature >= 25 and Temperature <= 50 then \"Cool\" when Temperature >= 51 and Temperature <= 85 then \"Continental\" when Temperature > 85 then \"Tropical\" end",
    "label": "TempClass",
    "type": "Text"
    }
    ]
    }
    },

    Any help is really helpful.

    Regards
    Sri

    ReplyDelete
  44. AnonymousJune 28, 2020 at 6:51 AM

    "Filter Agency Records": {
    "action": "filter",
    "parameters": {
    "filter": "IsAgency:EQ:TRUE",
    "source": "ID Agency Records"
    }
    },
    "Load Account": {
    "action": "sfdcDigest",
    "parameters": {
    "fields": [
    {
    "name": "AccountNumber"
    },
    {
    "name": "Name"
    },
    {
    "name": "Phone"
    },
    {
    "name": "ShippingCity"
    },
    {
    "name": "ShippingCountry"
    },
    {
    "name": "ShippingPostalCode"
    },
    {
    "name": "ShippingState"
    },
    {
    "name": "ShippingStreet"
    }
    ],
    "object": "Account"
    }
    },
    "Create Seed Bank Agencies": {
    "action": "sfdcRegister",
    "parameters": {
    "name": "Seed Bank Agencies",
    "alias": "seed_bank_agencies",
    "source": "Augment TempClass"
    }
    },
    "Load Climate": {
    "action": "edgemart",
    "parameters": {
    "alias": "Global_Climates"
    }
    },
    "Add Agency Fields": {
    "action": "augment",
    "parameters": {
    "right_key": [
    "AccountNumber"
    ],
    "left": "Load Account",
    "left_key": [
    "AccountNumber"
    ],
    "right_select": [
    "Acres",
    "Currency",
    "Latitude",
    "Longitude",
    "Region",
    "SubRegion"
    ],
    "right": "Load Agency Detail",
    "relationship": "AgencyDetail",
    "operation": "LookupSingleValue"
    }
    },
    "Filter 2015": {
    "action": "filter",
    "parameters": {
    "filter": "Date_Year:EQ:2015",
    "source": "Load Climate"
    }
    },
    "Augment TempClass": {
    "action": "augment",
    "parameters": {
    "right_key": [
    "Country"
    ],
    "left": "Filter Agency Records",
    "left_key": [
    "ShippingCountry"
    ],
    "right_select": [
    "Country",
    "Date",
    "TempClass",
    "Temperature"
    ],
    "right": "Add Temp Class",
    "relationship": "Climate",
    "operation": "LookupSingleValue"
    }
    },
    "Load Agency Detail": {
    "action": "edgemart",
    "parameters": {
    "alias": "Agency_Detail"
    }
    },
    "ID Agency Records": {
    "action": "computeExpression",
    "parameters": {
    "source": "Add Agency Fields",
    "mergeWithSource": true,
    "computedFields": [
    {
    "name": "IsAgency",
    "saqlExpression": "case when Phone is not null then \"TRUE\" else \"FALSE\" end",
    "label": "IsAgency",
    "type": "Text"
    }
    ]
    }
    }
    }
    Close
    Search nodes...
    hidden

    ReplyDelete
    Replies
    1. Trailhead BabyJune 29, 2020 at 10:07 AM

      "Add Agency Fields": {
      "action": "augment",
      "parameters": {
      "right_key": [
      "AccountNumber"
      ],
      "left": "Load Account",
      "left_key": [
      "AccountNumber"
      ],
      "right_select": [
      "Acres",
      "Currency",
      "Latitude",
      "Longitude",
      "Region",
      "SubRegion"

      I have something additional in "right select"

      Delete
    2. Trailhead BabyJune 29, 2020 at 10:08 AM

      And slightly different saql
      "name": "IsAgency",
      "saqlExpression": "case when Phone is not null then \"TRUE\" else \"FALSE\" end",
      "label": "IsAgency",
      "type": "Text"

      Delete
  45. Ananya sethiJuly 2, 2020 at 7:16 AM

    hi, i am getting the following error in challenge six,load seed bank w/climate data dataflow - Something went wrong while executing the Augment TempClass node: Duplicate field TempClass (02K2x000000ZIJLEA4_03C2x000000baEEEAY)

    i don't see a duplicate,could you help me out.

    here is my JSON:

    {
    "Load Climate": {
    "action": "edgemart",
    "parameters": {
    "alias": "Global_Climates"
    }
    },
    "Filter 2015": {
    "action": "filter",
    "parameters": {
    "source": "Load Climate",
    "filter": "Date_Year:R:2015"
    }
    },
    "Add TempClass": {
    "action": "computeExpression",
    "parameters": {
    "mergeWithSource": true,
    "source": "Filter 2015",
    "computedFields": [
    {
    "type": "Text",
    "name": "TempClass",
    "label": "TempClass",
    "saqlExpression": "case when Temperature < 25 then \"Polar\" when Temperature >= 25 and Temperature <=50 then \"Cool\" when Temperature >= 51 and Temperature <= 85 then \"Continental\" when Temperature > 85 then \"Tropical\" end",
    "defaultValue": "Continental"
    }
    ]
    }
    },
    "Load Seed Bank Agencies": {
    "action": "edgemart",
    "parameters": {
    "alias": "seed_bank_agencies"
    }
    },
    "Augment TempClass": {
    "action": "augment",
    "parameters": {
    "operation": "LookupSingleValue",
    "left": "Load Seed Bank Agencies",
    "relationship": "Climate",
    "right": "Add TempClass",
    "left_key": [
    "Country"
    ],
    "right_key": [
    "Country"
    ],
    "right_select": [
    "TempClass"
    ]
    }
    },
    "Create Seed Bank Agencies": {
    "action": "sfdcRegister",
    "parameters": {
    "source": "Augment TempClass",
    "alias": "seed_bank_agencies",
    "name": "Seed Bank Agencies"
    }
    }
    }

    ReplyDelete
    Replies
    1. Trailhead BabyJuly 2, 2020 at 11:58 AM

      hmm I have a different left node for augment temp class
      (left": "Load Seed Bank Agencies")

      Delete
    2. Ananya sethiJuly 2, 2020 at 1:29 PM

      i tried switching them and the dataflow was successful. thanks a lot.

      Delete
  46. SimranSeptember 27, 2020 at 1:41 PM

    Hey,
    Hope by this time you have got your answer if not,

    Please change the alias you will get through challenge 6.

    ReplyDelete
  47. MichaelNovember 19, 2020 at 7:17 AM

    Hi, I am getting the message: Something went wrong while executing the Augment Temp Class node: Duplicate field TempClass
    Can you help me with my JSON? Thanks in Advance (split in 2 for upload reasons)

    {
    "Load Temp Class Mapping": {
    "action": "edgemart",
    "parameters": {
    "alias": "Temperature_Classes_Mapping"
    }
    },
    "Load Seed Bank": {
    "action": "edgemart",
    "parameters": {
    "alias": "seed_bank"
    }
    },
    "Define Temp Range": {
    "action": "computeExpression",
    "parameters": {
    "mergeWithSource": true,
    "source": "Load Seed Bank",
    "computedFields": [
    {
    "type": "Numeric",
    "name": "lowTemp",
    "label": "lowTemp",
    "saqlExpression": "string_to_number(substr(Temperature,1,2))",
    "precision": 18,
    "scale": 6
    },
    {
    "type": "Numeric",
    "name": "highTemp",
    "label": "highTemp",
    "saqlExpression": "string_to_number(substr(Temperature,-2,2))",
    "precision": 18,
    "scale": 6
    }
    ]
    }
    },
    "Add Temp Class": {
    "action": "computeExpression",
    "parameters": {
    "mergeWithSource": true,
    "source": "Define Temp Range",
    "computedFields": [
    {
    "type": "Text",
    "name": "TempClass",
    "label": "TempClass",
    "saqlExpression": "\"case \\nwhen lowTemp < 25 and highTemp < 25 then \\\"Polar\\\" \\nwhen lowTemp >= 25 and lowTemp <= 50 and highTemp >= 25 and highTemp <= 50 then \\\"Cool\\\"\\nwhen lowTemp >= 51 and lowTemp <= 85 and highTemp >= 51 and highTemp <= 85 then \\\"Continental\\\"\\nwhen lowTemp > 85 and highTemp > 85 then \\\"Tropical\\\"\\nwhen lowTemp < 25 and (highTemp >= 25 and highTemp <= 50) then \\\"Polar-Cool\\\" \\nwhen lowTemp < 25 and (highTemp >= 25 and highTemp <= 85) then \\\"Polar-Cool-Continental\\\" \\nwhen lowTemp < 25 and highTemp > 85 then \\\"Polar-Cool-Continental-Tropical\\\" \\nwhen (lowTemp >= 25 and lowTemp <= 50) and (highTemp >= 51 and highTemp <= 85) then \\\"Cool-Continental\\\" \\nwhen (lowTemp >= 25 and lowTemp <= 50) and highTemp >= 85 then \\\"Cool-Continental-Tropical\\\" \\nwhen (lowTemp >= 51 and lowTemp <= 85) and highTemp > 85 then \\\"Continental-Tropical\\\" \\nend\""
    }
    ]
    }
    },

    ReplyDelete
  48. MichaelNovember 19, 2020 at 7:17 AM

    Second part:

    "CleanUp": {
    "action": "sliceDataset",
    "parameters": {
    "mode": "drop",
    "fields": [
    {
    "name": "highTemp"
    },
    {
    "name": "lowTemp"
    },
    {
    "name": "TempClass"
    }
    ],
    "source": "Augment Temp Class"
    }
    },
    "Create Seed Bank": {
    "action": "sfdcRegister",
    "parameters": {
    "source": "CleanUp",
    "alias": "seed_bank",
    "name": "Seed Bank"
    }
    },
    "Augment Temp Class": {
    "action": "augment",
    "parameters": {
    "operation": "LookupSingleValue",
    "left": "Add Temp Class",
    "left_key": [
    "TempClass"
    ],
    "relationship": "Climate",
    "right": "Load Temp Class Mapping",
    "right_key": [
    "TempKey"
    ],
    "right_select": [
    "TempClass"
    ]
    }
    }
    }

    ReplyDelete
  49. Trailblazer GERNovember 24, 2020 at 11:45 AM

    Following error:
    Challenge Not yet complete... here's what's wrong:
    We can't validate the 'Create Seed Bank Agencies' node was created correctly. Check the required fields, field types, node name, and alias are correct.

    {
    "Add Temp Class": {
    "action": "computeExpression",
    "parameters": {
    "source": "Filter 2015",
    "mergeWithSource": true,
    "computedFields": [
    {
    "defaultValue": "Continental",
    "saqlExpression": "case when Temperature < 25 then \"Polar\" \nwhen Temperature >= 25 and Temperature <= 50 then \"Cool\" when Temperature >= 51 and Temperature <= 85 then \"Continental\" \nwhen Temperature > 85 then \"Tropical\" \nend",
    "name": "TempClass",
    "label": "TempClass",
    "type": "Text"
    }
    ]
    }
    },
    "Filter Agency Records": {
    "action": "filter",
    "parameters": {
    "filter": "IsAgency:EQ:TRUE",
    "source": "ID Agency Records"
    }
    },
    "Load Account": {
    "action": "sfdcDigest",
    "parameters": {
    "fields": [
    {
    "name": "AccountNumber"
    },
    {
    "name": "Name"
    },
    {
    "name": "Phone"
    },
    {
    "name": "ShippingStreet"
    },
    {
    "name": "ShippingState"
    },
    {
    "name": "ShippingPostalCode"
    },
    {
    "name": "ShippingCity"
    },
    {
    "name": "ShippingCountry"
    }
    ],
    "object": "Account"
    }
    },
    "Create Seed Bank Agencies": {
    "action": "sfdcRegister",
    "parameters": {
    "name": "Seed Bank Agencies",
    "alias": "seed_bank_agencies",
    "source": "Augment TempClass"
    }

    ReplyDelete
  50. Trailblazer GERNovember 24, 2020 at 11:46 AM

    },
    "Load Climate": {
    "action": "edgemart",
    "parameters": {
    "alias": "Global_Climates"
    }
    },
    "Add Agency Fields": {
    "action": "augment",
    "parameters": {
    "right_key": [
    "AccountNumber"
    ],
    "left": "Filter Agency Records",
    "left_key": [
    "AccountNumber"
    ],
    "right_select": [
    "Acres",
    "Currency",
    "Latitude",
    "Longitude",
    "Region",
    "SubRegion"
    ],
    "right": "Load Agency Detail",
    "relationship": "AgencyDetail",
    "operation": "LookupSingleValue"
    }
    },
    "Filter 2015": {
    "action": "filter",
    "parameters": {
    "filter": "Date_Year:EQ:2015",
    "source": "Load Climate"
    }
    },
    "Augment TempClass": {
    "action": "augment",
    "parameters": {
    "right_key": [
    "Country"
    ],
    "left": "Add Agency Fields",
    "left_key": [
    "ShippingCountry"
    ],
    "right_select": [
    "Date",
    "TempClass",
    "Temperature",
    "Country"
    ],
    "right": "Add Temp Class",
    "relationship": "Climate",
    "operation": "LookupSingleValue"
    }
    },
    "Load Agency Detail": {
    "action": "edgemart",
    "parameters": {
    "alias": "Agency_Detail"
    }
    },
    "ID Agency Records": {
    "action": "computeExpression",
    "parameters": {
    "source": "Load Account",
    "mergeWithSource": true,
    "computedFields": [
    {
    "name": "IsAgency",
    "saqlExpression": "case when Phone is not null then \"TRUE\" else \"FALSE\" end",
    "label": "IsAgency",
    "type": "Text"
    }
    ]
    }
    }
    }

    ReplyDelete
  51. Chris KFebruary 23, 2021 at 10:27 AM

    Working on step 4 of this and its driving me crazy. The data flow is running properly. The JSON looks right. But then in the lens, I can't see the Acreage to sum by that. Any insight you may be able to provide would be great. JSON:

    {
    "Calculate Acreage": {
    "action": "computeExpression",
    "parameters": {
    "source": "Load Seed Chart",
    "mergeWithSource": true,
    "computedFields": [
    {
    "precision": 18,
    "name": "Acreage",
    "saqlExpression": "(Seeds_Pound*Spacing)/6272640",
    "scale": 6,
    "label": "Acreage",
    "type": "Numeric"
    }
    ]
    }
    },
    "Create Seed Bank": {
    "action": "sfdcRegister",
    "parameters": {
    "name": "Seed Bank",
    "alias": "seed_bank",
    "source": "Calculate Acreage"
    }
    },
    "Load Seed Chart": {
    "action": "edgemart",
    "parameters": {
    "alias": "Seed_Chart"
    }
    }
    }

    ReplyDelete
  52. AnonymousJuly 10, 2021 at 2:39 PM

    Hi, I am getting the message: We can't validate the 'Create Seed Bank Agencies' node was created correctly. Check the required fields, field types, node name, and alias are correct.
    PLEASE HELP ME !!!! What I did wrong?
    'Load Seed Bank Agencies w/Climate Data'
    {
    "Add Temp Class": {
    "action": "computeExpression",
    "parameters": {
    "source": "Filter 2015",
    "mergeWithSource": true,
    "computedFields": [
    {
    "defaultValue": "Continental",
    "name": "TempClass",
    "saqlExpression": "case when Temperature < 25 then \"Polar\" when Temperature >= 25 and Temperature <= 50 then \"Cool\" when Temperature >= 51 and Temperature <= 85 then \"Continental\" when Temperature > 85 then \"Tropical\" end",
    "label": "TempClass",
    "type": "Text"
    }
    ]
    }
    },
    "Filter Agency Records": {
    "action": "filter",
    "parameters": {
    "filter": "IsAgency:EQ:TRUE",
    "source": "ID Agency Records"
    }
    },
    "Load Account": {
    "action": "sfdcDigest",
    "parameters": {
    "fields": [
    {
    "name": "AccountNumber"
    },
    {
    "name": "Name"
    },
    {
    "name": "ShippingCity"
    },
    {
    "name": "ShippingCountry"
    },
    {
    "name": "ShippingPostalCode"
    },
    {
    "name": "ShippingState"
    },
    {
    "name": "ShippingStreet"
    },
    {
    "name": "Phone"
    }
    ],
    "object": "Account"
    }
    },

    ReplyDelete
  53. UnknownJuly 10, 2021 at 2:39 PM

    "Create Seed Bank Agencies": {
    "action": "sfdcRegister",
    "parameters": {
    "name": "Seed Bank Agencies",
    "alias": "seed_bank_agencies",
    "source": "Augment TempClass"
    }
    },
    "Load Climate": {
    "action": "edgemart",
    "parameters": {
    "alias": "Global_Climates"
    }
    },
    "Add Agency Fields": {
    "action": "augment",
    "parameters": {
    "right_key": [
    "AccountNumber"
    ],
    "left": "Load Account",
    "left_key": [
    "AccountNumber"
    ],
    "right_select": [
    "Acres",
    "Currency",
    "Latitude",
    "Longitude",
    "Region",
    "SubRegion"
    ],
    "right": "Load Agency Detail",
    "relationship": "AgencyDetail",
    "operation": "LookupSingleValue"
    }
    },
    "Filter 2015": {
    "action": "filter",
    "parameters": {
    "filter": "Date_Year:R:2015",
    "source": "Load Climate"
    }
    },
    "Augment TempClass": {
    "action": "augment",
    "parameters": {
    "right_key": [
    "Country"
    ],
    "left": "Filter Agency Records",
    "left_key": [
    "ShippingCountry"
    ],
    "right_select": [
    "TempClass"
    ],
    "right": "Add Temp Class",
    "relationship": "Climate",
    "operation": "LookupSingleValue"
    }
    },
    "Load Agency Detail": {
    "action": "edgemart",
    "parameters": {
    "alias": "Agency_Detail"
    }
    },
    "ID Agency Records": {
    "action": "computeExpression",
    "parameters": {
    "source": "Add Agency Fields",
    "mergeWithSource": true,
    "computedFields": [
    {
    "name": "IsAgency",
    "saqlExpression": "case when Phone is not null then \"TRUE\"else \"FALSE\" end",
    "label": "IsAgency",
    "type": "Text"
    }
    ]
    }
    }
    }
    Close

    ReplyDelete
  54. AnonymousSeptember 3, 2021 at 1:37 AM

    Hello,
    Step 6 :
    When running my My Load Seed Bank Agencies w/Climate Dataflow in the Monitor, this warning message appears :

    The dataflow was completed, but the Augment TempClass node didn't augment any columns. Either the node didn't find any matches, or a join key contains only null values.



    Here is my Json in 2 messages if someone can help :

    {

    "Add Temp Class": {

    "action": "computeExpression",

    "parameters": {

    "source": "Filter 2015",

    "mergeWithSource": true,

    "computedFields": [

    {

    "defaultValue": "Continental",

    "name": "TempClass",

    "saqlExpression": "case \nwhen Temperature < 25 then \"Polar\" \nwhen Temperature >= 25 and Temperature <= 50 then \"Cool\" \nwhen Temperature >= 51 and Temperature <= 85 then \"Continental\" \nwhen Temperature > 85 then \"Tropical\" \nend",

    "label": "TempClass",

    "type": "Text"

    }

    ]

    } ,

    "Filter Agency Records": {

    "action": "filter",

    "parameters": {

    "filter": "IsAgency:EQ:TRUE",

    "source": "ID Agency Records"

    }

    },

    "Load Account": {

    "action": "sfdcDigest",

    "parameters": {

    "fields": [

    {

    "name": "Name"

    },

    {

    "name": "Phone"

    },

    {

    "name": "ShippingCity"

    },

    {

    "name": "ShippingCountry"

    },

    {

    "name": "ShippingPostalCode"

    },

    {

    "name": "ShippingStreet"

    },

    {

    "name": "ShippingState"

    },

    {

    "name": "AccountNumber"

    }

    ],

    "object": "Account"

    }

    },

    ReplyDelete
    Replies
    1. SFpowerSeptember 3, 2021 at 1:38 AM

      2nd part of Json :
      "Create Seed Bank Agencies": {
      "action": "sfdcRegister",
      "parameters": {
      "name": "Seed Bank Agencies",
      "alias": "seed_bank_agencies",
      "source": "Augment TempClass"
      }
      },
      "Load Climate": {
      "action": "edgemart",
      "parameters": {
      "alias": "Global_Climates"
      }
      },
      "Load Agency detail": {
      "action": "edgemart",
      "parameters": {
      "alias": "Agency_Detail"
      }
      },
      "Add Agency Fields": {
      "action": "augment",
      "parameters": {
      "right_key": [
      "AccountNumber"
      ],
      "left": "Load Account",
      "left_key": [
      "AccountNumber"
      ],
      "right_select": [
      "Acres",
      "Currency",
      "Latitude",
      "Longitude",
      "Region",
      "SubRegion"
      ],
      "right": "Load Agency detail",
      "relationship": "AgencyDetail",
      "operation": "LookupSingleValue"
      }
      },
      "Filter 2015": {
      "action": "filter",
      "parameters": {
      "filter": "Date_Year:EQ:2015",
      "source": "Load Climate"
      }
      },
      "Augment TempClass": {
      "action": "augment",
      "parameters": {
      "right_key": [
      "Country"
      ],
      "left": "Filter Agency Records",
      "left_key": [
      "ShippingCountry"
      ],
      "right_select": [
      "Temperature",
      "Date",
      "TempClass",
      "Country"
      ],
      "right": "Add Temp Class",
      "relationship": "Climate",
      "operation": "LookupSingleValue"
      }
      },
      "ID Agency Records": {
      "action": "computeExpression",
      "parameters": {
      "source": "Add Agency Fields",
      "mergeWithSource": true,
      "computedFields": [
      {
      "name": "IsAgency",
      "saqlExpression": "\"case when Phone is not null then \\\"True\\\" else \\\"False\\\" end\"",
      "label": "IsAgency",
      "type": "Text"
      }
      ]
      }
      }
      }
      Thanks for help

      Delete
  55. AnonymousJuly 22, 2022 at 5:51 PM

    Hi, I have a problem with the step 6: When I run the Dataflow
    Load Seed Bank Agencies w/Climate Data it give me this error:
    Something went wrong while executing the Augment TempClass node: Right select in augment node must properly refer to the right input column. Node Augment TempClass refers to field TempClass not present in right source. (02K7R000000pt8bUAA_03C7R000004QOLfUAO)
    I send the Json of this node
    Node Name Augment TempClass
    Left Source
    ["Filter Agency Records"]
    Left Key
    ["ShippingCountry"]
    Relationship
    Climate
    Right Source
    ["Add Temp Class"]
    Right Key
    ["Country"]
    Right Fields
    ["TempClass","Country","Date","Temperature"]
    Operation
    Look Up Single Value
    Thanks in advance for your help

    ReplyDelete
  56. AnonymousDecember 24, 2022 at 2:13 AM

    HI while trying to complete Determine Optimal Climates challenge Any Idea why am getting this Error "There was an unhandled exception. Please reference ID: UAPSIKJH. Error: Restforce::ResponseError. Message: 550: To use null dimensions or date filters, you need API version 51 or higher."

    ReplyDelete
  57. AnonymousFebruary 22, 2023 at 10:03 AM

    Hey! Is anyone working on this Superbadge or did I just got too late?
    I'm trying to get to this one:
    "Determine Optimal Climates
    Build a dataflow to add temperature classes to the Seed Bank Agencies and Seed Bank datasets."
    However, I'm getting this error:
    "The dataflow was completed, but the Augment TempClass node didn't augment any columns. Either the node didn't find any matches, or a join key contains only null values."

    I'm publishing my JSON file just to see what I'm really missing... (I would really appreciate if someone knows what's going on)

    ReplyDelete
    Replies
    1. AnonymousFebruary 22, 2023 at 10:03 AM

      {
      "Add Temp Class": {
      "action": "computeExpression",
      "parameters": {
      "source": "Filter 2015",
      "mergeWithSource": true,
      "computedFields": [
      {
      "defaultValue": "Continental",
      "name": "TempClass",
      "saqlExpression": "case when Temperature < 25 then \"Polar\" when Temperature >= 25 and Temperature <= 50 then \"Cool\" when Temperature >= 51 and Temperature <= 85 then \"Continental\" when Temperature > 85 then \"Tropical\" end ",
      "label": "TempClass",
      "type": "Text"
      }
      ]
      }
      },
      "Filter Agency Records": {
      "action": "filter",
      "parameters": {
      "filter": "IsAgency:EQ:TRUE",
      "source": "ID Agency Records"
      }
      },
      "Load Account": {
      "action": "sfdcDigest",
      "parameters": {
      "fields": [
      {
      "name": "Name"
      },
      {
      "name": "AccountNumber"
      },
      {
      "name": "Phone"
      },
      {
      "name": "ShippingCity"
      },
      {
      "name": "ShippingCountry"
      },
      {
      "name": "ShippingState"
      },
      {
      "name": "ShippingStreet"
      },
      {
      "name": "ShippingPostalCode"
      }
      ],
      "object": "Account"
      }
      },
      "Create Seed Bank Agencies": {
      "action": "sfdcRegister",
      "parameters": {
      "rowLevelSecurityFilter": "",
      "name": "Seed Bank Agencies",
      "alias": "seed_bank_agencies",
      "source": "Augment TempClass"
      }
      },
      "Load Climate": {
      "action": "edgemart",
      "parameters": {
      "alias": "Global_Climates"
      }
      },
      "Add Agency Fields": {
      "action": "augment",
      "parameters": {
      "right_key": [
      "AccountNumber"
      ],
      "left": "Load Account",
      "left_key": [
      "AccountNumber"
      ],
      "right_select": [
      "SubRegion",
      "Region",
      "Longitude",
      "Latitude",
      "Currency",
      "Acres"
      ],
      "right": "Load Agency Detail",
      "relationship": "AgencyDetail",
      "operation": "LookupSingleValue"
      }
      },
      "Filter 2015": {
      "action": "filter",
      "parameters": {
      "filter": "Date:EQ:2015",
      "source": "Load Climate"
      }
      },
      "Augment TempClass": {
      "action": "augment",
      "parameters": {
      "right_key": [
      "Country"
      ],
      "left": "Filter Agency Records",
      "left_key": [
      "ShippingCountry"
      ],
      "right_select": [
      "Temperature",
      "Date",
      "Country",
      "TempClass"
      ],
      "right": "Add Temp Class",
      "relationship": "Climate",
      "operation": "LookupSingleValue"
      }
      },
      "Load Agency Detail": {
      "action": "edgemart",
      "parameters": {
      "alias": "Agency_Detail"
      }
      },
      "ID Agency Records": {
      "action": "computeExpression",
      "parameters": {
      "source": "Add Agency Fields",
      "mergeWithSource": true,
      "computedFields": [
      {
      "name": "IsAgency",
      "saqlExpression": "case when \"Phone\" is not null then \"TRUE\" else \"FASLE\" end",
      "label": "IsAgency",
      "type": "Text"
      }
      ]
      }
      }
      }

      Delete
  58. AnonymousMay 4, 2023 at 4:19 AM

    Hi, I know I'm pretty late with this, but I'm stuck on challenge 6,

    Challenge Not yet complete... here's what's wrong: We can't validate the 'Create Seed Bank Agencies' node was created correctly. Check the required fields, field types, node name, and alias are correct.

    Here is my JSON below,

    {
    "Add Temp Class": {
    "action": "computeExpression",
    "parameters": {
    "source": "Filter 2015",
    "mergeWithSource": true,
    "computedFields": [
    {
    "defaultValue": "Continental",
    "name": "TempClass",
    "saqlExpression": "case when Temperature < 25 then \"Polar\" when Temperature >= 25 and Temperature <= 50 then \"Cool\" when Temperature >= 51 and Temperature <= 85 then \"Continental\" when Temperature > 85 then \"Tropical\" end\n ",
    "label": "TempClass",
    "type": "Text"
    }
    ]
    }
    },
    "Filter Agency Records": {
    "action": "filter",
    "parameters": {
    "filter": "IsAgency:EQ:TRUE",
    "source": "ID Agency Records"
    }
    },
    "Load Account": {
    "action": "sfdcDigest",
    "parameters": {
    "fields": [
    {
    "name": "AccountNumber"
    },
    {
    "name": "Name"
    },
    {
    "name": "Phone"
    },
    {
    "name": "ShippingPostalCode"
    },
    {
    "name": "ShippingState"
    },
    {
    "name": "ShippingStreet"
    },
    {
    "name": "ShippingCountry"
    },
    {
    "name": "ShippingCity"
    }
    ],
    "object": "Account"
    }
    },
    "Create Seed Bank Agencies": {
    "action": "sfdcRegister",
    "parameters": {
    "name": "Seed Bank Agencies",
    "alias": "seed_bank_agencies",
    "source": "Augment TempClass"
    }
    },
    "Load Climate": {
    "action": "edgemart",
    "parameters": {
    "alias": "Global_Climates"
    }
    },
    "Add Agency Fields": {
    "action": "augment",
    "parameters": {
    "right_key": [
    "AccountNumber"
    ],
    "right_select": [
    "Currency",
    "Region",
    "SubRegion",
    "Latitude",
    "Acres",
    "Longitude"
    ],
    "right": "Load Agency Detail",
    "relationship": "AgencyDetail",
    "operation": "LookupSingleValue"
    }
    },
    "Filter 2015": {
    "action": "filter",
    "parameters": {
    "filter": "Date_Year:R:2015",
    "source": "Load Climate"
    }
    },
    "Augment TempClass": {
    "action": "augment",
    "parameters": {
    "right_key": [
    "Country"
    ],
    "left": "Filter Agency Records",
    "left_key": [
    "ShippingCountry"
    ],
    "right_select": [
    "Country",
    "Date",
    "TempClass",
    "Temperature"
    ],
    "right": "Add Temp Class",
    "relationship": "Climate",
    "operation": "LookupSingleValue"
    }
    },
    "Load Agency Detail": {
    "action": "edgemart",
    "parameters": {
    "alias": "Agency_Detail"
    }
    },
    "ID Agency Records": {
    "action": "computeExpression",
    "parameters": {
    "source": "Add Agency Fields",
    "mergeWithSource": true,
    "computedFields": [
    {
    "defaultValue": "\"FALSE\"",
    "name": "IsAgency",
    "saqlExpression": "case when 'Phone' is not null then \"TRUE\" else \"FALSE\" end",
    "label": "IsAgency",
    "type": "Text"
    }
    ]
    }
    }
    }

    ReplyDelete

Post a Comment

Popular posts from this blog

Service Cloud Specialist Superbadge - 4,5,6,7

Part of doing the Service Cloud Specialist superbadge is trying new things, so I am putting up picture of new things that I've tried recently.  One of my favorite new things this week was taking a shower with my whole block collection.  Mom put me in the shower, and I sneaked out to grab the block bin and dumped it in.  I'm concerned to share photos because of the slight nudity, however, I can assure you that it was a glorious adventure.  Instead, I'll share my favorite Saturday new thing- walking to the coffee shop for a sprinkle donut!  Back to the superbadge... Challenge 4 Case Routing If you haven't taken the Onmi Channel module yet, now is a good time! I kept that particular module open one on screen while I walked through this step.  It is hard to give many hints about this step without giving away too many details - so - the best advice is to read through the challenge and label each step with the corresponding Salesforce term.  (IE - "The...
191 comments
Read more

Business Administration Specialist Superbadge- 3 & 4

This afternoon, I added a genius wig in an attempt to look a little older and more experienced.  The free lemonade offer worked!  I made two dollars today!  A huge thank you to Jocelyn Fennewald , Salesforce MVP, for pointing out the "remove all columns" option within the report creator.  When you start a create a new report, simply click to start with a clean screen.  If you are familiar with report and dashboards, this challenge should only take 30 or so minutes to complete.  Below are tips and gotchas for each report / dashboard.  If you need more help, leave a comment! Reports Accounts by Market To create the "Market" row grouping, use a bucket field. Make sure that the correct date range is selected. High Value Residential  This report includes: 1 filter, 1 grouping, and 1 summarized field.  Rated Accounts by State The record count for state and account rating are automatically added. Note the filter.  ...
134 comments
Read more

Service Cloud Specialist Superbadge - 1,2,3

A confession - I know next to nothing about service cloud.  While I was excited that a new superbadge was available, it made me a little nervous that I had to do all of the prerequisites and tackle new things like macros.  New things - new year - let's get started! (Right after I finish guitar practice) If you are also a service cloud novice, the Omni-Channel Basics is a crucial prerequisite even though it is not officially required. Challenge 1 App Appearance  This, like all superbadges, requires a careful read through the instructions prior to any clicking.  I found it helpful to take a separate notebook and write down the steps that I would need for each challenge step - for example -  My rough notes for challenge 1: Create 2 profiles  Tweak service Console 3 new items on utility bar Allow access for new profiles Create User  Beware - After editing the service console, you might have to edit the new profiles.  I found i...
155 comments
Read more