I am getting this error despite all the dataflows successful. I am also stuck in Challenge4. In the superbadge there's no indication of what naming convention to follow. First I create a min and max temp, then how do I use two fields to get a temperature category? mistake was for the case statement I had an upper case "C" in Case (which is how its always done in VC++ and VB, Glad you figured it out! 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. I'm facing the same error, it's making me nuts =). I am stuck at the SAQL Expression field for 'Calculate Acreage'. So close! thanks a lot. Learn more about bidirectional Unicode characters. My bad. Salesforce: Trailhead : Data Integration Specialist Challenge 5Helpful? I can't find any instance of this same error anywhere. Ask Question Asked 1 year, 3 months ago. Confused? Data Integration Specialist : What You'll Be Doing to Earn This SuperbadgeConfigure outbound application and integration securityConfigure inbound integratio. Rated Accounts by State The record count for state and account rating are automatically added. not sure what is wrong here as i followed the same approach for challenge-3. You also get personal insight into the life of a Trailhead Baby! @Shruthi, did you got the issue fixed? Making dinner for Mom! Slack to Salesforce Integration using Apex Trigger, Test Class Not Covered. #dataintegrationspecialist##techinvisible#superbadgeagentDo follow on instagram for complete superbadge access :https://www.instagram.com/tech_invisible/ "Awaiting a helpful response.Thanks,Mithilesh. 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" } }}. The superbadge is specially designed for learning and testing integrations between different systems. I've recreated the steps a number of times, and I am pretty sure all of my nomenclature is correct. Its giving me a syntax error. 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. data integration specialist superbadge challenge 5 Still stuck? https://docs.google.com/document/d/1RaNsOtQZlsL_yVTd0NWkox9kpyV1LLJ60fWBEVQwsLI/edit?usp=sharing. Trailhead Superbadge: Data Integration Specialist | LaptrinhX created a dataflow with name "Load Seed Bank" . Data Integration Specialist || Superbadge Trailhead || Challenge 4 '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. (Working on the advanced billing specialist! 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? Search for an answer or ask a question of the zone or Customer Support. Getting below error. I think I will have to post in two comments due to the html limit. i have completed my step 7 already but could not proceed because of step 6 issues. What I did wrong? The best of luck! { "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? Are this numbers correct?Thanks, Antonio. 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. If you are short on time, start around the 20 minute mark. thanks.~. Either the node didn't find any matches, or a join key contains only null values." The dataflow was completed, but the LookupSingleValue node didn't augment any columns. 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. Thank you for the pointers i made some new changes the data flow ran fine finally after the drill. The dataflow was completed, but the LookupSingleValue node didn't augment any columns. I couldn't get through challenge 3 because I changed them to dimensions, and then now I had to change them back! 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. (full disclosure-- I did this superbadge twice because I didn't fully understand the first timeso don't feel bad about being lost! Salesforce Trailhead Superbadge 'Data Integration Specialist' 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. Can you please post your JSON for the dataflow or at least the Define Temp Range and Add Temp Class nodes? I just tried that and it I still keep getting this error. },"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. !I can't copy here all the code, so I have copy in Gdrive. App customization specialist superbadge challenge 5 jobs Data integration specialist superbadge solution. I don't understand what you mean. That is against Trailhead's terms of use. 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. Hint - The TempClass formula is different for each of the dataflows. Load Seed Bank w/ Temperature Classification, This afternoon, I added a genius wig in an attempt to look a little older and more experienced. Modified 2 months ago. He laughs when I poke his nose and tries to take toys out of my hand. 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. Trailhead Superbadge: Data Integration Specialist Challenge 1 Configure Outbound Application and Integration Security Install the unmanaged package from the prework if you haven't already. here's what's wrong: No. Can you please let me know what was the root cause? Anyway, sorry for bothering. This comment has been removed by the author. 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. Please check your work.What should be the values for both lens ?Waiting for your response.Thanks, Please share some details about what you have. Data Integration Specialist: Challenge 5 - Not Completing 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. "Create Seed Bank": {"action": "sfdcRegister","parameters": {"source": "CleanUp","alias": "Seed_Bank","name": "Seed Bank"alias punctuation. Check the required fields, field types, node name, and alias are correct. Step 6 is tricky! Many Git commands accept both tag and branch names, so creating this branch may cause unexpected behavior. Hi Trailhead Baby,Please help me. 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. "Create Seed Bank": {"action": "sfdcRegister","parameters": {"name": "Seed Bank Agencies","alias": "seed_bank_agencies","source": "CleanUp"- You need a different name and alias. Node Augment TempClass refers to field TempClass not present in right source. Process Builder sketch Last night, I drew a rough sketch of my process: Was it pretty? Step 5 - A quiz. The sketch allowed me to organize all of the instructions into a reasonable order before I started clicking. Check the required fields, field types, node name, and alias are correct. (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! 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 } ] } }, 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" } }}.