You need to sign in to do that
Don't have an account?
Jacky Vercoulen
Superbadge - Analytics data preparation specialist - challenge 3
Hi all,
Still get the error message of the challenge 3) Create Seed Bank Agencies:
Challenge Not yet complete... here's what's wrong:
We can't find Agency records in the Account object.
Tried to follow all the steps of other earlier questions, no success sofar. And start from scratch again Am i missing a step?
Please help me!
Still get the error message of the challenge 3) Create Seed Bank Agencies:
Challenge Not yet complete... here's what's wrong:
We can't find Agency records in the Account object.
Tried to follow all the steps of other earlier questions, no success sofar. And start from scratch again Am i missing a step?
Please help me!
Sorry for this issue you are facing.
May I suggest you please refer to below steps using which I have passed the challenge successfully.
Hope this helps.
Kindly mark this as solved if the reply was helpful.
Thanks,
Nagendra
All Answers
Sorry for this issue you are facing.
May I suggest you please refer to below steps using which I have passed the challenge successfully.
Hope this helps.
Kindly mark this as solved if the reply was helpful.
Thanks,
Nagendra
Getting below error
Could you please help mw on this,
Thanks
Arpit Jain
The dataflow saves successfully, however, when I run the dataflow, I receive the following:
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 when :: ;Case when Phone is not ; (02K6g000000dZ3dEAE_03C6g0000019WFdEAM)
This is what I have for the IsAgency field attributes:
Please let me know if additional information is needed.
Thanks!
Karen
For this error you have to recreate your Lense.
Make sure that you are following the prescribed steps properly.
Thanks
Aman
I actually just created a new developer org and started over from scratch. That worked for me. I didn't make any other changes and I passed Challenge/Step 3. Onward to Step 4!
Thanks for your assistance!
Karen
Can someone please tell help me to find what have i done in-correct here? i see 1 record as the highest account when i sort by name.
Hello All,
I creted a lens Top 5 Agencies but i don't know how to filter the barlength. Can anyone help me
Something went wrong while executing the Filter Agency Records node: Invalid Filter Expression=IsAgency:EQ:TRUE: Syntax Error at position [line 1: column 10] after token Unexpected character ':' :: ;IsAgency:EQ:TRUE;;
Edited it many times but still it shows this error
Any help would be appriciated.
Thanks,
Ravi
The thing is i'm getting 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.
Can anyone provide your valuable solutions !.
Hi @all, I am facing the same issue as veerendra b same error message same report same dataflow. I have also tried 3 new Eistein Dev Orgs and tried this multiple times.
Kindly mark this as solved if the reply was helpful.
Thanks
Rahul Jain
Could you please let me know how you have resolved this issue that may help me as well.
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.
Thank you so much!
https://developer.salesforce.com/forums/?id=9062I000000QyHpQAK
Error Message -
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.
Solution -
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.
Thank you so much Arnie, I really appreciate that.
tell me the correct
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)
I tried to do challenge multiple times still getting error like "Challenge Not yet complete... here's what's wrong:
We can't find Agency records in the Account object."
I tried the same in different trailhead orgs still I am not getting what is the issue.
Thanks,
Pratik
Thanks,
Xian
I am facing the same error while completing "Create Seed Bank Agencies" challenge in superbadge "CRM Analytics Data Preparation Specialist" . Need help.
Dataflow JSON:
{
"Filter Agency Records": {
"action": "filter",
"parameters": {
"source": "ID Agency Records",
"saqlFilter": "IsAgency==\"TRUE\""
}
},
"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": "Create Seed Bank Agencies",
"alias": "seed_bank_agencies",
"source": "Slice Field"
}
},
"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_2"
}
},
"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"
}
]
}
},
"Slice Field": {
"action": "sliceDataset",
"parameters": {
"mode": "drop",
"source": "Filter Agency Records",
"fields": [
{
"name": "IsAgency"
}
]
}
}
}
I was facing the same issue, and tried in several different ways to resovle.
Finally I was able to fix. While uploading the "Agency Detail.txt" dataset (had to modify and apply different changes while uploading this dataset), convert the Latitude and Longitude to Dimension, and keep the Acre as is. Recreated the dataflow from the sratch and this time it works fine.
Regards.
Yousuf Zaman.
Challenge Not yet complete... here's what's wrong:
We can't find Agency records in the Account object.
Make sure the field IsAgency is in the Create Seed Bank Agencies node output fields.
I removed IsAgency so my dataset matched the field list in Trailhead, got this error. Added it back in and passed the challenge.
Hope this helps.