Step 6 is tricky! Thank you so much Rebeca, My step 6 is resolved finally today. That would be cheating--- I'm happy to provide hints, but will never share answers. { "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? 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! Challenge 3: Schedule synchronization. (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. The dataset is created by the dataflow that you create. )https://developer.salesforce.com/forums/?id=9060G0000005d3yQAA ---> This thread was very heplful! Superbadge Apex Specialist looks good on Resume, and they prove worth it as well. Thanks! Just in case my JSON{ "Load Seed Chart": { "action": "edgemart", "parameters": { "alias": "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": { "source": "Calculate Acreage", "alias": "Seed Bank", "name": "Seed_Bank" } }}. !I can't copy here all the code, so I have copy in Gdrive. Processes. Can you suggest which super badge i should start with? error in challenge 6. Check the required fields, field types, node name, and alias are correct. No Even after that it is not working it says We can't find the 'Load Seed Chart' node in the dataflow. 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. Apex Specialist SuperBadge 5. 5. Which of the Lenses are you working to create? No. Hi I am completely new this superbadges. Challenge 2: Synchronize Salesforce data with an external system. "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" } ] } }}I had to copy in two comments, it was to large. Trailhead Superbadge: Data Integration Specialist - Forcetalks September 11, 2020 18088 0 Challenge 1 Configure Outbound Application and Integration Security Install the unmanaged package from the prework if you haven't already. 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. Thank you , please find my Json file , with the html limits i will be posting in 2 comments{ "Add Temp Class": { "action": "computeExpression", "parameters": { "source": "Define Temp Range", "mergeWithSource": true, "computedFields": [ { "name": "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\"", "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", "alias": "seed_bank", "source": "CleanUp" } }, "Load Seed Chart": { "action": "edgemart", "parameters": { "alias": "Seed_Chart" } }, "Augment Temp Class": { "action": "augment", "parameters": { "right_key": [ "TempClass" ], "left": "Load Temp Class Mapping", "left_key": [ "TempClass" ], "right_select": [ "Acreage", "hightemp", "Lifecycle", "lowtemp", "Quantity_Pounds", "Seed", "Seeds_Pound", "Seed_ID", "Seed_Type", "Spacing", "TempClass", "Temperature" ], "right": "Add Temp Class", "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": "TempClass" }, { "name": "TempKey" }, { "name": "Climate.lowtemp" }, { "name": "Climate.hightemp" } ] } }, "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 check your work. Fill Remote Site Name -->BillingService. 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. upsert directly against the ProjectRef__c external id field, https://developer.salesforce.com/forums/?id=9060G000000I526QAC, https://developer.salesforce.com/forums/?id=9060G000000I56rQAC. I have done ADMIN & PD1. "Load Climate": { "action": "edgemart", "parameters": { "alias": "Global_Climates"The syntax on this challenge was a bit. insane.It took a ton of trial and error to get the right Alias names. 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. 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. I'm happy to look at what you have and make suggestions. Configure a named credential and remote site according to the specifications outlined in the business requirements. Hi ,i am getting " The dataflow was completed, but the LookupSingleValue node didn't augment any columns. Yes! We can't find the Seed Bank dataset or required fields are missing. Check the challenge and confirm the node name and required fields.Below is my JSON details. ), Hi Steve - How did you fix the "We can't confirm these are the correct values in the lens. My brother has started to play with me! Step-2:- Then go to Setup-->Remote Site Settings-->New Remote Site. Check the challenge and confirm the node name and required fields. 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.