Step 5 - A quiz. 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! 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. 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 ! Hi Trailhead Baby,Please help me. 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. Which of the Lenses are you working to create? 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. That is against Trailhead's terms of use. Here it goes! 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. These challenges are super tricky with syntax! Try leaving Precision and Scale blank for both low and high temp. Either the node didn't find any matches, or a join key contains only null values. 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. I'm having difficulty with challenge 3 for superbadge analytics data preparation specialist. Salesforce Data Analytics let us help you become a data driven organization and ensure your data is working hard for your business, This includes implementionSalesforce consulting companiesSalesforce ServicesStaff augmentation companiesSalesforce integration companiesSalesforce Implementation servicesSalesforce Health CheckSalesforce DevOpsManaged project services. Can you please post your JSON for the dataflow or at least the Define Temp Range and Add Temp Class nodes? Please contact me if anything is amiss at Roel D.OT VandePaar A.T gmail.com Note the filter. Data Integration Specialist Superbadge - Step 7 I'm getting an error message when triggering the SOAP call from the UI via record update: System.CalloutException: IO Exception: External server did not return any content When I import the WSDL into SOAP UI and send the same package body, I receive this message: HTTP /1.1 500 Server: Cowboy (It's a capitalization issue) },"Create Seed Bank": {"action": "sfdcRegister","parameters": {"name": "Seed Bank","alias": "Seed_Bank","source": "Calculate Acerage", Hi,I am stuck in step 6 Load Seed Bank Agencies w/Climate Data while running the data flow.Below is the ErrorSomething 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" ] } }}. @Maulik Vadodariya Just follow instruction .My issue been resolved .https://success.salesforce.com/answers?id=9063A000000lixEQAQ, I am so lost on step 6. Thank you for the pointers i made some new changes the data flow ran fine finally after the drill. Check the required fields, field types, node name, and alias are correct. If you are familiar with report and dashboards, this challenge should only take 30 or so minutes to complete. Tonight's challenge involves the creation of two processes. "Create Seed Bank": {"action": "sfdcRegister","parameters": {"source": "CleanUp","alias": "Seed_Bank","name": "Seed Bank"alias punctuation. Processes. Salesforce Trailhead Superbadge 'Data Integration Specialist' Data Integration Specialist is one of the superbadges of Salesforce trailhead (A New Approach to Learning Salesforce). Challenge 4 is not difficult if you follow the instructions precisely! Copyright 2000-2022 Salesforce, Inc. All rights reserved. Hi, I am getting the message: We can't validate the 'Create Seed Bank Agencies' node was created correctly. Step-2:- Then go to Setup-->Remote Site Settings-->New Remote Site. I'll look again through it Are your Latitude and Longitude uploads dimensions or measures? The best of luck! To review, open the file in an editor that reveals hidden Unicode characters. 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. Something that helped was saving the report frequently. Hi,Thanks for your reply. Want to post the revised json? When you start a create a new report, simply click to start with a clean screen. Hi ,i am getting " The dataflow was completed, but the LookupSingleValue node didn't augment any columns. @Trailhead Baby Can you post your JSON for the same? BTW thanks. Slack to Salesforce Integration using Apex Trigger, Test Class Not Covered. Please support me on Patreon: https://www.patreon.com/roelvandepaarWith thanks & pra. Its giving me a syntax error. I hope that you feel inspired. On to the next error LOL, Hi All,I am having a really hard time with Step 6. I just tried that and it I still keep getting this error. Check the required fields, field types, node name, and alias are correct. Thanks! },"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. Thank you so much Rebeca, My step 6 is resolved finally today. Looks like Naveen is having the same issue below! It's been a while. so I hope this is good advice! Challenge 4: Test automation logic. 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. 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. This special superbadge is designed to test how well you really grasped the underlying material and not just walk you through yet another predictable tutorial. 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 ProjectTrigger does not appear to be calling 'BillingCalloutService.callBillingService ()' and passing in the collection of old and new records. 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. Can you please let me know what was the root cause? Alias - is incorrect. Many Git commands accept both tag and branch names, so creating this branch may cause unexpected behavior. 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. 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 didn't dig any further once I saw the AccountNumber issue. . 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. Thanks a lot! I only see one temp.class on my lens- just the one with 155. Yes! 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. Are this numbers correct?Thanks, Antonio. Apex specialist superbadge challenge 4. Check the challenge and confirm required field setting." Search for an answer or ask a question of the zone or Customer Support. Challenge 2: Synchronize Salesforce data with an external system. What a sun of gun i had to change the dataset association and now works!! This is my journey- a normal kid by day- a Trailhead explorer by night. 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, I have the action as "filter", not "computeExpression". How frustrating! You also get personal insight into the life of a Trailhead Baby! Did it help? https://developer.salesforce.com/forums/?id=9060G0000005d3yQAA, Business Administration Specialist Superbadge- 3 & 4, Lightning Experience Reports & Dashboards Specialist Superbadge - 5-6, Process Automation Specialist Superbadge - 5. 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. This part is the JSON from the original Load Seed Bank challenge which executed without error. 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.