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. 5. yipeeeee ! Hi , Load Seed Bank w/Temperature Classification when ran ,getting an error like below" The dataflow was completed, but the LookupSingleValue node didn't augment any columns. Import the Agency Data.txt file into the Account object in your CRM Analytics Developer Edition org. When I made mistakes, I simply reverted to the last saved version. The dataset is created by the dataflow that you create. (full disclosure-- I did this superbadge twice because I didn't fully understand the first timeso don't feel bad about being lost! Please check your work. If you are short on time, start around the 20 minute mark. 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. Confused? I can't find any instance of this same error anywhere. 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! Something that helped was saving the report frequently. Message: 550: To use null dimensions or date filters, you need API version 51 or higher. Why the change of heart? @trailhead baby,i just updated one alias name in above postsfrom :::"name": "Seed Bank","alias": "seed_bank"to:::"name": "Seed Bank","alias": "Seed_Bank"and re ran the dataflow still have the same old issue no progress ! Please reference ID: UAPSIKJH. Either the node didn't find any matches, or a join key contains only null values. Challenge 1: Automate record creation. 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, 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. 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. Confirm the node name matches the name as described in the challenge. Below are tips and gotchas for each report / dashboard. This commit does not belong to any branch on this repository, and may belong to a fork outside of the repository. OMG - I finally passed step #6.I totally redid the Load Seed Bank w/Climate and Load Seed Bank w/Temperature after I had to break down and have a Coke Zero after 3 yearslol.I also reloaded the datasets, etc.I have the final JSON if you want itThanks again. )https://developer.salesforce.com/forums/?id=9060G0000005d3yQAA ---> This thread was very heplful! I only see one temp.class on my lens- just the one with 155. Step-2:- Then go to Setup-->Remote Site Settings-->New Remote Site. Please check below post i hope that will help you. If you could just post the JSON for your data flow, I will take a look. Here is my Json in 2 messages if someone can help : { "Add Temp Class": { "action": "computeExpression","parameters": { "source": "Filter 2015", "mergeWithSource": true, "computedFields": [ { "defaultValue": "Continental", "name": "TempClass", "saqlExpression": "case \nwhen Temperature < 25 then \"Polar\" \nwhen Temperature >= 25 and Temperature <= 50 then \"Cool\" \nwhen Temperature >= 51 and Temperature <= 85 then \"Continental\" \nwhen Temperature > 85 then \"Tropical\" \nend", "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": "Name" }, { "name": "Phone" }, { "name": "ShippingCity" }, { "name": "ShippingCountry" }, { "name": "ShippingPostalCode" }, { "name": "ShippingStreet" }, { "name": "ShippingState" }, { "name": "AccountNumber" } ], "object": "Account" } }, 2nd part of Json : "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 Agency detail": { "action": "edgemart", "parameters": { "alias": "Agency_Detail" } }, "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": [ "Temperature", "Date", "TempClass", "Country" ], "right": "Add Temp Class", "relationship": "Climate", "operation": "LookupSingleValue" } }, "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" } ] } }}Thanks for help, Hi, I have a problem with the step 6: When I run the DataflowLoad Seed Bank Agencies w/Climate Data it give me this error: Something went wrong while executing the Augment TempClass node: Right select in augment node must properly refer to the right input column. "Awaiting a helpful response.Thanks,Mithilesh. Hi there.I made the changes as you suggested and still receiving the same error. Looks like Naveen is having the same issue below! There are a couple of YouTube channels that cover almost every Superbadge step . If someone could be so kind to support, that would really be helpful.Thanks a lot. Right now he' taking a nap.so I'm off to edit some reports! "left_key": ["TempKey"],"right_key": ["TempClass"I think this is the issue. I'll look again through it Are your Latitude and Longitude uploads dimensions or measures? i changed "name" to "seed bank". The data flow is running properly. He laughs when I poke his nose and tries to take toys out of my hand. | 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). Learn more about bidirectional Unicode characters. Want to post the revised json? 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. i'm not able to understand what exactly is wrong with my approach.My approach:1. uploaded Seed Chart.txt from resource to create a dataset in mosiac app.2. "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. 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. 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. Here is my MaintenanceRequestHelper class. { "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" } ] } }}. @Trailhead Baby Can you post your JSON for the same? Ask Question Asked 1 year, 3 months ago. Getting below error. If you encounter this error.. You are, perhaps, taking the instructions too literally and need to tweak the formula. 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! 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. But then in the lens, I can't see the Acreage to sum by that. First I create a min and max temp, then how do I use two fields to get a temperature category? It looks like the order of operations is a tiny bit out of order. { "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. "name": "Create Seed Bank" - This is incorrect. Search for jobs related to App customization specialist superbadge challenge 5 or hire on the world's largest freelancing marketplace with 22m+ jobs. Thank you so much Rebeca, My step 6 is resolved finally today. Its giving me a syntax error. upsert directly against the ProjectRef__c external id field, https://developer.salesforce.com/forums/?id=9060G000000I526QAC, https://developer.salesforce.com/forums/?id=9060G000000I56rQAC. "{ "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.