+ 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