Skip to main content

Einstein Analytics Data Preparation Specialist Superbadge - 7


We are almost done with the Einstein Analytics Data Preparation Superbadge! Only one step left, and my brother took his first step today! Granted, his first step was while trying to take a swim in the "house pool," so I am going to have to keep an eye on him.  He is taking a nap now, so I can finish up this superbadge.

The best way to diagnose the JSON issue is to upload the file to a dataflow then try to run it.  You might see some errors like this.... so create the data set and fix the node. 

Once you clear the big error boxes, it's off to the data monitor to see what is causing the dataflow to fail.  The silly filter critera took me a while to sort out, so, after a few random guesses, I read up on filter expression syntax.  You can too: 
The rest of the fixes are fairly simple - a box to check, syntax error...etc.
HINT: You can't filter by a field that does not exist.







Comments

  1. UnknownMay 2, 2019 at 10:23 PM

    Many Thanks! You enlightened my way to get my very first Super Badge. God bless you.

    ReplyDelete
  2. UnknownJanuary 13, 2020 at 2:28 PM

    Just got the Superbadge - Many thanks for your assistance!

    ReplyDelete
  3. Nikhil SJuly 28, 2020 at 12:35 PM

    Pls mention the steps to solve the first error. RESOURCE NOT FOUND

    ReplyDelete
    Replies
    1. Trailhead BabyJuly 28, 2020 at 2:19 PM

      I believe that this is because the data set is not found. A "Seed Bank Orders" is referenced but not present.

      Delete
  4. JuliadhMay 4, 2021 at 2:17 PM

    Not sure how to fix this - Something went wrong while executing the Add Agency Fields node: Field [ShippingStreet] is missing in 1 out of 2 inputs - does this mean that street has to be in both Load Account and Load Agency datasets?

    ReplyDelete
  5. VivekJune 29, 2021 at 1:45 AM

    Dear Trailhead Baby,

    After being stuck for a while, I now successfully completed the Superbadge - Einstein Analytics Data Preparation Specialist. The guidance and comments provided in your blog was very apt and useful. Importantly, this process (of referring to your blog) has actually helped me learn - to think through when struck with a problem and seek out the possible solution to move forward.

    Its been 2 years since you first created this Superbadge_thread and still continues to be the best resource out-there. Your little brother must be now full of bountiful energy and running around - best wished to you and him to grow by leap and bounds.

    Thanks!

    ReplyDelete
  6. VidhyahMarch 1, 2022 at 12:39 AM

    Hi, I have completed Diagnose and Troubleshoot an Unsuccessful Data Load challenge 8.
    I have created the lens according to the requirment.. But still i am getting error
    "Challenge Not yet complete... here's what's wrong:
    We can't find the 'Load Seed Orders' node in the dataflow. Confirm the node name matches the name as described in the challenge."

    But i do have Node named "Load seed orders". If u dont mind can i share my JSON file?

    ReplyDelete
    Replies
    1. VidhyahMarch 1, 2022 at 2:32 AM

      This comment has been removed by the author.

      Delete
  7. VidhyahMarch 1, 2022 at 2:33 AM

    Hi,
    I tried in the new org and got through the challenge. Don't know what was wrong with the previous org... I even check in developer console and debug logs ,but the log was not created....Is there anywhere else to check the logs for Analytic studio?

    ReplyDelete
  8. AnonymousJune 16, 2022 at 1:15 PM

    Hi, need help on this last challenge. I have uploaded json file given and sorted out the issues. Data flow is getting executed and set got created and created a lens as per the requirement.
    But im getting error. We cannot confirm the correct values were found. Please check your work. CAn someone help me with this

    ReplyDelete
    Replies
    1. VidhyahJune 17, 2022 at 9:07 AM

      Hi, May i know what is the error?

      Delete
    2. AnonymousJune 18, 2022 at 4:57 AM

      Hi Vidhyah, below is the error
      "Challenge not yet completed.. here's what's wrong: We can't confirm the correct values were found.. please check your work"
      .. My data flow is getting executed without any error and dataset also got created and then lens.
      I tried many options which are available online and also re-created dataflows many times freshly.
      But no luck. Please help me

      Delete
    3. VidhyahJune 18, 2022 at 7:37 AM

      Sometime this happens for me too.. clear the browser cache and try again.. If that doesn't help try in a new org.

      Delete
  9. AnonymousJune 17, 2022 at 8:59 AM

    Hi Trailhead baby.. can you please give me some inputs over here.

    ReplyDelete

Post a Comment

Popular posts from this blog

Service Cloud Specialist Superbadge - 4,5,6,7

Part of doing the Service Cloud Specialist superbadge is trying new things, so I am putting up picture of new things that I've tried recently.  One of my favorite new things this week was taking a shower with my whole block collection.  Mom put me in the shower, and I sneaked out to grab the block bin and dumped it in.  I'm concerned to share photos because of the slight nudity, however, I can assure you that it was a glorious adventure.  Instead, I'll share my favorite Saturday new thing- walking to the coffee shop for a sprinkle donut!  Back to the superbadge... Challenge 4 Case Routing If you haven't taken the Onmi Channel module yet, now is a good time! I kept that particular module open one on screen while I walked through this step.  It is hard to give many hints about this step without giving away too many details - so - the best advice is to read through the challenge and label each step with the corresponding Salesforce term.  (IE - "The channel, Sto
171 comments
Read more

Service Cloud Specialist Superbadge - 1,2,3

A confession - I know next to nothing about service cloud.  While I was excited that a new superbadge was available, it made me a little nervous that I had to do all of the prerequisites and tackle new things like macros.  New things - new year - let's get started! (Right after I finish guitar practice) If you are also a service cloud novice, the Omni-Channel Basics is a crucial prerequisite even though it is not officially required. Challenge 1 App Appearance  This, like all superbadges, requires a careful read through the instructions prior to any clicking.  I found it helpful to take a separate notebook and write down the steps that I would need for each challenge step - for example -  My rough notes for challenge 1: Create 2 profiles  Tweak service Console 3 new items on utility bar Allow access for new profiles Create User  Beware - After editing the service console, you might have to edit the new profiles.  I found it necessary to click "edit&quo
122 comments
Read more

Business Administration Specialist Superbadge- 3 & 4

This afternoon, I added a genius wig in an attempt to look a little older and more experienced.  The free lemonade offer worked!  I made two dollars today!  A huge thank you to Jocelyn Fennewald , Salesforce MVP, for pointing out the "remove all columns" option within the report creator.  When you start a create a new report, simply click to start with a clean screen.  If you are familiar with report and dashboards, this challenge should only take 30 or so minutes to complete.  Below are tips and gotchas for each report / dashboard.  If you need more help, leave a comment! Reports Accounts by Market To create the "Market" row grouping, use a bucket field. Make sure that the correct date range is selected. High Value Residential  This report includes: 1 filter, 1 grouping, and 1 summarized field.  Rated Accounts by State The record count for state and account rating are automatically added. Note the filter.  Open Support Cases You ma
120 comments
Read more