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
Jacky VercoulenJacky 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! 
Best Answer chosen by Jacky Vercoulen
NagendraNagendra (Salesforce Developers) 
Hi Jacky,

Sorry for this issue you are facing.

May I suggest you please refer to below steps using which I have passed the challenge successfully.
User-added imageUser-added imageHope this helps.

Kindly mark this as solved if the reply was helpful.

Thanks,
Nagendra

All Answers

NagendraNagendra (Salesforce Developers) 
Hi Jacky,

Sorry for this issue you are facing.

May I suggest you please refer to below steps using which I have passed the challenge successfully.
User-added imageUser-added imageHope this helps.

Kindly mark this as solved if the reply was helpful.

Thanks,
Nagendra
This was selected as the best answer
Jacky VercoulenJacky Vercoulen
Thanks Nagendra, passed the challenge. Started all over again and created the new lens. 
Badal ChaudharyBadal Chaudhary
Please tell me how to solve this error we  can't find agency records in account object
Hongda ZhouHongda Zhou
Make sure the Name of the Register step to be:  Sead Bank Agencies and Alias :  seed_bank_agencies
Arpit Jain7Arpit Jain7
HI Team,

Getting below error

User-added image

Could you please help mw on this,

Thanks
Arpit Jain
Karen MezatastaKaren Mezatasta
I am also receiving the same message as Arpit Jain:

User-added image
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:

User-added image

Please let me know if additional information is needed.

Thanks!
Karen
Aman203Aman203
Hi Arpit & Karen,

For this error you have to recreate your Lense.
Make sure that you are following the prescribed steps properly.

Thanks 
Aman
Karen MezatastaKaren Mezatasta
Hi 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
Yatin Vichare 6Yatin Vichare 6
Hi Guys,
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. User-added image
Sudharsan C 27Sudharsan C 27
User-added image

Hello All,

I creted a lens Top 5 Agencies but i don't know how to filter the barlength. Can anyone help me
 
Raviteja KethuriRaviteja Kethuri

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;;

User-added image
Edited it many times but still it shows this error

 

Any help  would be appriciated.

Thanks,
Ravi

veerendra bveerendra b
Hi @all I am facing an issue in Einstein Analytics Data Preparation Specialist Superbadge step-3.i have followed all the steps as per creteria and deleted and created the dataset around 10 times and created 3new orgs to find the issue. but still getting the same error

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 !.User-added imageUser-added image
Arnie UArnie U

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.

Arnie UArnie U
Thanks verrandra, that fixed my issue.
Sribhargav ArcotSribhargav Arcot
Hi @Raviteja kethuri, we have to use filter here, not SAQL. So, uncheck use SAQL checkbox and give same expression.
Rahul Jain 208Rahul Jain 208
Hi @Raviteja kethuri, uncheck  SAQL checkbox and give same expression .
User-added image

Kindly mark this as solved if the reply was helpful.
Thanks 
Rahul Jain 
Prasanth S KPrasanth S K
Hi @arnie @Veerendra - I am facing the same issue as yours, i have tried multiple times in multiple orgs but same error message.
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!
Prasanth S KPrasanth S K
Hey Everyone, i have fixed the issue through Arnie's solution here 
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. 
Ranajit dond 1Ranajit dond 1
Something went wrong while executing the ID Agency Records node: invalid field expression for field 'IsAgency': Syntax Error at position [line 1: column 54] after token ; :: ; else "FALSE";; (02K2y000000U6fnEAC_03C2y000000qQHEEA2)


tell me the correct 
 
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)

My Dataflow
Dataflow Error

User-added image

User-added image

 
Pratik Kumar 67Pratik Kumar 67
Hi All,

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
 
Xian DingXian Ding
I am facing the same issue as Pratik. I uploaded agency data into Account Object successfully. The newly added data is not picked up in my dataflow. Even though my script is correct, I am not able to work on Top 5 Agency Lens as the agency records are not loaded. Please advise. 

Thanks,
Xian
Xian DingXian Ding
I know where I went wrong. after uploading data into Account, go to connect and hit 'sync' so that new records are added. 
Yousuf ZamanYousuf Zaman
Hi All,
I am facing the same error while completing "Create Seed Bank Agencies" challenge in superbadge "CRM Analytics Data Preparation Specialist" . Need help.
User-added image

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"
        }
      ]
    }
  }
}
Yousuf ZamanYousuf Zaman
Hi,
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.
Carol Moynham 22Carol Moynham 22
With this error
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.