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. I am getting this error despite all the dataflows successful. Thanks! Reports Accounts by Market To create the "Market" row grouping, use a bucket 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. Thanks Ill have to put this in two post. ), Hi Steve - How did you fix the "We can't confirm these are the correct values in the lens. I'll look again through it Are your Latitude and Longitude uploads dimensions or measures? I have the same nodes as you, but I dont understand how you are supposed to multi join or the two nodes before that. Hi ,i am getting " The dataflow was completed, but the LookupSingleValue node didn't augment any columns. It's been a while. so I hope this is good advice! I think I have the correct dataflow "Load Seed Bank Agencies w/Climate Data" What could it be? Trademarks are property of their respective owners. There is not a field named Acreage in the zip file - It is a field you create by calculation within the data flow. Processes. },"CreateSeedBankAgencies":{"action":"sfdcRegister","parameters":{"name":"SeedBankAgencies","alias":"seed_bank_agencies","source":"AugmentTempClass"I have different spacing in the name.My original thought was with the "augument" step- because I have seen this throw errors a ton of times if "account number" was not explicitly selected in both data sets. If you encounter this error.. You are, perhaps, taking the instructions too literally and need to tweak the formula. ok, I got through the other errors. If you could just post the JSON for your data flow, I will take a look. I am stuck at step 6 of Einstein Analytics Data Preparation Specialist super badge.Message:Challenge Not yet complete here's what's wrong:We can't confirm these are the correct values in the lens. We can't find the Seed Bank dataset or required fields are missing. Challenge Not yet complete. When you start a create a new report, simply click to start with a clean screen. I just tried that and it I still keep getting this error. 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. Now, Check the challenge Challenge 2- (Configure outbound application and integration Security) :- Step-1:- Install the unlocked package with package id: 04t6g000008arl1AAA (For All Users). Various trademarks held by their respective owners. Please check your work." #dataintegrationspecialist##techinvisible#superbadgeagentDo follow on instagram for complete superbadge access :https://www.instagram.com/tech_invisible/ Challenge 4 is not difficult if you follow the instructions precisely! 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. let me know what i am missing here. If you are familiar with report and dashboards, this challenge should only take 30 or so minutes to complete. Getting the below error:Challenge Not yet complete here's what's wrong: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. Any insight you may be able to provide would be great. Hi man, have you been able to solve this? Something that helped was saving the report frequently. The trickiest part is the formulas for Definie Temp Range and Add TempClass. Node Augment TempClass refers to field TempClass not present in right source. Configure a named credential and remote site according to the specifications outlined in the business requirements. i have completed my step 7 already but could not proceed because of step 6 issues. The dataset is created by the dataflow that you create. such a silly mistake it was and i was stuck there for long. 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: 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. After you've imported the Account object, you'll be ready to tackle the challenges. It was the Long/Lat settings in the Agency Detail upload. Step 6 is tricky! I am also stuck in Challenge4. Right now he' taking a nap.so I'm off to edit some reports! Here is my MaintenanceRequestHelper class. 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. How frustrating! Copyright 2000-2022 Salesforce, Inc. All rights reserved. Thank you for the pointers i made some new changes the data flow ran fine finally after the drill. 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. 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? "Create Seed Bank": {"action": "sfdcRegister","parameters": {"source": "CleanUp","alias": "Seed_Bank","name": "Seed Bank"alias punctuation. I don't understand what you mean. 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! Confirm the node name matches the name as described in the challenge.Here is the JSON, "Load Climate": { "action": "edgemart", "parameters": { "alias": "Load_Climate" } }. Yes! yipeeeee ! I have higher numbers for all. Please check below post i hope that will help you. { "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": "Create Seed Bank", "alias": "Create_Seed_Bank", "source": "Calculate Acreage" } }, "Load Seed Chart": { "action": "edgemart", "parameters": { "alias": "Seed_Chart" } }}. 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. 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. Please check your work. Rated Accounts by State The record count for state and account rating are automatically added. Salesforce: Trailhead : Data Integration Specialist Challenge 5Helpful? 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. (02K7R000000pt8bUAA_03C7R000004QOLfUAO)I send the Json of this nodeNode Name Augment TempClassLeft Source["Filter Agency Records"]Left Key["ShippingCountry"]RelationshipClimateRight Source["Add Temp Class"]Right Key["Country"]Right Fields["TempClass","Country","Date","Temperature"]OperationLook Up Single ValueThanks in advance for your help, HI while trying to complete Determine Optimal Climates challenge Any Idea why am getting this Error "There was an unhandled exception. 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,Thanks for your reply. Sorry but where i can get the right alias and name, and this goes beyond the question. 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. If you would like to start with something a little easier, I'd go for the Security Specialist. Thank you. hmm Could you post the json for the dataflow? Note the filter. 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. Getting below error. Here it goes! oops i got it solved. | Content (except music \u0026 images) licensed under CC BY-SA https://meta.stackexchange.com/help/licensing | Music: https://www.bensound.com/licensing | Images: https://stocksnap.io/license \u0026 others | With thanks to user TSmith (salesforce.stackexchange.com/users/30493), user John Mutuma (salesforce.stackexchange.com/users/68710), user Daniel Deepak (salesforce.stackexchange.com/users/73968), and the Stack Exchange Network (salesforce.stackexchange.com/questions/300749). The dataflow was completed, but the LookupSingleValue node didn't augment any columns. 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. I hope to inspire all of the worlds trailblazers to learn, grow, and experience! Challenge 5: Test callout logic. I am stuck on creating the test class for the challenge 4 in a propper way. BTW thanks. :(, {"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. * Email Alerts I needed the Email Alerts set up before I could create either the process or the approval. 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. { "Load Seed Chart": { "action": "edgemart", "parameters": { "alias": "Seed_Chart" } }, "Calculate Acerage": { "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 Acerage" } }}It will be helpful for me if someone tells me why I am getting this.