Superbadge Einstein Analytics Data Specialist Step 3 Error: 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. - Answers - Salesforce Trailblazer Community
Trailblazer Community
Ask Search:
Jhili PatraJhili Patra 

Superbadge Einstein Analytics Data Specialist Step 3 Error: 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.

Superbadge Einstein Analytics Data Specialist Step 3 Error: 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.

User-added image
Best Answer chosen by Jayson (salesforce.com) 
Divya ChoudharyDivya Choudhary
Sure , Ankush

Here is the JSON:
{
  "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": "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": "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": [
        {
          "defaultValue": "FALSE",
          "name": "IsAgency",
          "saqlExpression": "case when Phone is not null then \"TRUE\" else \"FALSE\" end\n",
          "label": "IsAgency",
          "type": "Text"
        }
      ]
    }
  }
}


And here is Dashborad snapshotUser-added image
 

All Answers

Ankush AgarwalAnkush Agarwal
Hi Jhili,

You may refer below link to complete Challenge 3:

https://developer.salesforce.com/forums/?id=9060G0000005d3yQAA
Kundan Kumar JhaKundan Kumar Jha
Hii,

  You can verify your steps using below link :

    https://www.youtube.com/watch?v=Gl1q_xGzGGo
  
   https://trailheadbaby.blogspot.com/2019/03/einstein-analytics-data-preparation_8.html

   https://developer.salesforce.com/forums/?id=9060G0000005dSyQAI

Thanks!
Swapnil MoreSwapnil More
Hi ,

I am also getting same error. I have completed all steps

Thanks!
Ankush AgarwalAnkush Agarwal
Hi Swapnil, Jhil,

I rectified this error after comparing with screenshot provided by LinThaw in below link:

https://developer.salesforce.com/forums/?id=9060G0000005d3yQAA
Swapnil MoreSwapnil More
Hi Ankush,

Thanks for your help. I verified each node as per above post still getting issue..
Jhili PatraJhili Patra
Hello Ankush and Swapnil, though I have verified everthing the error is still same. Dont know why its behaving so weird. I am pissed up from yesterday. validated each steps and not finding any fault.

 
Divya ChoudharyDivya Choudhary
I am also facing the same issue, checked the same from given Link and LinThaw's screenshots. Still no luck
Swapnil MoreSwapnil More
Hi Jhili,
I am also facing this issue since yesterday. I verified lense also and getting proepr result.
Ashley CampisanoAshley Campisano
I am also facing this issue since yesterday despite having the same code/completing the same steps from the links/forums.
Ankush AgarwalAnkush Agarwal
Hi All,

You may refer JSON which I used to pass this challenge:

Error may be due to name/alias
 
{
  "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": "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": "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": [
        {
          "defaultValue": "FALSE",
          "name": "IsAgency",
          "saqlExpression": "case when Phone is not null then \"TRUE\" else \"FALSE\" end\n",
          "label": "IsAgency",
          "type": "Text"
        }
      ]
    }
  }
}

 
Jhili PatraJhili Patra
Hello Ankush,
Thank you. Need one more input.
I imported Agecy Detail.txt file without any modification. Does it require any modification while importing(chaing any fields from measure to dimension or viceversa)

Dimension--AccountNumber/region/SubRegion/Currency
Measures--
Latitude/Longitude/Acre


Thanks.
Divya ChoudharyDivya Choudhary
Thanks for sharing Ankush. I uploaded this JSON, but  it still throws the same error.
Was anybody able to solve it ?
Swapnil MoreSwapnil More
Thank you Ankush for JSON File. I uploaded json file but getting same error.
Ankush AgarwalAnkush Agarwal
Hi Jhili,

As per my understanding no changes required.

Hi Divya & Swapnil,

You might have downloaded your JSON and compared with mine one. I am also not sure what could be the reason. 

You may verify lens as well. I am attaching it:

User-added image
 
Swapnil MoreSwapnil More
Hi Ankush, Please find below screenshot of Top 5 Agencies lense.
Swapnil MoreSwapnil More
Hi Ankush,
Lens is same. Dont know what is missing here.

Thanks,
Swapnil
Ankush AgarwalAnkush Agarwal
Can you share your dataset screenshot and JSON. I will compare with mine
Swapnil MoreSwapnil More
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": "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": "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": "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": [
        {
          "defaultValue": "FALSE",
          "name": "IsAgency",
          "saqlExpression": "case when Phone is not null then \"TRUE\" else \"FALSE\" end\n",
          "label": "IsAgency",
          "type": "Text"
        }
      ]
    }
  }
}
Jhili PatraJhili Patra
Hello Everyone.

Woo--Hooo the issue is fixed.
Issue is with the Agency Detail.txt file. While Importing the file please change the Longtitude and Latitude to to "Dimension".
Delete the file from existingf dataflow and perform Edgemart again to import the same file. Update your dataflow and run it. It will get Pass.

Please let me know if you find any issue.

:)
Divya ChoudharyDivya Choudhary
Sure , Ankush

