Open Support Cases You ma, I might complain about my brother sometimesespecially how he takes up so much of mom's timebut I've decided that he really is a nifty fellow. 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. He laughs when I poke his nose and tries to take toys out of my hand. 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. Hi Rebecca,in Step 4 , i am getting this error :: "We can't find the Acreage field. 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. When you start a create a new report, simply click to start with a clean screen. wrong data? I solved this by putting the opportunity record and project record into separate list and performing DML on the list. The Heroku app registers the username with the Connected App's consumer key and consumer secret in the Square Peg registry and returns a security token. Please check your work." Agency Temp Class lens? 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. Data Integration SpecialistWhat You'll Be Doing to Earn This SuperbadgeConfigure outbound application and integration securityConfigure inbound integration s. The superbadge is specially designed for learning and testing integrations between different systems. 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? 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 0Filter 2015 filter Less than 1 second success 31,200 0 0 0ID Agency Records computeExpression Less than 1 second success 1,384 0 1,384 0Temp Class computeExpression Less than 1 second success 0 0 0 0Filter Agency Records filter Less than 1 second success 1,384 0 383 0Augment TempClass augment Less than 1 second warning 0 0 0 0optimize-Create Seed Bank Agencies optimizer Less than 1 second success 0 0 0 0Create Seed Bank Agencies sfdcRegister 40 seconds success 0 0 0 0. Copyright 2000-2022 Salesforce, Inc. All rights reserved. The sketch allowed me to organize all of the instructions into a reasonable order before I started clicking. 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. I have deleted the old workspace in workspace manager in the console as it could be corrupt. Are you sure you want to create this branch? },"CleanUp": {"action": "sliceDataset","parameters": {"mode": "drop","source": "Augment Temp Class","fields": [{"name": "TempClass"},{"name": "TempKey"},{"name": "Climate.lowtemp"},{"name": "Climate.hightemp"}this is incorrect. It's been a while. so I hope this is good advice! Trailhead Baby,I'm having an issue with Load Seed Bank w/Temperature ClassificationI keep getting this error after running the data flow and there is no data in the lens. If you could kindly give me some insight as i fear i'm missing something here. Copyright 2000-2022 Salesforce, Inc. All rights reserved. The dataflow was completed, but the LookupSingleValue node didn't augment any columns. 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. 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. Apex Specialist SuperBadge 5. If someone could be so kind to support, that would really be helpful.Thanks a lot. I've checked my spelling, order of parameters in the method signature. Alias - is incorrect. Challenge 6: Test scheduling logic. Check the challenge and confirm the node name and required fields. Please check below post i hope that will help you. 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. Search for an answer or ask a question of the zone or Customer Support. Something that helped was saving the report frequently. Either the node didn't find any matches, or a join key contains only null values. Please support me on Patreon: https://www.patreon.com/roelvandepaarWith thanks \u0026 praise to God, and with thanks to the many people who have made this project possible! 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. PLEASE HELP ME !!!! Thanks for your help. This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. 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. Check the challenge and confirm required field setting. Can you please post your JSON for the dataflow or at least the Define Temp Range and Add Temp Class nodes? Data Integration Specialist Superbadge Challenge 2 I am trying to register Configure Org Registration where I have to use a custom Heroku app to register my org. Disclaimer: All information is provided \"AS IS\" without warranty of any kind. !I can't copy here all the code, so I have copy in Gdrive. Challenge 5: Test callout logic. 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" } ] } }}, I am so lost on step 6. This commit does not belong to any branch on this repository, and may belong to a fork outside of the repository. but when checked the challenge i am getting this error mentioned belowChallenge 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. Yes! 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. Make sure that the correct date range is selected. Confirm the node name matches the name as described in the challenge. I'm having difficulty with challenge 3 for superbadge analytics data preparation specialist. 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. Thank you so much Rebeca, My step 6 is resolved finally today. When I made mistakes, I simply reverted to the last saved version. I have finally made the super badge today ! Either the node didn't find any matches, or a join key contains only null values. Step-2:- Then go to Setup-->Remote Site Settings-->New Remote Site. Still stuck? You signed in with another tab or window. 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. @shruthi"name": "Seed Bank","alias": "Seed_Chart",alias has to be Seed_Bank as well , let me know if that works out ! Challenge 4 is not difficult if you follow the instructions precisely! After you've imported the Account object, you'll be ready to tackle the challenges. Search for an answer or ask a question of the zone or Customer Support. Check the required fields, field types, node name, and alias are correct.here is my json EinsteinData ManagerLoad Seed Bank Agencies w/Climate DataDATAFLOWLoad Seed Bank Agencies w/Climate DataRun DataflowJSON 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.RegardsSri, "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" } ] } }}CloseSearch nodeshidden, "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", And slightly different saql"name": "IsAgency","saqlExpression": "case when Phone is not null then \"TRUE\" else \"FALSE\" end","label": "IsAgency","type": "Text", 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" } }}, hmm I have a different left node for augment temp class (left": "Load Seed Bank Agencies"). This would take away from the purpose of the superbadge. :(, {"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, Hi, I'm stuck at step 6 Before focus, I have: Polar 93, Continental 91, Cool 42. 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. Thanks a lot! 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. Appreciated! Thanks Ill have to put this in two post. If you could just post the JSON for your data flow, I will take a look. Data Security Specialist Superbadge : Working with Data Categorization and Access | challenge 1Answer questions relating to the Data Categorization and Acces. Modified 2 months ago. Did it help? Error: Restforce::ResponseError. No Even after that it is not working it says We can't find the 'Load Seed Chart' node in the dataflow. It also removed the approval steps from Process Builder and highlighted (with *'s) the prerequisite items to building my process. hmm Could you post the json for the dataflow? 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. 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. @Trailhead Baby Can you post your JSON for the same? Please check your work. Confirm the node name matches the name as described in the challenge. Note the filter. Hi, I am getting the message: We can't validate the 'Create Seed Bank Agencies' node was created correctly. 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.