data integration specialist superbadge challenge 5

Error: Restforce::ResponseError. 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. If you could just post the JSON for your data flow, I will take a look. Challenge 4: Test automation logic. Getting the following warning when running the dataflow:Load Seed Bank Agencies w/Climate DataThe dataflow was completed, but the LookupSingleValue node didn't augment any columns. If you post your revised JSON, I'll take a look. Message: 550: To use null dimensions or date filters, you need API version 51 or higher. If you are short on time, start around the 20 minute mark. @Trailhead Baby Can you post your JSON for the same? If someone could guide me in the right direction, I'd really appreciate it. Confused? I am stuck on creating the test class for the challenge 4 in a propper way. "However, I'm getting this error:"The dataflow was completed, but the Augment TempClass node didn't augment any columns. Challenge 5: Test callout logic. Salesforce Trailhead Superbadge 'Data Integration Specialist' Data Integration Specialist is one of the superbadges of Salesforce trailhead (A New Approach to Learning Salesforce). Data Security Specialist Superbadge : Working with Data Categorization and Access | challenge 1Answer questions relating to the Data Categorization and Acces. Check the challenge and confirm the node name and required fields.Below is my JSON details. 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. The superbadge is specially designed for learning and testing integrations between different systems. Please check your work. Copyright 2000-2022 Salesforce, Inc. All rights reserved. This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. Apex Specialist SuperBadge 5. My bad. "Create Seed Bank": {"action": "sfdcRegister","parameters": {"source": "CleanUp","alias": "Seed_Bank","name": "Seed Bank"alias punctuation. Name capitalized, alias not capitalized. Making dinner for Mom! Alias - is incorrect. 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. 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\"" } ] } }, 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" ] } }}, Following error:Challenge Not yet complete here's what's wrong:We can't validate the 'Create Seed Bank Agencies' node was created correctly. Take a break, grab a snack, and watch this video. Please support me on Patreon: https://www.patreon.com/roelvandepaarWith thanks & pra. Reports Accounts by Market To create the "Market" row grouping, use a bucket field. So close! "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 ProjectTrigger does not appear to be calling 'BillingCalloutService.callBillingService ()' and passing in the collection of old and new records. 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. Please contact me if anything is amiss at Roel D.OT VandePaar A.T gmail.com I hope that you feel inspired. No. Load Seed Bank w/ Temperature Classification, This afternoon, I added a genius wig in an attempt to look a little older and more experienced. I've recreated the steps a number of times, and I am pretty sure all of my nomenclature is correct. I am the Trailhead Baby! Are you sure you want to create this branch? Process Builder sketch Last night, I drew a rough sketch of my process: Was it pretty? "{ "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. Hey,Hope by this time you have got your answer if not,Please change the alias you will get through challenge 6. upsert directly against the ProjectRef__c external id field, https://developer.salesforce.com/forums/?id=9060G000000I526QAC, https://developer.salesforce.com/forums/?id=9060G000000I56rQAC. If you are familiar with report and dashboards, this challenge should only take 30 or so minutes to complete. 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. PLEASE HELP ME !!!! 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"). 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. No. { "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" } }}, },"Seed Bank": {"action": "sfdcRegister","parameters": {"rowLevelSecurityFilter": "","name": "seedbank","alias": "seedbank","source": "Calculate Acreage"Wrong alias and name, Hi allI am having a really hard time with 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. wrong data? Getting below error. Data Integration Specialist Superbadge - Step 7 - CyberSource "Create Seed Bank": {"action": "sfdcRegister","parameters": {"name": "Seed Bank Agencies","alias": "seed_bank_agencies","source": "CleanUp"- You need a different name and alias. 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. That is against Trailhead's terms of use. 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. Yes! },"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. It looks like the order of operations is a tiny bit out of order. . 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! 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. Has anyone seen this?CJ, I will take a look at the JSON if you post it, {"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"}]}}}, Thank you for the quick reply! I'm having difficulty with challenge 3 for superbadge analytics data preparation specialist. Data Integration Specialist: Challenge 5: Why Is This Not Working? This may even include some fields on objects being referenced in your code not being assigned to the user profile for the user in context. I am stuck at the SAQL Expression field for 'Calculate Acreage'. ", Hey! Thanks a lot! Below are tips and gotchas for each report / dashboard. Copyright 2000-2022 Salesforce, Inc. All rights reserved. "Create Seed Bank": {"action": "sfdcRegister","parameters": {"source": "Calculate Acreage","alias": "Seed Bank","name": "Seed_Bank"Wrong alias and name. First of all , thanks for prompt reply. @shruthi"name": "Seed Bank","alias": "Seed_Chart",alias has to be Seed_Bank as well , let me know if that works out ! Any insight you may be able to provide would be great. I have finally made the super badge today ! There is not a field named Acreage in the zip file - It is a field you create by calculation within the data flow. No Even after that it is not working it says We can't find the 'Load Seed Chart' node in the dataflow. This would take away from the purpose of the superbadge. Define Temp Range- I needed help to figure this one out as well!string_to_number( substr(Temperature,1,2)) for Lowstring_to_number(substr(Temperature,-2,2)) for HighAdding the Temp Class: The SAQL starts with casewhen lowTemp < 25 and highTemp < 25 then "Polar" - then you define the rest of the ranges. The trickiest part is the formulas for Definie Temp Range and Add TempClass. { "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" } }, "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" } ] } }}. * Email Alerts I needed the Email Alerts set up before I could create either the process or the approval. 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. Challenge 4 is not difficult if you follow the instructions precisely! You are responsible for your own actions. You're on your own! This part is the JSON from the original Load Seed Bank challenge which executed without error. Either the node didn't find any matches, or a join key contains only null values." Einstein Analytics Data Preparation Specialist Superbadge - 4,5,6 - Blogger let me know what i am missing here. },"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. Superbadge- analytics data preparation specialist- challenge 3 Leave a comment for the Trailhead Baby! "Awaiting a helpful response.Thanks,Mithilesh. I am stuck at Challenge 6,7 . i have completed my step 7 already but could not proceed because of step 6 issues. (Trailhead Baby was 'gone fishing' this weekend, and didn't check for comments! Thanks Ill have to put this in two post. 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! 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. Either the node didn't find any matches, or a join key contains only null values. Did it help? Ask Question Asked 1 year, 3 months ago. Check the required fields, field types, node name, and alias are correct.