data integration specialist superbadge challenge 5
Check the challenge and confirm the node name and required fields{ "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" } ] } }, "Load Seed Chart": { "action": "edgemart", "parameters": { "alias": "Seed_Chart" } }, "Load Temp Class Mapping": { "action": "edgemart", "parameters": { "alias": "Temperature_Classes_Mapping" } }, "Define Temp Range": { "action": "computeExpression", "parameters": { "mergeWithSource": true, "source": "Calculate Acreage", "computedFields": [ { "type": "Numeric", "name": "LowTemp", "label": "LowTemp", "saqlExpression": "string_to_number(substr(Temperature, 1, 2))", "precision": 18, "scale": 2 }, { "type": "Numeric", "name": "HighTemp", "label": "HighTemp", "saqlExpression": "string_to_number(substr(Temperature, -2, 2))", "precision": 18, "scale": 2 } ] } }, contd"Add Temp Class": { "action": "computeExpression", "parameters": { "mergeWithSource": true, "source": "Define Temp Range", "computedFields": [ { "type": "Text", "name": "TempClass", "label": "TempClass", "saqlExpression": "case when Temperature < \"25\" then \"Polar\" \nwhen Temperature >= \"25\" and Temperature <= \"50\" then \"Cool\" when Temperature >= \"51\" and Temperature <= \"85\" then \"Continental\" \nwhen Temperature > \"85\" then \"Tropical\" \nend", "precision": 18 } ] } }, "Augment Temp Class": { "action": "augment", "parameters": { "operation": "LookupSingleValue", "left": "Add Temp Class", "relationship": "Climate", "right": "Load Temp Class Mapping", "left_key": [ "TempClass" ], "right_key": [ "TempKey" ], "right_select": [ "TempClass" ] } }, "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" } }}. 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 ! I have the same nodes as you. yipeeeee ! I made it through all of the tempkey/temp class definitions, and everything appears to run fine but when I go to check the step in trailhead I get this "We can't validate the 'Create Seed Bank Agencies' node was created correctly" error. Hi Trailhead Baby,Please help me. Check the challenge and confirm required field setting. Here it goes! When validating the challenge, i'm getting an error stating this:-"Challenge Not yet complete here's what's wrong:We can't find the Seed Bank dataset or required fields are missing. 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. I only see one temp.class on my lens- just the one with 155. 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! Are you sure you want to create this branch? Data Integration Specialist Superbadge - Blogger Still stuck? 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. Node Augment TempClass refers to field TempClass not present in right source. What a sun of gun i had to change the dataset association and now works!! 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. Any insight you may be able to provide would be great. "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. Trailheads New Data Integration Specialist Superbadge is - LinkedIn Data Security Specialist Superbadge : Working with Data Categorization and Access | challenge 1Answer questions relating to the Data Categorization and Acces. },"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. I am the Trailhead Baby! Confirm the node name matches the name as described in the challenge.Here is the JSON, "Load Climate": { "action": "edgemart", "parameters": { "alias": "Load_Climate" } }. 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. @Shruthi, did you got the issue fixed? (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" ] } }}. Please check your work." Note the filter. I am getting this error from step 4 Challenge Not yet complete here's what's wrong:We can't find the 'Load Seed Chart' node in the dataflow. Disclaimer: All information is provided \"AS IS\" without warranty of any kind. "left_key": ["TempKey"],"right_key": ["TempClass"I think this is the issue. Here is my MaintenanceRequestHelper class. error in challenge 6. This would take away from the purpose of the superbadge. I was able to pass the above step and stuck at step # 6 for creating the lens.Challenge Not yet complete here's what's wrong:We can't confirm these are the correct values in the lens. thanks a lot. { "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. | 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). There could be a wide variety of issues, code could be right logically and different people get the error for different reasons. 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! Either the node didn't find any matches, or a join key contains only null values. That would be cheating--- I'm happy to provide hints, but will never share answers. ", Hey! Superbadge-Data-Integration-Specialist/Challenge #5/ProjectRESTService.cls Go to file Cannot retrieve contributors at this time 40 lines (33 sloc) 1.12 KB Raw Blame @RestResource ( urlMapping = '/project/*') global class ProjectRESTService { @HttpPost global static String postProjectData ( String projectRef, String projectName, },"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. Executive Report Tips: SolarBot Loyalty Revenue This report is tricky, but I don't want to give away the solution! Hi,i'm on challenge-6 and i created a dataflow called "Load Seed Bank Agencies w/Climate Data" but this dataflow is failing when i'm trying to run it.Error:Something went wrong while executing the Filter 2015 node: invalid field expression for field 'Date_Year': Syntax Error at position [line 1: column 11] after token Unexpected character ':' :: ;Date_Year:EQ:2015;posting JSON in other comment. Yes! It's free to sign up and bid on jobs. Onwards to Step #7.Karen, Could you please give me the final json? GitHub - robp2015/Copy-Superbadge-Data-Integration-Specialist Please reference ID: UAPSIKJH. 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. when i validate my step 6, i checked with existing suggestion via above posts i have corrected alias name and left key and right key for same name nothing worked and struck with from some now, please let me know what else i am missing !thankskiran. Superbadge Apex Specialist Full Solutions - Salesforce Handle You're on your own! Please contact me if anything is amiss at Roel D.OT VandePaar A.T gmail.com Data Security Specialist Superbadge | challenge 1: Working with Data A tag already exists with the provided branch name. Please check your work.Many thanks. 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. January 25, 2022 Data Integration Specialist Superbadge || Solutions || Easy Steps||All Challenges (1-10) Data Integration Specialist Challenge 1- (Quiz:Credential Security) :- Ans:-All of the above. 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. Is anyone working on this Superbadge or did I just got too late?I'm trying to get to this one: "Determine Optimal ClimatesBuild a dataflow to add temperature classes to the Seed Bank Agencies and Seed Bank datasets. Thanks! 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: The Trigger doesn't seem to be saving either on the Developer Console or the Apex Trigger in Setup. 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. I couldn't get through challenge 3 because I changed them to dimensions, and then now I had to change them back! 'Load Seed Bank Agencies w/Climate Data'{ "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" } ] } }, "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": "ShippingCity" }, { "name": "ShippingCountry" }, { "name": "ShippingPostalCode" }, { "name": "ShippingState" }, { "name": "ShippingStreet" }, { "name": "Phone" } ], "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:R:2015", "source": "Load Climate" } }, "Augment TempClass": { "action": "augment", "parameters": { "right_key": [ "Country" ], "left": "Filter Agency Records", "left_key": [ "ShippingCountry" ], "right_select": [ "TempClass" ], "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" } ] } }}Close. I'll look again through it Are your Latitude and Longitude uploads dimensions or measures? I understood! I solved this by putting the opportunity record and project record into separate list and performing DML on the list. Confirm the node name matches the name as described in the challenge. Apex specialist superbadge challenge 4 - Stack Overflow CRM Analytics Data Preparation Specialist | Salesforce Trailhead . If someone could guide me in the right direction, I'd really appreciate it. still i'm facing the same issue. hmm Could you post the json for the dataflow? This part is the JSON from the original Load Seed Bank challenge which executed without error. If you would like to start with something a little easier, I'd go for the Security Specialist. But then in the lens, I can't see the Acreage to sum by that. Challenge 5: Test callout logic.