function readOnly(count){ }
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
+ Start a Discussion
Arnie UArnie U 

Superbadge - Analytics data preparation specialist - 3

Hi all,

I have extensively searched the communities and blog regarding this but am still getting an error:

"Challenge Not yet complete... here's what's wrong:
We can't validate the 'Create Seed Bank Agencies' node was created correctly. Check the required fields, field types, node name, and alias are correct."

I have created the Agency Detail Dataset, Completed the Dataflow, and Created the Lens:
Mosaic App
dataflowlense
{
  "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": "Phone"
        },
        {
          "name": "ShippingCity"
        },
        {
          "name": "ShippingCountry"
        },
        {
          "name": "ShippingState"
        },
        {
          "name": "ShippingPostalCode"
        },
        {
          "name": "ShippingStreet"
        }
      ],
      "object": "Account"
    }
  },
  "Create Seed Bank Agencies": {
    "action": "sfdcRegister",
    "parameters": {
      "name": "Seed Bank Agencies",
      "alias": "seed_bank_agencies",
      "source": "Filter Agency Records"
    }
  },
  "Add Agency Fields": {
    "action": "augment",
    "parameters": {
      "right_key": [
        "AccountNumber"
      ],
      "left": "Load Account",
      "left_key": [
        "AccountNumber"
      ],
      "right_select": [
        "Currency",
        "Acres",
        "Latitude",
        "Longitude",
        "Region",
        "SubRegion"
      ],
      "right": "Load Agency Detail",
      "relationship": "AgencyDetail",
      "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 \"FASLE\" end",
          "label": "IsAgency",
          "type": "Text"
        }
      ]
    }
  }
}
I have created 3 separate Einstein Dev Orgs tried more than 10+ times deleting recreating and still am encountering this issue. 

Can someone shed light on what I'm missing?
Best Answer chosen by Arnie U
Arnie UArnie U

Was able to solve this issue.
Error can't validate the 'Create Seed Bank Agencies' node was created correctly. Check the required fields, field types, node name, and alias are correct.

Fix: The issue is with the file (Agency Detail.txt) imported. While importing change the Longitude and Latitude data type from Measure to Dimension and do the required modification in the dataflow to report the Agency Detail file into this.

All Answers

ShirishaShirisha (Salesforce Developers) 
Hi Arnie,

Greetings!

We happen to see the similiar issues with the Analytics data preparation specialist superbadge recently.There is an appropriate team who can help you with these issues.

I would request you to reach out to the trailhead support here (https://trailhead.salesforce.com/help?support=home).

Kindly let me know if it helps you and close your query by marking it as best answer so that it can help others in the future.

Warm Regards,
Shirisha Pathuri 
Arnie UArnie U

Was able to solve this issue.
Error can't validate the 'Create Seed Bank Agencies' node was created correctly. Check the required fields, field types, node name, and alias are correct.

Fix: The issue is with the file (Agency Detail.txt) imported. While importing change the Longitude and Latitude data type from Measure to Dimension and do the required modification in the dataflow to report the Agency Detail file into this.

This was selected as the best answer
Prasanth S KPrasanth S K
Hey Arnie, Thank you so much for the solution, i really appreciate your help. Thank you!
Numidia BOUBADJOUNumidia BOUBADJOU
Thanks Arnie, changing the data type of the longitude and latitude fileds from measure to dimension worked for me. I just replaced the dataset by reimporting it. :)
Akeel WaniAkeel Wani
Hello @prasanth and others  who solved the challenge 3. I am facing difficulty with Challenge 3. 

I am getting this below error. Can anyone please help. 

Challenge Not yet complete... here's what's wrong:
We can't validate the 'Create Seed Bank Agencies' node was created correctly. Check the required fields, field types, node name, and alias are correct.


In the datflow I am getting below Error.

Something went wrong while executing the ID Agency Records node: invalid field expression for field 'IsAgency': Syntax Error at position [line 1: column 10] after token Unexpected character ':' :: ;IsAgency:EQ:TRUE; (02K5g000000SgrUEAS_03C5g000002MgvnEAC)

User-added image
User-added image

User-added image

User-added image




 
Sarita KushwahaSarita Kushwaha
Hi,I was stuck with the same issue yesterday and then I remembered a lesson where they suggested to change the datatype to dimension for lat and longtitude and I changed it but started getting different error. I am getting the below error:
Challenge Not yet complete... here's what's wrong:
We can't find Agency records in the Account object.

I have done everything so many times. Completed the rest of the challenges but stuck here to validate the next..Anyone faced similar issue?