data integration specialist superbadge challenge 5

Hi there.I made the changes as you suggested and still receiving the same error. created a dataflow with name "Load Seed Bank" . Either the node didn't find any matches, or a join key contains only null values.I believe it is because of this warning I cannot complete Step #6 because I am getting the following: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. Hi, I am getting the message: Something went wrong while executing the Augment Temp Class node: Duplicate field TempClassCan you help me with my JSON? "However, I'm getting this error:"The dataflow was completed, but the Augment TempClass node didn't augment any columns. I enjoy playing on Trailhead, taking long walks with mommy, watching the Florida Gators with daddy, and chasing my two dogs. Confirm the node name matches the name as described in the challenge. This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. 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. 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 3Continental-Tropical 2Cool-Continental 2Continental 1Cool 1. 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. Please check your work.Many thanks. Hint: You can't match on a field that isnt' selected for both data sets. Thanks! I was able to complete the challengeFor 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. { "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" }, }, "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" } ] } }}, Working on step 4 of this and its driving me crazy. Step 5 - A quiz. 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. wrong data? To review, open the file in an editor that reveals hidden Unicode characters. I can't find any instance of this same error anywhere. My bad. 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. 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". still i'm facing the same issue. 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" } }}, "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. Either the node didn't find any matches, or a join key contains only null values. Thanks for your help. 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. Challenge 3: Schedule synchronization. upsert directly against the ProjectRef__c external id field, https://developer.salesforce.com/forums/?id=9060G000000I526QAC, https://developer.salesforce.com/forums/?id=9060G000000I56rQAC. Are this numbers correct?Thanks, Antonio. But then in the lens, I can't see the Acreage to sum by that. Learn more about bidirectional Unicode characters. @shruthi"name": "Seed Bank","alias": "Seed_Chart",alias has to be Seed_Bank as well , let me know if that works out ! (full disclosure-- I did this superbadge twice because I didn't fully understand the first timeso don't feel bad about being lost! I have higher numbers for all. Message: 550: To use null dimensions or date filters, you need API version 51 or higher. Either the node didn't find any matches, or a join key contains only null values. High Value Residential This report includes: 1 filter, 1 grouping, and 1 summarized field. 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. Note the filter. Anyway, sorry for bothering. Various trademarks held by their respective owners. ), Hi please help in update the data flow.i can't update my data flow..show errors in that. Apex Specialist SuperBadge 5. Rated Accounts by State The record count for state and account rating are automatically added. Start by uploading the dataset then create the dataflow. The best of luck! Name capitalized, alias not capitalized. When you start a create a new report, simply click to start with a clean screen. Can you please post your JSON for the dataflow or at least the Define Temp Range and Add Temp Class nodes? To complete the challenges, you need to pre-populate the Account object with data associated with this superbadge. Copyright 2000-2022 Salesforce, Inc. All rights reserved. Thank you so much Rebeca, My step 6 is resolved finally today. Report Modifications: Sales Two words: Filter Logic Support If you get this errortry stacking to 100% and make sure that you have a "horizontal" style chart. Getting below error. There could be a wide variety of issues, code could be right logically and different people get the error for different reasons. No Even after that it is not working it says We can't find the 'Load Seed Chart' node in the dataflow. My brother has started to play with me! Salesforce Trailhead Superbadge 'Data Integration Specialist' Data Integration Specialist is one of the superbadges of Salesforce trailhead (A New Approach to Learning Salesforce). So much banging and so silly of me, i had the issues fixed, i passed the step 4, Even though i have done everything as mentioned, while creating the lens i am not able to see the acreage field under Bar length. I didn't dig any further once I saw the AccountNumber issue. That would be cheating--- I'm happy to provide hints, but will never share answers. I solved this by putting the opportunity record and project record into separate list and performing DML on the list. You are responsible for your own actions. Appreciated! Many Git commands accept both tag and branch names, so creating this branch may cause unexpected behavior. Salesforce: Trailhead : Data Integration Specialist Challenge 5Helpful? I am stuck at the SAQL Expression field for 'Calculate Acreage'. Data Integration Specialist || Superbadge Trailhead || Challenge 2 Check the challenge and confirm required field setting." It was the Long/Lat settings in the Agency Detail upload. Confirm the node name matches the name as described in the challenge. Have you guessed the theme of the photos that go along with the Trailhead - Process Automation Specialist Superbadge series?They are a few of my favorite day to day processes! Take a break, grab a snack, and watch this video. 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. It's been a while. so I hope this is good advice! Making dinner for Mom! Ans:-Read the Salesforce Help article for the superbadge,review all relevant Salesforce Help documentation, and then log a case. I couldn't get through challenge 3 because I changed them to dimensions, and then now I had to change them back! '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" } }, "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. Either the node didn't find any matches, or a join key contains only null values. Node Augment TempClass refers to field TempClass not present in right source. Data Integration Specialist : What You'll Be Doing to Earn This SuperbadgeConfigure outbound application and integration securityConfigure inbound integratio. The free lemonade offer worked! 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. Trailheads New Data Integration Specialist Superbadge is - LinkedIn I am getting this error from step 4Challenge Not yet complete here's what's wrong:We can't find the 'Load Seed Chart' node in the dataflow. Lol, },"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. . 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". Onwards to Step #7.Karen, Could you please give me the final json? If you are short on time, start around the 20 minute mark. Why the change of heart? hmm Could you post the json for the dataflow? Can you elaborate? @Trailhead Baby Can you post your JSON for the same? When I made mistakes, I simply reverted to the last saved version. Thanks much :), Hi I am getting the bellow error. Check the challenge and confirm the node name and required fields. "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. Data Integration Specialist: Challenge 5 - Not Completing This is regarding Challenge 6. !I can't copy here all the code, so I have copy in Gdrive. Salesforce: Trailhead : Data Integration Specialist Challenge 5Helpful? { "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? It also removed the approval steps from Process Builder and highlighted (with *'s) the prerequisite items to building my process. error in challenge 6. "Awaiting a helpful response.Thanks,Mithilesh. Below are tips and gotchas for each report / dashboard. Slack to Salesforce Integration using Apex Trigger, Test Class Not Covered. Challenge Not yet complete. The data flow is running properly. 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" }, "Load Seed Chart": {"action": "edgemart","parameters": {"alias": "Load_Seed_Chart"Wrong Alias, Hello.Thank you for all of your assistance so far and the link you provided is extremely helpful!I am banging my head against the wall on the following error when I am trying to run the dataflow for Load Seed Bank w/Temperature Classification:Something went wrong while executing the Define Temp Range node: invalid field expression for field 'LowTemp': Syntax Error at position [line 1: column 45] after token , :: ;rature,1,2))",; (02K6g000000ZTAJEA4_03C6g000001DuzvEAC)Here is my saql expression for LowTemp:"string_to_number(substr(Temperature,1,2))",It is defined as Numeric and I have the precision: 18 and scale: 2, default value: 0The source is Calculate Average.I am hoping it is something obvious that I am overlooking :-)Thanks again!Karen. ", Hey! If you are familiar with report and dashboards, this challenge should only take 30 or so minutes to complete. let me know what i am missing here. I found that my saql expressions needed to have spaces:string_to_number(substr(Temperature, 1, 2))Now I am encountering another warning and I did try the suggestions, but I still cannot clear this message when I run the dataflow:The dataflow was completed, but the LookupSingleValue node didn't augment any columns. Can you please let me know what was the root cause? },"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. Sorry but where i can get the right alias and name, and this goes beyond the question. Search for an answer or ask a question of the zone or Customer Support. If you could kindly give me some insight as i fear i'm missing something here. Check the required fields, field types, node name, and alias are correct. 5. Data Integration Specialist Superbadge - Blogger 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" } }}, Techforce services is a Salesforce Consulting Services in Australia Specializing in delivering end to end Salesforce solutions ,Consulting, Implementation DevOps partners in Australia We deliver applications and services more rapidly and reliably, but its more than a methodology it cuts to the very core. Superbadge Apex Specialist looks good on Resume, and they prove worth it as well. OMG - I finally passed step #6.I totally redid the Load Seed Bank w/Climate and Load Seed Bank w/Temperature after I had to break down and have a Coke Zero after 3 yearslol.I also reloaded the datasets, etc.I have the final JSON if you want itThanks again. Challenge 2: Synchronize Salesforce data with an external system. Hi I am completely new this superbadges. (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", Eureka! I have the same nodes as you, but I dont understand how you are supposed to multi join or the two nodes before that. The superbadge is specially designed for learning and testing integrations between different systems. Check the required fields, field types, node name, and alias are correct. Data Integration Specialist: Challenge 5 - Not Completing Unsolved Questions This Question David H 18 Data Integration Specialist: Challenge 5 - Not Completing Hi, I'm currently working through the Data Integration Specialist superbadge and my attempt throws the following error when I check the challenge: "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. The dataset is created by the dataflow that you create. https://docs.google.com/document/d/1RaNsOtQZlsL_yVTd0NWkox9kpyV1LLJ60fWBEVQwsLI/edit?usp=sharing. Challenge 4: Test automation logic. Data integration specialist superbadge solution. Hi,i'm facing an issue in Challenge-4.