+ Start a Discussion
Md. Abdur Razzak.Md. Abdur Razzak. 

Einstein Analytics Data Preparation Specialist - Challenge#3

I am trying to pass the Einstein Analytics Data Preparation Specialist challenge#3 but got the following error -

 

Challenge Not yet complete... here's what's wrong:
We can't find the 'Create Seed Bank Agencies' node or required fields are missing. Check the challenge and confirm the node name, alias, and required fields.

can anyone please help me to overcome the issue. here are my files


User-added image
User-added image
{
  "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": "ShippingPostalCode"
        },
        {
          "name": "ShippingState"
        },
        {
          "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": [
        "Acres",
        "Currency",
        "Latitude",
        "Longitude",
        "Region",
        "SubRegion"
      ],
      "right": "Load Agency Detail",
      "relationship": "AgencyDetails",
      "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"
        }
      ]
    }
  }
}

Best Answer chosen by Md. Abdur Razzak.
Md. Abdur Razzak.Md. Abdur Razzak.
The problem was in 'Latitude', 'Longitude' field in 'Agency Detail' dataset. 
Whiile I was uploading the 'Agency Detail' file, I was changing the 'Latitude', 'Longitude' fields from 'Measure' to 'Dimension' as it should be. But to pass this challeng they have to be 'Measure' as they were by default.

All Answers

Md. Abdur Razzak.Md. Abdur Razzak.
The problem was in 'Latitude', 'Longitude' field in 'Agency Detail' dataset. 
Whiile I was uploading the 'Agency Detail' file, I was changing the 'Latitude', 'Longitude' fields from 'Measure' to 'Dimension' as it should be. But to pass this challeng they have to be 'Measure' as they were by default.
This was selected as the best answer
Jim Taber 2Jim Taber 2

Md. Abdur Razzak, thank you for posting you fix.  I made the same mistake and have ben grinding on this for hours.  Thank you.
Md. Abdur Razzak.Md. Abdur Razzak.
@Jim Taber 2, you are welcome. Good to hear that you have fixed the issue.