Here is the JSON:
{
  "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": "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": "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": [
        {
          "defaultValue": "FALSE",
          "name": "IsAgency",
          "saqlExpression": "case when Phone is not null then \"TRUE\" else \"FALSE\" end\n",
          "label": "IsAgency",
          "type": "Text"
        }
      ]
    }
  }
}


And here is Dashborad snapshotUser-added image
 
This was selected as the best answer
Swapnil MoreSwapnil More
Thank You Jhili. I am able to clear step.
Ashley CampisanoAshley Campisano
Thank you so much Jhili! I was able to pass the step also.
Gunjan AswaniGunjan Aswani
For those who are still not able to resolve the error by steps suggested by Jhilli 
To solve this error 
"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."

1. Delete your existing Agency Detail dataset from Data Manager > Data 
2. Delete your existing Load Seed Bank Agencies Dataflow
3. Create Data Set > Upload Agency Detail File > Select  Latitude and Longitude fields from Measure to Dimension
4. Now, Create new dataflow with the name Load Seed Bank Agencies.

NOTE: This time, Follow the right order while creating Add Agency Fields augment in the section Right Fields

Currency
Acres
SubRegion
Region
Latitude
Longitude
User-added image

Give thumbs up if it resolved your error.

Thanks,
Gunjan Aswani
Divya ChoudharyDivya Choudhary
Thank you @Jhili , It worked.
Andrew RennieAndrew Rennie
@Jhili you're my hero! I almost made those dimensions when loading the data set but thought that we might need to do some math on them... what a good catch. I will say that rather than deleting the dataset and deleting the dataflow and re-creating them I just replaced my data in the data set and finally passed step 3 
Chris UnittChris Unitt
Thank you @Jhili this also worked for me! I was about to raise a case about it because it was not clear why it was failing. It does not say anywhere that you need to change the lat/long to a dimension and as Andrew says above it is reasonable to expect lat/long values to be treated as numeric.
Vamsi Prakash ThutupalliVamsi Prakash Thutupalli
Thanks a lot Jhili Patra.This also worked for me! 
Shreyas GavitShreyas Gavit
Thank you so much Jhili! That worked for me too been frustrated about this issue for the past few hours until I came across this post! 
Zach EpsteinZach Epstein
It's still giving me the "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."
Attaching a JSON below, if anyone can provide some insight it'd be much appreciated!
{
  "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": [
        "Currency",
        "Acres",
        "Latitude",
        "Longitude",
        "Region",
        "SubRegion"
      ],
      "right": "Load Agency Detail",
      "relationship": "AgencyDetail",
      "operation": "LookupSingleValue"
    }
  },
  "Load Agency Detail": {
    "action": "edgemart",
    "parameters": {
      "alias": "Agency_Detail1"
    }
  },
  "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"
        }
      ]
    }
  }
}

 
Ankush AgarwalAnkush Agarwal
Below line is stoping you to complete the challenge

"alias": "Agency_Detail1"

You are using dataset Agency Details instead of Agency Detail.

You may delete both the dataset and recreate with correct name.
Mehboob AlamMehboob Alam
Thanks @Gunjan Aswani, It worked. 
Rickard LarneRickard Larne
Thank you, Jhili...you are a superstar!
jitendra nimjejitendra nimje

@jhili thank you

for those who are not able to delete the Agency Detail dataset under data can try this alternative solution 

go to Data Manager> data> select Agency Detail and click on the inverted triangle and select edit dataset

User-added image

click replace data and upload your Agency detail.txt file again and click next

User-added image

under Latitude and longitude fields change the field type to Dimension from measure and click upload

also you can use JSON attached below:

{
  "Filter Agency Records": {
    "action": "filter",
    "parameters": {
      "filter": "IsAgency:EQ:TRUE",
      "source": "ID Agency Records"
    }
  },
  "Load Account": {
    "action": "sfdcDigest",
    "parameters": {
      "fields": [
        {
          "name": "Name"
        },
        {
          "name": "AccountNumber"
        },
        {
          "name": "Phone"
        },
        {
          "name": "ShippingCity"
        },
        {
          "name": "ShippingCountry"
        },
        {
          "name": "ShippingState"
        },
        {
          "name": "ShippingStreet"
        },
        {
          "name": "ShippingPostalCode"
        }
      ],
      "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",
        "Region",
        "SubRegion",
        "Latitude",
        "Longitude"
      ],
      "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 \"FALSE\" end",
          "label": "IsAgency",
          "type": "Text"
        }
      ]
    }
  }
}
Tom MoTom Mo
IT really IS about the "Load Agency Detail" node issue.
Both "Latitude" and "Longitude" should be changed to dimension type. Otherwise challenge 3 will never pass.
I was stucked for a long time until finding the thread. Thanks a lot Jhili Patra. :)
Gilmar AmaralGilmar Amaral
Thanks Jhili Patra, just changes Latitude and Longitude to dimension and everything worked fine.