You need to sign in to do that
Don't have an account?
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
{
"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"
}
]
}
}
}
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
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.
Md. Abdur Razzak, thank you for posting you fix. I made the same mistake and have ben grinding on this for hours. Thank you.