+ Start a Discussion
LinThawLinThaw 

Einstein Analytics Data Preparation Specialist #3

Hi,

I got following error on step 3.

Challenge Not yet complete... here's what's wrong: 
Couldn’t find Agency records from the Account object.

Can anyone pass this step?
Thanks in advance.

Regards,
LinThaw
Best Answer chosen by LinThaw
LinThawLinThaw
Hi Jennifer and ankita,

Please refer below, I passed this step 3.

fig 1.
User-added image

fig 2.
User-added image


and create Top 5 Agencies lenses.

Regards,
LinThaw

All Answers

Brian KesslerBrian Kessler
I'm also stuck on this step.  I'm not sure if I'm ahead of you or behind you, but my error is:
 
Challenge Not yet complete... here's what's wrong: 
Couldn’t find 'Create Seed Bank Agencies' node. Please check the name and alias spelling.

I feel like I'm really struggling to either create the correct dataflow and/or interpret what the requirement means by "node" correctly.
I don't feel that the 3 measily prerequisite Trailheads provided a solid foundation for completing this superbadge, or even making a go of it.

(Maybe the prerequisites for the other superbadges weren't more thorough, but having done all the others, I didn't feel so ill-prepared from actual experience... but then to be honest, data analytics is about as far from my BAU as SFDC can get.)


 
Michele Losch 4Michele Losch 4
Lin- I'm getting the same error. 
Brian- I initially got the error you are getting. Make sure the dataset is saved to the correct app. 
ankita varma 3ankita varma 3
Hey, I want to know about the IsAgency field, how to create it and where?
Avnish SharmaAvnish Sharma
Hi Michele Losch
If you haven't completed the Analytics Basics module , please go there first. You'll need to sign up for a special Developer Edition org before you can do this module.

Thanks!
ankita varma 3ankita varma 3
Something went wrong while executing the Seed Bank Agencies node: Invalid schema: Error, Invalid key name: %!(EXTRA string=Account Agency Fields.Latitude) (02K7F000000An3cUAC_03C7F000001CkF9UAK)

Not able to create dataset, while running the dataflow I am getting above error. What am I doing wrong?
Avnish SharmaAvnish Sharma
Hi

Delete the lens.
Create the lens again by following steps in same order.
When Saving the Lens, use the name "Sales Pipeline Overview" in the name and description.

User-added image

Thanks
Brian KesslerBrian Kessler
Hi @Michele Losch 4,
Thanks for response.

My datasets are all saved in the Mosaic App.
Perhaps something else is wrong with one (or more) of them?
I have the following datasets:

1. agency_data
2. agency_detail
3. global_climates
4. load_account
5. seed_bank_orders
6. seed_chart
7. temperature_classes_mapping

-Brian.


 
Lethabo NtshudisaneLethabo Ntshudisane
Hi all,

Experiencing the same issue, stuck on challenge #3. I have set up the required nodes including the Create Seed Bank Agencies node but still no luck. Still experiencing "Challenge Not yet complete... here's what's wrong: 
Couldn’t find 'Create Seed Bank Agencies' node. Please check the name and alias spelling." @Lin did you manage to find a solution?

- Lethabo
Ryan Ribeiro 14Ryan Ribeiro 14
I'm stuck on challenge 6 so lets get you guys there so you can help me! :D

Lin, Michele, and Ankita- I believe I ran into that error when I was doing the "identify Agency Records" section. You may have done the same thing I did and create a formula checkbox field on the Contact that toggles if there is a phone number OR used complex filtering in the sfdcDigest node. The badge is specifically stating to make its own, separate node in the Dataflow called "ID Agency Records" to filter down the records.  (Hint, it is not JUST a filter node to do this.) Make sure you have all 6 nodes specified before trying to submit.

Brian - You're specifically missing the Seed Bank Agencies dataset. Double check your aliases.

Ankita - You have a space in your Relationship name, spaces are not allowed there and cause the dataflow to fail. No idea why there isn't a catch for this because it has been a problem forever. Try removing the spaces and run the dataflow from there. Side note, you will not pass this section without double checking the field names, relationship names, etc. 

Let me know when you guys hit challenge 6, I could use some help! lol

 
David ReesDavid Rees
@Ryan Ribeiro 14 - I'm also stuck on challenge 6. I'm getting the following error:
Couldn’t find the 'Create Seed Bank' node or required fields are missing. Check the challenge and confirm the node name and required fields.

I have the original "Load Seed Bank" dataflow configured to register the Seed Bank dataset, and the "Load Seed Bank w/Temperature Classification" dataflow copy that adds the climate info to the same dataset. The datasets are saved to the Mosaic app, so I suspect there's something wrong with having 2 datasets with the same name, or the challenge is not able to see my 2nd dataflow (though I have no idea what parameters it uses to check, besides the dataflow name, which was copied/pasted from the challenge).

Are you getting the same error or something different?

-Dave
Ryan Ribeiro 14Ryan Ribeiro 14
David,

I am stuck in the same spot/error as you but I think I may have messed up something prior to this that is causing problems. I'm not sure I fully understand what they want me to do in the Define Temp Range and Add Temp Class nodes. One thing I noticed is the badge shows the Seed ID and Seed Type fields with no underscores but the dataset created from importing the file has underscores instead of spaces. I haven't had a chance to work on it further so I don't know if that will help. 
David ReesDavid Rees
Ryan,

The way I interpretted "Define Temp Range" was to parse the Temperature field into Low and High fields, so the value "40-50" would result in a LowTemp value of 40, and a HighTemp of 50 - not sure if this was the right way to do it, but I just substring'ed the Temperature field and converted it to a numeric. Then in "Add Temp Class" I used a case statement to examine the low/high range and assign a TempKey (like "Polar-Cool") - I'm mostly sure I got the calculation logic wrong, but regardless, every row does get a valid TempKey and allows my "Augment TempClass" node to join against the "Load Temp Class Mapping", and results in a dataset with a "Climate.TempClass" field.

Good catch on the spaces/underscores in the Seed ID and Type fields - I don't think this should matter, because Challenge 4 validates that the original Seed Bank dataset was created correctly, but I don't know if it is because that challenge validates the dataflow, or if it just looks at the saved lens, which doesn't use either of those fields.

Dave
David ReesDavid Rees
Just passed challenge 6 - the error on "Create Seed Bank" wasn't pointing at my actual problem - it was actually caused by my "Load Seed Bank Agencies w/Climate Data" dataflow, where I had renamed the alias of the dataset from "seed_bank_agencies" to "seed_bank_agencies_w_climate" because I wanted to avoid overwriting the original dataset. I guess the intention of this challenge was to preserve the original dataflow, but overwrite the dataset, so in both dataflows I changed the alias names back to the originals (seed_bank_agencies and seed_bank), ran both dataflows, and then passed the challenge.
Michele Losch 4Michele Losch 4
I think my issue is with the ID Agency Records and Filter Agency Records nodes. Here is what I have
User-added imageUser-added imageUser-added image
Any assistance with this step would be greatly appreciated. Thank you!
David ReesDavid Rees
Hi Michele,

Your dataflow looks the same as mine, but I'm having a hard time reading the screenshots - on the IsAgency field on the "ID Agency Records" computeExpression, my syntax is all on a single line, and looks like this:
case when Phone is not null then "TRUE" else "FALSE" end
Then, on the "Filter Agency Records" node, you have to use the following syntax:
dim:EQ:value
For example: 
IsAgency:EQ:TRUE
If that doesn't do the trick, can you post the error?

Good luck!
Dave
LinThawLinThaw
Thanks all,

I created same with Michele and David.
But still got same error.

Challenge Not yet complete... here's what's wrong: 
Couldn’t find Agency records from the Account object.


All processes in dataflow are run sucessfully but, 
details dataset is not show any row what is wrong plz?

User-added image

Regards,
LinThaw
Jennifer W. LeeJennifer W. Lee
I followed David's suggestion above and was able to successfully run the dataflow and saw the dataset created. From there, I was able to create the lens. However, when I try the challenge, I am still getting the same error on the challenge "Challenge Not yet complete... here's what's wrong: 
Couldn’t find 'Create Seed Bank Agencies' node. Please check the name and alias spelling."

This is highly annoying. Any other thoughts? 

 
LinThawLinThaw
I cleared following error, after creating [Top 5 Agencies lens].

Challenge Not yet complete... here's what's wrong: 
Couldn’t find Agency records from the Account object.


but still getting error same as Jennifer's.

Regards,
LinThaw
Ryan Ribeiro 14Ryan Ribeiro 14
@David Rees

You and I interpereted it the same way then, I had my dataflow set up exactly as you described. We had similar but different issues causing the failure though. I had re-ran the "Load Seed Bank Agencies" dataflow while troubleshooting and was failing the check because the new fields from "Load Seed Bank Agencies w/Climate Data" did not exist. After running the second dataflow I was able to pass. 
ankita varma 3ankita varma 3
Hello,
I have fixed relationship name, but I don't know from where to create fields and filter criteria in dataflow. Anybody please enlight me on this.
Thanks.
LinThawLinThaw
Hi Jennifer and ankita,

Please refer below, I passed this step 3.

fig 1.
User-added image

fig 2.
User-added image


and create Top 5 Agencies lenses.

Regards,
LinThaw
This was selected as the best answer
ankita varma 3ankita varma 3
Thanks LinThaw, your solution helped me.
Jennifer W. LeeJennifer W. Lee
Thank you, LinThaw. I passed it. It was the dataset name. Wasn't aware it was just "Seed bank agencies." 
Michele Losch 4Michele Losch 4
Thank you, David and LinThaw. I passed the challenge.
Jennifer W. LeeJennifer W. Lee
Stuck on #6. Getting an error on Invalid filter str: Date_Year == '2015' . Is that not the correct syntax for filtering based on the year?
ankita varma 3ankita varma 3
Hi, I am confused how to use ' temperature class' with global climate,txt ? following is the condtion given in the Superbadge challenge #6
'Uses data from Global Climates.txt to calculate a new TempClass field. The field will store one or more temperature class values. Set the default TempClass to Continental'.
Michele Losch 4Michele Losch 4
Jennifer, this is the syntax I used and it worked 
Date_Year:EQ:2015
Jennifer W. LeeJennifer W. Lee
Thanks. I forget about the EQ syntax. Thank you, Michele.
Jennifer W. LeeJennifer W. Lee
Hmmm, I'm not sure I understand Challege #6: Define Temp Range: Identifies the low and high temperatures from the Seed Bank Temperature field. Can someone explain what we're doing here?
Michele Losch 4Michele Losch 4
I'm in the same situation. I think Define Temp Range is a filter node but unsure what the syntax should be for the the filter.  I'm also unsure about the Add Temp Class node. 
Jennifer W. LeeJennifer W. Lee
I think it may be something like this. But. how does one parse the low range and high range from a string, and then separately run the compute expression on both values and then add the results back together? This is totally not admin friendly and nothing in the Trailhead modules covered any of this. 
David ReesDavid Rees
Jennifer & Michele,

Was in the same boat with challenge 6 - I agree that it's not very clear what the intention of the requirement, but here's the strategy I used:

- "Define Temp Range" is a node that adds 2 new fields; one for the low temperature, and one for the high. I used a calculation in this node to split apart the temperature string (i.e. "40-50") into a LowTemp field with the value 40, and a HighTemp field with the value 50. There are string functions (https://developer.salesforce.com/docs/atlas.en-us.bi_dev_guide_saql.meta/bi_dev_guide_saql/bi_saql_functions_string.htm), like substr(), that will help you do this, but I needed these values to be numeric, so even after parsing the string, I had to convert them to numbers, so I wrapped it all up in a string_to_number() formula.
- "Add Temp Class" is another calculation node that adds another field, this time you're generating a "TempKey" field with values like "Polar", "Cool", "Polar-Cool" and "Cool-Continental", depending on what your low and high range values from the previous node are. I found this part really hard, so I added a few more helper fields to categorize the possible category names, then concatenated them together to produce the TempKey. You could also probably generate the TempKey using a case statement to classify the ranges into one of the values that matches the TempKey column in the Temperature Classes Mapping file.
- "Augment Temp Class" is just where you join the Temperature Classes Mapping file, as the right side, to the rest of the dataflow using your newly generated TempKey.
- "CleanUp" is a slice transformation that just drops all the extra fields from the Define Temp Range and Add Temp Class that are no longer needed (in my case, I just dropped TempHigh and TempLow

Good luck!
Dave
Aviral Agrawal 29Aviral Agrawal 29

@David Rees 

Tell me what SOQL command will be used for TempClass.


Something went wrong while executing the Add Temp Class node: invalid field expression case when TempClass is not null then "TRUE" else "FALSE" end; for field 'TempClass': Unknown IDTOKEN: TempClass (02K7F000000iJSIUA2_03C7F0000018HGhUAM)

David ReesDavid Rees
@Aviral Agrawal,

It looks like you're trying to populate a field by checking if the TempClass field is null, which you can't do because on this node you're responsible for creating that field - this is why you get "Unknown IDTOKEN" pointing to the TempClass field - it doesn't exist yet but you're trying to query it.

The Add Temp Class is a node in both the "Load Seed Bank Agencies w/Climate Data" and "Load Seed Bank w/Temperature Classification" dataflows - not sure which of the 2 you're working on, but without giving away the answer, the strategy you should use is to examine the fields from the preceeding nodes, then build a case statement that references one of those fields and populates a value in your new TempClass field that matches the Temperature Class table within the instructions (i.e. temperatures Greater than 85F are "Tropical", 51F to 85F are "Continental", and so on).

Dave
Jennifer W. LeeJennifer W. Lee
Hi David.,

Thank you for the guidance.

I configured the datflow but I went to run the dataflow, I got the following error.

Something went wrong while executing the Define Temp Range node: invalid field expression string_to_number(substr(temperature, 1, 2)) for field 'lowTemp': Unknown IDTOKEN: temperature. 

Sigh, what did I do wrong with the saql syntax?  

 
David ReesDavid Rees
Hi Jennifer,

Your syntax is perfect, just remember that SAQL is case-sensitive, so use a capital 'T' in Temperature - I've made the same mistake MANY times.

Dave
Michele Losch 4Michele Losch 4
I'm having issue with the Add Temp Class in the Load Seed Bank w/Temperature Classification dataflow. I'm getting this error: Something went wrong while executing the Add Temp Class node: invalid field expression case when Temperature < 25 then "Polar" when Temperature >= 25 and Temperature <= 50 then "Cool" when Temperature >= 51 and Temperature <= 85 then "Continental" when Temperature > 85 then "Tropical" end for field 'TempClass': Incompatible types: STRING and NUMERIC in 'Temperature' < #25 (02Kf40000009rdKEAQ_03Cf4000000vZqbEAE)
Jennifer W. LeeJennifer W. Lee
Hi Michele. You need to convert the Temperature in the node Define Temp Range from a string to numeric.

I'm stuck on Challenge #7. When I run the dataflow, "Something went wrong while executing the Filter Agency Records node: parse_and_push_filters: Error returned by method qPushFilterVector for predicate Agency:EQ:FALSE." Any thoughts?
LinThawLinThaw
Hi Michele,

please try with below def. for TempClass.
I passed step #6 with this def.

case 
when lowTemp < 25 and highTemp < 25 then "Polar" 
when lowTemp >= 25 and lowTemp <= 50 and highTemp >= 25 and highTemp <= 50 then "Cool"
when lowTemp >= 51 and lowTemp <= 85 and highTemp >= 51 and highTemp <= 85 then "Continental"
when lowTemp > 85 and highTemp > 85 then "Tropical"
when lowTemp < 25 and (highTemp >= 25 and highTemp <= 50) then "Polar-Cool" 
when lowTemp < 25 and (highTemp >= 25 and highTemp <= 85) then "Polar-Cool-Continental" 
when lowTemp < 25 and highTemp > 85 then "Polar-Cool-Continental-Tropical" 
when (lowTemp >= 25 and lowTemp <= 50) and (highTemp >= 51 and highTemp <= 85) then "Cool-Continental" 
when (lowTemp >= 25 and lowTemp <= 50) and highTemp >= 85 then "Cool-Continental-Tropical" 
when (lowTemp >= 51 and lowTemp <= 85) and highTemp > 85 then "Continental-Tropical" 
end

GoodLuck,
LinThaw
ankita varma 3ankita varma 3
Hi, 
I am facing issue in challenge #6, 
Dataflow Name: Load Seed Bank Agencies w/Climate Data
Something went wrong while executing the Augment TempClass node: Duplicate field TempClass (02K7F000000ApHxUAK_03C7F000001CpcbUAC).
What wrong am I doing?
Ryan Ribeiro 14Ryan Ribeiro 14
Jennifer - That error means that your dataflow is returning no records at the time the filter is applied, so it is trying to filter nothing. Double check your dataflow further up the path to see if you can find any errors.

Ankita - You likely created the TempClass field in two different places and are trying to augment them into a single dataset but are hitting duplicate name checks. Double check all of your nodes to make sure there is only one TempClass field which is created in the "Add Temp Class" node.
ankita varma 3ankita varma 3
I have created TempClass field in "Add Temp Class" node only. Here is the screen shot.User-added image
Ryan Ribeiro 14Ryan Ribeiro 14
Ankita - Just remembered you can also cause that duplicate failure if you manually modified the JSON and copied that field twice.
Ryan Ribeiro 14Ryan Ribeiro 14
Sorry Ankita, I would have to see the dataflow/json to troubleshoot further. Try clicking on "Output Fields" and see if the field is coming from somewhere else already. Other than that, you can download the JSON and comb through it, just search for "TempClass" and make note of everywhere it is listed.
LinThawLinThaw
Thanks for all, I completed 12th Superbadges.

User-added image

Regards,
LinThaw
LinThawLinThaw
Hi Jennifer,

We need IsAgency field again,
in my previous node, relationship named was Climate.
So filter will be [Climate.IsAgency:EQ:TRUE].

This is my final flow.
User-added image
Regards,
LinThaw
LinThawLinThaw
Hi ankita,

please read business requirements again,
flow maybe like this.
User-added image
Regards,
LinThaw
Aviral Agrawal 26Aviral Agrawal 26

Add Temp Class node: invalid field expression string_to_number( substr(Temperature, 1, 2)) for field 'lowTemp': invalid arguments for function substr (02K7F000000iJSIUA2_03C7F0000018I4YUAU) 

is there anything related with syntax ??

Aviral Agrawal 26Aviral Agrawal 26

@LinThaw, Firstly congrats for having all superbadges. 

Can u share your Temp Class node as I am facing difficulty in defining lowTemp and highTemp value !
 

ankita varma 3ankita varma 3
Thanks LinThaw and Congratulations for having superbadges, I am also struggling with the challenge #6 - "Add Temp Class" node of "Load Seed Bank w/Temperature Classification" dataflow. 
Alexandre Lachmann 29Alexandre Lachmann 29
Hi Lin
Have this error on challenge 7 : "Confirm your measure is Sum of Quantity Ordered."
Dataset data seems ok (A1040-770,A1030-739...) but this error when testing
Thanks for your help
Regards
Alex
LinThawLinThaw
Hi Aviral Agrawal,

here is my [Add Temp Class] node.
User-added image

User-added image

SAQL Expression is as follow:
case 
when lowTemp < 25 and highTemp < 25 then "Polar" 
when lowTemp >= 25 and lowTemp <= 50 and highTemp >= 25 and highTemp <= 50 then "Cool"
when lowTemp >= 51 and lowTemp <= 85 and highTemp >= 51 and highTemp <= 85 then "Continental"
when lowTemp > 85 and highTemp > 85 then "Tropical"
when lowTemp < 25 and (highTemp >= 25 and highTemp <= 50) then "Polar-Cool" 
when lowTemp < 25 and (highTemp >= 25 and highTemp <= 85) then "Polar-Cool-Continental" 
when lowTemp < 25 and highTemp > 85 then "Polar-Cool-Continental-Tropical" 
when (lowTemp >= 25 and lowTemp <= 50) and (highTemp >= 51 and highTemp <= 85) then "Cool-Continental" 
when (lowTemp >= 25 and lowTemp <= 50) and highTemp >= 85 then "Cool-Continental-Tropical" 
when (lowTemp >= 51 and lowTemp <= 85) and highTemp > 85 then "Continental-Tropical" 
end

and data flow image is as follow.
User-added image

Regards,
LinThaw
LinThawLinThaw
Hi Alexandre Lachmann,

this error is because [Quantity Ordered] field in dataset has prefix (relationship name).

So, please set [Load Seed Orders] in Left Source.
User-added image

so, Lens setting will be look like this without prefix.
User-added image

Regards,
LinThaw
Alexandre Lachmann 29Alexandre Lachmann 29
Hi LinThaw
Correct :-)
Just found it
Thanks a lot for your help
User-added image
ankita varma 3ankita varma 3
In Challenge #6 I am getting following error while checking challenge.
Challenge Not yet complete... here's what's wrong: 
Couldn’t find the 'Create Seed Bank' node or required fields are missing. Check the challenge and confirm the node name and required fields.

Here is the screen shot of what I am doing.
User-added image

Thanks.
Alexandre Lachmann 29Alexandre Lachmann 29
"Couldn’t find xxx" means that either node name are incorrect (must be same name as the one given) or they are missing nodes in your DF !
LinThawLinThaw
Congrats Alex,

Hi ankita, 

how about your flow?
User-added image
I think your flow is missing node.
my 'Create Seed Bank' node is as follow.
User-added image
Regards,
LinThaw
ankita varma 3ankita varma 3
@LinThaw, I have followed the steps from the screen shot you have provided for dataflow, I will make change in my fields shown in latest screen shot that you have provided.
Thanks,
Ankita Varma
Michele Losch 4Michele Losch 4
Thank you everyone for the help. I completed the superbadge!!!
Jennifer W. LeeJennifer W. Lee
Hi LinThaw, 

I made changes to the dataflow for Challenge #7 but I'm getting "Something went wrong while executing the Filter Agency Records node: parse_and_push_filters: Error returned by method qPushFilterVector for predicate Climate.IsAgency:EQ:false. " when I run the dataflow. I'm not seeing the Climate.IsAgency field in the output fields, which is probably the issue but what step would this have come into play?
Alexandre Lachmann 29Alexandre Lachmann 29
recreate the compute expression for isAgency
Jennifer W. LeeJennifer W. Lee
I thought I needed to do that, but it doesn't match LinThaw's diagram. Anyway, now I get this "Something went wrong while executing the ID Agency Fields node: invalid field expression case when Climate.Phone is not null then "TRUE" else "FALSE" end; for field 'IsAgency': 'Climate' . 'Phone': stream argument not supported outside of cogroup projection " I assume it is looking at Climate.Phone since regular Phone is not in the output fields. 
LinThawLinThaw
Hi, Jennifer

Yes, need to recreate nodes to add isAgency field that we did it in Load Seed Bank Agencies data flow.
please refer flow of nodes as follows.
User-added image

Before [Filter Agency Records] node, I have [Add Agency Fields] in which I named Relationship as Climate, (it is optional)
User-added image

User-added image

finally [Filter Agency Records] node becomes,
User-added image

Good Luck...
Regards,
LinThaw
 
Jennifer W. LeeJennifer W. Lee
I see my problem. I do not see ID Agency Fields as a source to select. What do I need to do to correct this so it's available as a source?
Aviral Agrawal 26Aviral Agrawal 26

User-added imageUser-added image
User-added image
am I doing SAQL expression wrong or what as i am unable to run these facing errors

Something went wrong while executing the Define Temp Range node: invalid field expression string_to_number( substr(Temperature,1,2)) for field 'lowTemp': invalid arguments for function substr (02K7F000000iJSIUA2_03C7F0000018IHsUAM)

PLEASE HELP !

LinThawLinThaw
Hi Aviral,

it is described in following section. :)
User-added image

my [Define Temp Range] node setting is as follow,
User-added image
User-added image
User-added image

as David mentioned above, more about string functions please refer here https://developer.salesforce.com/docs/atlas.en-us.bi_dev_guide_saql.meta/bi_dev_guide_saql/bi_saql_functions_string.htm 

please check previous node before [Define Temp Range] is as follow.
User-added image
Regards,
LinThaw
LinThawLinThaw
Hi Jennifer,

have you added these three nodes? 
User-added image
Regards,
LinThaw
 
Aviral Agrawal 26Aviral Agrawal 26

thanks lin, i was got confused by two different data flows !!

 

Jennifer W. LeeJennifer W. Lee
I got it! LinThaw, Michele, David - do you have Twitter handles? I'd like to give you a S/O for the assist.
 User-added image
Michele Losch 4Michele Losch 4
Hi Jennifer, my Twitter handle is @michelelosch. This superbadge was a team effort!
Aviral Agrawal 26Aviral Agrawal 26
User-added imageUser-added image
THIS is my Final Lens, is this a valid lens ??
LinThawLinThaw
Congrats Jennifer,

I am @klthaw on twitter just a reader.

Hi Aviral,

please add one row.

Regards
LinThaw
ankita varma 3ankita varma 3
Hello All,
I am stuck on Challenge #6 since yesterday. I cross checked my DF many times, please somebody help me to clear the challenge.
I am getting this error while checking challenge.
User-added image
Following are my screenshot of dataflow.
User-added image
User-added image
LinThawLinThaw
Hi ankita,

your flow seems perfect.
is there any node missing in (Load Seed Bank Agencies w/Climate Data) flow?

Regards,
LinThaw
Aviral Agrawal 26Aviral Agrawal 26
Hi ankita,
I think you have problem in augment node just interchange the left and right node !!

User-added image
 
ankita varma 3ankita varma 3
Hi,
No rows are missing in Load Seed Bank Agencies w/Climate Data. 
User-added image
User-added image
This is my dataflow.
Thanks,
Ankita Varma
LinThawLinThaw
Hi Ankita,

have you these three fields?
User-added image
Regards,
LinThaw
Priyanka Vaidya 29Priyanka Vaidya 29
Hi ,
I am stuck on Step #4 , Dall data set and dataflows are in place , Still gettinga n error :
Error and data flow :

User-added imageUser-added image
LinThawLinThaw
Hi Priyanka,

flow look like as follow,
please change Source Node.
User-added image
Good Luck
Regards,
LinThaw
Priyanka Vaidya 29Priyanka Vaidya 29
Hin Lin,
I ahve updated the datflow still getting the same error : 

Challenge Not yet complete... here's what's wrong: 
Couldn’t find the 'Load Seed Chart' node in the dataflow. Confirm the node name matches the name as described in the challenge.

User-added image
LinThawLinThaw
Hi Priyanka,

Please upload details of each node (Attributes and Output Fields).

Regards,
LinThaw
Priyanka Vaidya 29Priyanka Vaidya 29
JSON Below also seems to be correct with :Load Seed Chart Node ----

{ "Calculate Acreage": { "action": "computeExpression", "parameters": { "source": "Load Seed Chart", "mergeWithSource": true, "computedFields": [ { "precision": 18, "name": "Acreage", "saqlExpression": "(Seeds_Pound*Spacing)/6272640", "scale": 6, "label": "Acreage", "type": "Numeric" } ] } }, "Create Seed Bank": { "action": "sfdcRegister", "parameters": { "name": "Seed Bank", "alias": "Seed_bank", "source": "Calculate Acreage" } }, "Load Seed Chart": { "action": "edgemart", "parameters": { "alias": "Seed_bank" } } }
Priyanka Vaidya 29Priyanka Vaidya 29
Hi LinThaw
Below are the Node details ;

User-added imageUser-added imageUser-added imageUser-added image
LinThawLinThaw
Hi Priyanka,

In first node, select ["Seed_Chart"] NOT ["Seed_bank"].

I hope you solve it.

Regards,
LinThaw
Priyanka Vaidya 29Priyanka Vaidya 29
Thanks a lot , That was a silly mistake . Passed teh c ahllenge  :)
Priyanka Vaidya 29Priyanka Vaidya 29
Hi LinThaw ,
Stuck on Challenge 6 , Where do i have to specify the lowTemp and HighTemp variables for TempClass in Load Seed Bank Agencies w/Climate Data flow.
LinThawLinThaw
Hi Priyanka,

lowTemp and highTemp fields NOT use in [Load Seed Bank Agencies w/Climate Data] dataflow.

We need to create and use lowTemp and highTemp fields in [Load Seed Bank w/Temperature Classification] dataflow.

I hope you can found solution on above posts.

Regards,
LinThaw.
ankita varma 3ankita varma 3
Thank you so much LinThaw,
Your guidence helped me to complete challenge #6.
Regards,
Ankita Varma
LinThawLinThaw
Congrats Ankita.
ankita varma 3ankita varma 3
hi Priyanka, create computeExpression and create two different fields LowTemp and HighTemp.
Regards,
Ankita Varma
Priyanka Vaidya 29Priyanka Vaidya 29
Hi Ankita ,
 
Actuly i am connfused with the requirement what compute expression do i need to add for Temp class of Load Seed Bank Agencies w/Climate Data] dataflow.
Regards
Priyanka
LinThawLinThaw
Hi, Priyanka

please try as below for new dataflow.

-download Load Seed Bank Agencies dataflow
-create new Load Seed Bank Agencies w/Climate Data dataflow
-upload json file of Load Seed Bank Agencies dataflow to new Load Seed Bank Agencies w/Climate Data dataflow
-delete [Create Seed Bank Agencies] node
-create node [Load Climate] edgemart (Loads the Global Climates.txt file)
-create node [Filter 2015] filter (Filter is Date_Year:EQ:2015)
-create node [Add Temp Class] computeExpression
 source is ["Load Climate"]
 add Field [TempClass], Type is Text and Default Value is Continental and SAQL is as follow
 case when Temperature < 25 then "Polar" when Temperature >= 25 and Temperature <= 50 then "Cool" when Temperature >= 51 and Temperature <= 85 then "Continental" when Temperature > 85 then "Tropical" end
-create node [Augment TempClass] augment
 left source is ["Filter Agency Records"]
 left key is ["ShippingCountry"]
 relationship is Climate
 right source is ["Add Temp Class"]
 right key is ["Country"]
 right Fields is ["Country","Date","TempClass","Temperature"]
 operation is [Look Up Single Value]
-create node [Create Seed Bank Agencies] sfdcRegister
 source is ["Augment TempClass"]
 Alias is [seed_bank_agencies]
 Name is [Seed Bank Agencies]

Regards,
LinThaw
Priyanka Vaidya 29Priyanka Vaidya 29
That helped a lot LinThaw , Passed Challenge#6
LinThawLinThaw
Good Job Priyanka.
Kristi Brown 16Kristi Brown 16
I'm having issues with #6 with the Load Seed Bank w/Temperature Classification dataflow. I keep getting a dataflow warning:
The dataflow was completed, but the LookupSingleValue node didn't augment any columns. Either the node didn't find any matches, or a join key contains only null values.
User-added image
User-added image 
Not sure why it isn't picking up any values. This, of course, leads to the challenge error of "Couldn’t find the correct values. Please check your work." I don't have any TempClasses in the dataset at all. Thoughts?
Kristi Brown 16Kristi Brown 16
Well, I guess I just needed to tell someone about it. I found the error and passed #6. :)
Alex Van AttaAlex Van Atta
Hey all,

I'm on Challenge #7 and was able to get the data flow running again, but when I check the challenge, I receive a "Couldn't find 'Create Order History' node" error. Did anyone else receive this? Here is the node in my JSON:
"Create Order History": {
    "action": "sfdcRegister",
    "parameters": {
      "source": "Add Seed Orders",
      "alias": "OrderHistory",
      "name": "Order History"
    }
  }

Any ideas why this isn't completing successfully?
LinThawLinThaw
Hi Alex,

Naming of Dataset Name and Alias is describe in Pre-work and Notes as follow.

For datasets containing spaces in its name, use the underscore _ in dataset aliases. * Dataset name: Seed Bank * Dataset alias: seed_bank (lowercase spelling)

so your alias should be like this.
  "Create Order History": {
    "action": "sfdcRegister",
    "parameters": {
      "name": "Order History",
      "alias": "order_history",
      "source": "Add Seed Orders"
    }
  },

I hope you got it.

Regards,
LinThaw
Alex Van AttaAlex Van Atta
That was 100% it! Thanks, LinThaw.
Priyanka Vaidya 29Priyanka Vaidya 29
Hi LinThaw,
I am Stuck at Step 7 , Getting an error on running data flow : 
Something went wrong while executing the Filter Agency Records node: parse_and_push_filters: Error returned by method qPushFilterVector for predicate Climate.IsAgency:EQ:TRUE. (02K7F000000Arz5UAC_03C7F000001CueFUAS)

This is my flow currently whre i ahve added IsAgencyField as suggested above :
User-added imageUser-added image
User-added image
LinThawLinThaw
Hi Priyanka,

order of the nodes in flow is not correct.
please refer look like this.
User-added image

and in SAQL you mentioned, please add double code to TRUE and FALSE.

[Add Agency Fields] node should be like this.
User-added image

Regards,
LinThaw
Sandeep Ramineni 7Sandeep Ramineni 7
Hi,

I am stuck in Challenge# 7, getting this error message "Something went wrong while executing the Add Agency Fields node: Duplicate field Name (02K7F000000AsPHUA0_03C7F000001CuxpUAC)".

 
LinThawLinThaw
Hi Sandeep,

Please upload your dataflow.

Regards,
LinThaw
Priyanka Vaidya 29Priyanka Vaidya 29
Hi Lin ,
I have updated the data flow , but it gives the error in SAQL Expression :

case when Climate.Phone is not null then "TRUE" else "FALSE" end

Something went wrong while executing the ID Agency Records node: invalid field expression case when Climate.Phone is not null then "TRUE" else "FALSE" end for field 'IsAgency': 'Climate' . 'Phone': stream argument not supported outside of cogroup projection (02K7F000000Arz5UAC_03C7F000001Cv6JUAS)
LinThawLinThaw
Hi Priyanka,

Please check output fields of previous node.
I think you need to remove [Climate] prefix from [Climate.Phone] or
prefix maybe other name that you gave naming in relationship of previous node.

Regards,
LinThaw
Priyanka Vaidya 29Priyanka Vaidya 29
Hi LinThaw ,

Something went wrong while executing the ID Agency Records node: invalid field expression case when Climate.Phone is not null then "TRUE" else "FALSE" end for field 'IsAgency': 'Climate' . 'Phone': stream argument not supported outside of cogroup projection (02K7F000000Arz5UAC_03C7F000001CvOpUAK)


Its not working check with all teh nodes and the relationship names :
User-added image
User-added imageUser-added image
Priyanka Vaidya 29Priyanka Vaidya 29
Can you provide me the JSON for the same to chk ..
LinThawLinThaw
Hi Priyanka,

This is my json.
"ID Agency Records": {
    "action": "computeExpression",
    "parameters": {
      "source": "Add Agency Detail Fields",
      "mergeWithSource": true,
      "computedFields": [
        {
          "name": "IsAgency",
          "label": "IsAgency",
          "type": "Text",
          "saqlExpression": "case when Phone is not null then \"TRUE\" else \"FALSE\" end"
        }
      ]
    }
  },
  "Add Agency Detail Fields": {
    "action": "augment",
    "parameters": {
      "right_key": [
        "AccountNumber"
      ],
      "left": "Load Account",
      "left_key": [
        "AccountNumber"
      ],
      "right_select": [
        "AccountNumber",
        "Acres",
        "Currency",
        "Latitude",
        "Longitude",
        "Region",
        "SubRegion"
      ],
      "right": "Load Agency",
      "relationship": "AgencyDetail",
      "operation": "LookupSingleValue"
    }
  },

Regards,
LinThaw
ankita varma 3ankita varma 3
Thank you each one of you to help me complete the superbadge, all of you were very helpful.
Special thanks to LinThaw, you took your precious time to help us.
User-added image
LinThawLinThaw
Congrats Ankita.
Sandeep Ramineni 7Sandeep Ramineni 7
Hi Lin,

I am getting this new error "Something went wrong while executing the Add Agency Fields node: Duplicate field AccountNumber (02K7F000000AsPHUA0_03C7F000001CwgdUAC)". 

I am attaching my data flow and JSON.User-added image
{
  "Add Temp Class": {
    "action": "computeExpression",
    "parameters": {
      "source": "Filter 2015",
      "mergeWithSource": true,
      "computedFields": [
        {
          "defaultValue": "Continental",
          "name": "TempClass",
          "saqlExpression": "case when Temperature < 25 then \"Polar\" when Temperature >= 25 and Temperature <= 50 then \"Cool\" when Temperature >= 51 and Temperature <= 85 then \"Continental\" when Temperature > 85 then \"Tropical\" end",
          "label": "TempClass",
          "type": "Text"
        }
      ]
    }
  },
  "Load Seed Orders": {
    "action": "edgemart",
    "parameters": {
      "alias": "Seed_Bank"
    }
  },
  "Create Order History": {
    "action": "sfdcRegister",
    "parameters": {
      "name": "Order History",
      "alias": "order_history",
      "source": "Add Seed Orders"
    }
  },
  "Augment Temp Class": {
    "action": "augment",
    "parameters": {
      "right_key": [
        "ShippingCountry"
      ],
      "left": "Add Temp Class",
      "left_key": [
        "Country"
      ],
      "right_select": [
        "AccountNumber",
        "Name",
        "Phone",
        "ShippingCity",
        "ShippingCountry",
        "ShippingPostalCode",
        "ShippingState",
        "ShippingStreet"
      ],
      "right": "Load Account",
      "relationship": "Climate",
      "operation": "LookupSingleValue"
    }
  },
  "Load Climate": {
    "action": "edgemart",
    "parameters": {
      "alias": "Global_Climates"
    }
  },
  "Add Agency Details Fields": {
    "action": "augment",
    "parameters": {
      "right_key": [
        "AccountNumber"
      ],
      "left": "Load Account",
      "left_key": [
        "AccountNumber"
      ],
      "right_select": [
        "Acres"
      ],
      "right": "Load Agency",
      "relationship": "Account",
      "operation": "LookupSingleValue"
    }
  },
  "Add Seed Orders": {
    "action": "append",
    "parameters": {
      "sources": [
        "Filter Agency Records",
        "Load Seed Orders"
      ]
    }
  },
  "Filter 2015": {
    "action": "filter",
    "parameters": {
      "filter": "Date_Year:EQ: '2015'",
      "source": "Load Climate"
    }
  },
  "ID Agency Records": {
    "action": "computeExpression",
    "parameters": {
      "source": "Add Agency Details Fields",
      "mergeWithSource": true,
      "computedFields": [
        {
          "name": "IsAgency",
          "saqlExpression": "case when Phone is not null then \"TRUE\" else \"FALSE\" end",
          "label": "IsAgency",
          "type": "Text"
        }
      ]
    }
  },
  "Load Agency": {
    "action": "edgemart",
    "parameters": {
      "alias": "Agency_Detail"
    }
  },
  "Filter Agency Records": {
    "action": "filter",
    "parameters": {
      "filter": "Climate.IsAgency:EQ:TRUE",
      "source": "Add Agency Fields"
    }
  },
  "Load Account": {
    "action": "sfdcDigest",
    "parameters": {
      "fields": [
        {
          "name": "AccountNumber"
        },
        {
          "name": "Name"
        },
        {
          "name": "Phone"
        },
        {
          "name": "ShippingCity"
        },
        {
          "name": "ShippingCountry"
        },
        {
          "name": "ShippingPostalCode"
        },
        {
          "name": "ShippingState"
        },
        {
          "name": "ShippingStreet"
        }
      ],
      "object": "Account"
    }
  },
  "Add Agency Fields": {
    "action": "augment",
    "parameters": {
      "left": "Augment Temp Class",
      "right": "ID Agency Records",
      "relationship": "Climate",
      "operation": "LookupSingleValue",
      "left_key": [
        "Climate.AccountNumber"
      ],
      "right_key": [
        "AccountNumber"
      ],
      "right_select": [
        "AccountNumber",
        "IsAgency",
        "Account.Acres",
        "Name",
        "Phone",
        "ShippingCity",
        "ShippingCountry",
        "ShippingPostalCode",
        "ShippingState",
        "ShippingStreet"
      ]
    }
  }
}

 
Sandeep Ramineni 7Sandeep Ramineni 7
Hi Lin,

I am adding the monitor logs screenshot for additional help.
User-added image
LinThawLinThaw
Hi Sandeep,

in your node, left key is Climate.AccountNumber
and relationship name is Climate,
so, output of right field will become Climate.AccountNumber.
it is reason of duplicatation. so please swap source in previous node.
or change relationship name.

Regards,
LinThaw
Sandeep Ramineni 7Sandeep Ramineni 7
Hi Lin,

I changed the relationship name and now I got this error.
Something went wrong while executing the Filter Agency Records node: parse_and_push_filters: Error returned by method qPushFilterVector for predicate Climate.IsAgency:EQ:TRUE. (02K7F000000AsPHUA0_03C7F000001CwjmUAC)
LinThawLinThaw
Hi Sandeep,

change on which node?
please change [Climate] on this filter by new relationship name.
Climate.IsAgency:EQ:TRUE 

Regards,
LinThaw
Sandeep Ramineni 7Sandeep Ramineni 7
Hi Lin,

I have updated the relationship name to AgencyClimate in "Add Agency Fields" node and updated the expression in the fitler with the new field name "AgencyClimate.IsAgency:EQ:TRUE". I am getting same error. I am adding my JSON for help.
"Augment Temp Class": {
    "action": "augment",
    "parameters": {
      "right_key": [
        "ShippingCountry"
      ],
      "left": "Add Temp Class",
      "left_key": [
        "Country"
      ],
      "right_select": [
        "AccountNumber",
        "Name",
        "Phone",
        "ShippingCity",
        "ShippingCountry",
        "ShippingPostalCode",
        "ShippingState",
        "ShippingStreet"
      ],
      "right": "Load Account",
      "relationship": "Climate",
      "operation": "LookupSingleValue"
    }
  },
  "Load Climate": {
    "action": "edgemart",
    "parameters": {
      "alias": "Global_Climates"
    }
  },
  "Add Agency Details Fields": {
    "action": "augment",
    "parameters": {
      "right_key": [
        "AccountNumber"
      ],
      "left": "Load Account",
      "left_key": [
        "AccountNumber"
      ],
      "right_select": [
        "Acres"
      ],
      "right": "Load Agency",
      "relationship": "Account",
      "operation": "LookupSingleValue"
    }
  },
  "Add Seed Orders": {
    "action": "append",
    "parameters": {
      "sources": [
        "Filter Agency Records",
        "Load Seed Orders"
      ]
    }
  },
  "Filter 2015": {
    "action": "filter",
    "parameters": {
      "filter": "Date_Year:EQ: '2015'",
      "source": "Load Climate"
    }
  },
  "ID Agency Records": {
    "action": "computeExpression",
    "parameters": {
      "source": "Add Agency Details Fields",
      "mergeWithSource": true,
      "computedFields": [
        {
          "name": "IsAgency",
          "saqlExpression": "case when Phone is not null then \"TRUE\" else \"FALSE\" end",
          "label": "IsAgency",
          "type": "Text"
        }
      ]
    }
  },
  "Load Agency": {
    "action": "edgemart",
    "parameters": {
      "alias": "Agency_Detail"
    }
  },
  "Filter Agency Records": {
    "action": "filter",
    "parameters": {
      "filter": "AgencyClimate.IsAgency:EQ:TRUE",
      "source": "Add Agency Fields"
    }
  },
  "Load Account": {
    "action": "sfdcDigest",
    "parameters": {
      "fields": [
        {
          "name": "AccountNumber"
        },
        {
          "name": "Name"
        },
        {
          "name": "Phone"
        },
        {
          "name": "ShippingCity"
        },
        {
          "name": "ShippingCountry"
        },
        {
          "name": "ShippingPostalCode"
        },
        {
          "name": "ShippingState"
        },
        {
          "name": "ShippingStreet"
        }
      ],
      "object": "Account"
    }
  },
  "Add Agency Fields": {
    "action": "augment",
    "parameters": {
      "left": "Augment Temp Class",
      "right": "ID Agency Records",
      "relationship": "AgencyClimate",
      "operation": "LookupSingleValue",
      "left_key": [
        "Climate.AccountNumber"
      ],
      "right_key": [
        "AccountNumber"
      ],
      "right_select": [
        "AccountNumber",
        "IsAgency",
        "Account.Acres",
        "Name",
        "Phone",
        "ShippingCity",
        "ShippingCountry",
        "ShippingPostalCode",
        "ShippingState",
        "ShippingStreet"
      ]
    }
  }
}

 
LinThawLinThaw
Sandeep, JSON is NOT valid.
Sandeep Ramineni 7Sandeep Ramineni 7
Hey Lin, I didn't get you, where is the error?
LinThawLinThaw
Hi Sandeep, please download again and send me new json.
 
Sandeep Ramineni 7Sandeep Ramineni 7
new JSON
{
  "Add Temp Class": {
    "action": "computeExpression",
    "parameters": {
      "source": "Filter 2015",
      "mergeWithSource": true,
      "computedFields": [
        {
          "defaultValue": "Continental",
          "name": "TempClass",
          "saqlExpression": "case when Temperature < 25 then \"Polar\" when Temperature >= 25 and Temperature <= 50 then \"Cool\" when Temperature >= 51 and Temperature <= 85 then \"Continental\" when Temperature > 85 then \"Tropical\" end",
          "label": "TempClass",
          "type": "Text"
        }
      ]
    }
  },
  "Load Seed Orders": {
    "action": "edgemart",
    "parameters": {
      "alias": "Seed_Bank"
    }
  },
  "Create Order History": {
    "action": "sfdcRegister",
    "parameters": {
      "name": "Order History",
      "alias": "order_history",
      "source": "Add Seed Orders"
    }
  },
  "Augment Temp Class": {
    "action": "augment",
    "parameters": {
      "right_key": [
        "ShippingCountry"
      ],
      "left": "Add Temp Class",
      "left_key": [
        "Country"
      ],
      "right_select": [
        "AccountNumber",
        "Name",
        "Phone",
        "ShippingCity",
        "ShippingCountry",
        "ShippingPostalCode",
        "ShippingState",
        "ShippingStreet"
      ],
      "right": "Load Account",
      "relationship": "Climate",
      "operation": "LookupSingleValue"
    }
  },
  "Load Climate": {
    "action": "edgemart",
    "parameters": {
      "alias": "Global_Climates"
    }
  },
  "Add Agency Details Fields": {
    "action": "augment",
    "parameters": {
      "right_key": [
        "AccountNumber"
      ],
      "left": "Load Account",
      "left_key": [
        "AccountNumber"
      ],
      "right_select": [
        "Acres"
      ],
      "right": "Load Agency",
      "relationship": "Account",
      "operation": "LookupSingleValue"
    }
  },
  "Add Seed Orders": {
    "action": "append",
    "parameters": {
      "sources": [
        "Filter Agency Records",
        "Load Seed Orders"
      ]
    }
  },
  "Filter 2015": {
    "action": "filter",
    "parameters": {
      "filter": "Date_Year:EQ: '2015'",
      "source": "Load Climate"
    }
  },
  "ID Agency Records": {
    "action": "computeExpression",
    "parameters": {
      "source": "Add Agency Details Fields",
      "mergeWithSource": true,
      "computedFields": [
        {
          "name": "IsAgency",
          "saqlExpression": "case when Phone is not null then \"TRUE\" else \"FALSE\" end",
          "label": "IsAgency",
          "type": "Text"
        }
      ]
    }
  },
  "Load Agency": {
    "action": "edgemart",
    "parameters": {
      "alias": "Agency_Detail"
    }
  },
  "Filter Agency Records": {
    "action": "filter",
    "parameters": {
      "filter": "AgencyClimate.IsAgency:EQ:TRUE",
      "source": "Add Agency Fields"
    }
  },
  "Load Account": {
    "action": "sfdcDigest",
    "parameters": {
      "fields": [
        {
          "name": "AccountNumber"
        },
        {
          "name": "Name"
        },
        {
          "name": "Phone"
        },
        {
          "name": "ShippingCity"
        },
        {
          "name": "ShippingCountry"
        },
        {
          "name": "ShippingPostalCode"
        },
        {
          "name": "ShippingState"
        },
        {
          "name": "ShippingStreet"
        }
      ],
      "object": "Account"
    }
  },
  "Add Agency Fields": {
    "action": "augment",
    "parameters": {
      "left": "Augment Temp Class",
      "right": "ID Agency Records",
      "relationship": "AgencyClimate",
      "operation": "LookupSingleValue",
      "left_key": [
        "Climate.AccountNumber"
      ],
      "right_key": [
        "AccountNumber"
      ],
      "right_select": [
        "AccountNumber",
        "IsAgency",
        "Account.Acres",
        "Name",
        "Phone",
        "ShippingCity",
        "ShippingCountry",
        "ShippingPostalCode",
        "ShippingState",
        "ShippingStreet"
      ]
    }
  }
}

 
LinThawLinThaw
Hi Sandeep,

This time error cause for following reson.
That error means that your dataflow is returning no records at the time the filter is applied, so it is trying to filter nothing.
according to Ryan Ribeiro mentioned on old post.

I found a lot of errors in your flow.
please edit below facts.

1. In node [Load Seed Orders], change source to ["Seed_Bank_Orders"], NOT ["Seed_Bank"].

2. In node [Add Agency Details Fields], add ["AccountNumber"] in right field, because it will be used as key in later node.

3. In node [Filter 2015], change [Date_Year:EQ: '2015'] to [Date_Year:EQ:2015].

4. Change type of [Add Seed Orders] from append to augment.
    left node is ["Load Seed Orders"] left key is Agency_ID.
    right node is ["Filter Agency Records"], right key is AccountNumber (maybe long name, no problem), right field is Phone (optional) becuase we just link Seed Order and valid Account.

5. Finally relink with Create Order History: sfdcRegister.

Goodluck & Regards,
LinThaw
Sandeep Ramineni 7Sandeep Ramineni 7
Hi Lin,

Thank you for the updates. I have made all the changes and got one final error and a warning in the monitor page.
This is the error/warning message: "The dataflow was completed, but the LookupSingleValue node didn't augment any columns. Either the node didn't find any matches, or a join key contains only null values.".
User-added image
Sandeep Ramineni 7Sandeep Ramineni 7
Hey Lin,

I am adding JSON after modifications.
{
  "Add Temp Class": {
    "action": "computeExpression",
    "parameters": {
      "source": "Filter 2015",
      "mergeWithSource": true,
      "computedFields": [
        {
          "defaultValue": "Continental",
          "name": "TempClass",
          "saqlExpression": "case when Temperature < 25 then \"Polar\" when Temperature >= 25 and Temperature <= 50 then \"Cool\" when Temperature >= 51 and Temperature <= 85 then \"Continental\" when Temperature > 85 then \"Tropical\" end",
          "label": "TempClass",
          "type": "Text"
        }
      ]
    }
  },
  "Load Seed Orders": {
    "action": "edgemart",
    "parameters": {
      "alias": "seed_bank_agencies"
    }
  },
  "Augment Temp Class": {
    "action": "augment",
    "parameters": {
      "right_key": [
        "ShippingCountry"
      ],
      "left": "Add Temp Class",
      "left_key": [
        "Country"
      ],
      "right_select": [
        "AccountNumber",
        "Name",
        "Phone",
        "ShippingCity",
        "ShippingCountry",
        "ShippingPostalCode",
        "ShippingState",
        "ShippingStreet"
      ],
      "right": "Load Account",
      "relationship": "Climate",
      "operation": "LookupSingleValue"
    }
  },
  "Load Climate": {
    "action": "edgemart",
    "parameters": {
      "alias": "Global_Climates"
    }
  },
  "Add Agency Details Fields": {
    "action": "augment",
    "parameters": {
      "left": "Load Account",
      "right": "Load Agency",
      "relationship": "Account",
      "operation": "LookupSingleValue",
      "left_key": [
        "AccountNumber"
      ],
      "right_key": [
        "AccountNumber"
      ],
      "right_select": [
        "Acres",
        "AccountNumber"
      ]
    }
  },
  "Filter 2015": {
    "action": "filter",
    "parameters": {
      "filter": "Date_Year:EQ:2015",
      "source": "Load Climate"
    }
  },
  "ID Agency Records": {
    "action": "computeExpression",
    "parameters": {
      "source": "Add Agency Details Fields",
      "mergeWithSource": true,
      "computedFields": [
        {
          "name": "IsAgency",
          "saqlExpression": "case when Phone is not null then \"TRUE\" else \"FALSE\" end",
          "label": "IsAgency",
          "type": "Text"
        }
      ]
    }
  },
  "Load Agency": {
    "action": "edgemart",
    "parameters": {
      "alias": "Agency_Detail"
    }
  },
  "Filter Agency Records": {
    "action": "filter",
    "parameters": {
      "filter": "AgencyClimate.IsAgency:EQ:TRUE",
      "source": "Add Agency Fields"
    }
  },
  "Load Account": {
    "action": "sfdcDigest",
    "parameters": {
      "fields": [
        {
          "name": "AccountNumber"
        },
        {
          "name": "Name"
        },
        {
          "name": "Phone"
        },
        {
          "name": "ShippingCity"
        },
        {
          "name": "ShippingCountry"
        },
        {
          "name": "ShippingPostalCode"
        },
        {
          "name": "ShippingState"
        },
        {
          "name": "ShippingStreet"
        }
      ],
      "object": "Account"
    }
  },
  "Add Agency Fields": {
    "action": "augment",
    "parameters": {
      "left": "Augment Temp Class",
      "right": "ID Agency Records",
      "relationship": "AgencyClimate",
      "operation": "LookupSingleValue",
      "left_key": [
        "Climate.AccountNumber"
      ],
      "right_key": [
        "AccountNumber"
      ],
      "right_select": [
        "AccountNumber",
        "IsAgency",
        "Account.Acres",
        "Name",
        "Phone",
        "ShippingCity",
        "ShippingCountry",
        "ShippingPostalCode",
        "ShippingState",
        "ShippingStreet",
        "Account.AccountNumber"
      ]
    }
  },
  "Add Seed Orders": {
    "action": "augment",
    "parameters": {
      "operation": "LookupSingleValue",
      "relationship": "SeedAccounts",
      "left": "Load Seed Orders",
      "left_key": [
        "Id"
      ],
      "right": "Filter Agency Records",
      "right_key": [
        "AgencyClimate.Account.AccountNumber"
      ],
      "right_select": [
        "AgencyClimate.Phone"
      ]
    }
  },
  "Create Order History": {
    "action": "sfdcRegister",
    "parameters": {
      "source": "Add Seed Orders",
      "alias": "order_history",
      "name": "Order History"
    }
  }
}

 
LinThawLinThaw
Hey Sandeep,

Please read carefully :), I hope you will pass soon.

1. In node [Load Seed Orders], change source to ["Seed_Bank_Orders"], NOT ["Seed_Bank"].

4. Change type of [Add Seed Orders] from append to augment.
    left node is ["Load Seed Orders"] left key is Agency_ID.

Regards,
LinThaw
Priyanka Vaidya 29Priyanka Vaidya 29
Thanks LinThaw,
Finally Completed the Superbadge !
User-added image
Sandeep Ramineni 7Sandeep Ramineni 7
Finally got it Lin, I missed adding Seeb Bank Orders dataset and it caused a lot of confusion.

Thank you for all the help!!!!.
LinThawLinThaw
Congrats Priyanka & Sandeep,
I also got study well on this Analytics.
Regards,
LinThaw
Admin User 8055Admin User 8055
Hi
@LinThaw
My lens is this in challenge 3.
but this error [Couldn’t find the correct values. Please check your work.]
HeeeelpUser-added image
LinThawLinThaw
Hi,

I didn't found "Voomm" Account in your Top 5 records.

Please check your Agency Data correctly uploaded.

maybe Lens look like this.
User-added image
Regards,
LinThaw
Martin O'connellMartin O'connell
Hi linthaw /ankita varma 3

How did u resolve #6 Couldn’t find the 'Create Seed Bank' node or required fields are missing
The Dataflow is exactly the same - the output fields are the same
 
LinThawLinThaw
Hi Martin,

Please check following,

@ Load Seed Bank w/Temperature Classification
In [Create Seed Bank] node,
Name is  [Seed Bank]
Alias is [seed_bank]

@ Load Seed Bank Agencies w/Climate Data
In [Create Seed Bank Agencies] node,
Name is [Seed Bank Agencies]
Alias is [seed_bank_agencies]

Then, rerun data flow and recreate new Lenses.

Regards,
LinThaw
Martin O'connellMartin O'connell
I can confirm this is all matching
Martin O'connellMartin O'connell
Rebecca GrayRebecca Gray
Am I going crazy? I am getting an error message stating that the Load Agency Detail node is missing... but it's there!
Is anyone else having this issue?  I've checked the naming conventions several times- "Load_Agency_Detail" for the alias name.

Any help appreciated! 
Error Message
It's there!
LinThawLinThaw
Hi Martin and Rebecca
please upload your JSON.
LinThawLinThaw
Hi Emilien, it is ok please wait.
LinThawLinThaw
Hi Emilien,

your issue is caused by the following typing miss.

-remove unnecessary single code in filter of [Filter 2015].

And then please used same key on [Add Seed Orders] node.
-change right key to ["Climate.AccountNumber"].

Good Luck,
Regards,
LinThaw.
Admin User 8055Admin User 8055
Hi Lin.
I passed this challenge.
If you had not helped me,I coundn't clear this.
Thanks a lot!!!
LinThawLinThaw
Great! you two Congrats.
Martin O'connellMartin O'connell
Hi LinTham Please find JSON for Step 6 Couldn’t find the 'Create Seed Bank' node or required fields are missing. Check the challenge and confirm the node name and required fields. { "Add Temp Class": { "action": "computeExpression", "parameters": { "source": "Define Temp Range", "mergeWithSource": true, "computedFields": [ { "defaultValue": "\"Continental\"", "name": "TempKey", "saqlExpression": "case \nwhen lowTemp < 25 and highTemp < 25 then \"Polar\" \nwhen lowTemp >= 25 and lowTemp = 25 and highTemp = 51 and lowTemp = 51 and highTemp 85 and highTemp > 85 then \"Tropical\"\nwhen lowTemp < 25 and (highTemp >= 25 and highTemp = 25 and highTemp 85 then \"Polar-Cool-Continental-Tropical\" \nwhen (lowTemp >= 25 and lowTemp = 51 and highTemp = 25 and lowTemp = 85 then \"Cool-Continental-Tropical\" \nwhen (lowTemp >= 51 and lowTemp 85 then \"Continental-Tropical\" \nend", "label": "TempKey", "type": "Text" } ] } }, "Calculate Acreage": { "action": "computeExpression", "parameters": { "source": "Load Seed Chart", "mergeWithSource": true, "computedFields": [ { "precision": 18, "name": "Acreage", "saqlExpression": "(Seeds_Pound*Spacing)/6272640", "scale": 6, "label": "Acreage", "type": "Numeric" } ] } }, "Create Seed Bank": { "action": "sfdcRegister", "parameters": { "name": "Seed Bank", "alias": "seed_bank", "source": "CleanUp" } }, "Load Seed Chart": { "action": "edgemart", "parameters": { "alias": "Seed_Chart" } }, "Augment Temp Class": { "action": "augment", "parameters": { "right_key": [ "TempKey" ], "left": "Add Temp Class", "left_key": [ "TempKey" ], "right_select": [ "TempClass" ], "right": "Load Temp Class Mapping", "relationship": "Climate", "operation": "LookupMultiValue" } }, "Load Temp Class Mapping": { "action": "edgemart", "parameters": { "alias": "Load_Temp_Class_Mapping" } }, "CleanUp": { "action": "sliceDataset", "parameters": { "mode": "drop", "source": "Augment Temp Class", "fields": [ { "name": "TempKey" }, { "name": "highTemp" }, { "name": "lowTemp" } ] } }, "Define Temp Range": { "action": "computeExpression", "parameters": { "source": "Calculate Acreage", "mergeWithSource": true, "computedFields": [ { "precision": 3, "name": "lowTemp", "saqlExpression": "string_to_number(substr(Temperature, 1, 2))", "scale": 1, "label": "lowTemp", "type": "Numeric" }, { "precision": 3, "name": "highTemp", "saqlExpression": "string_to_number(substr(Temperature, 4, 2))", "scale": 1, "label": "highTemp", "type": "Numeric" } ] } } }
LinThawLinThaw
Hi Martin,

Use following [SAQL Expression] for TempClass, your saql is broken.
case 
when lowTemp < 25 and highTemp < 25 then "Polar" 
when lowTemp >= 25 and lowTemp <= 50 and highTemp >= 25 and highTemp <= 50 then "Cool"
when lowTemp >= 51 and lowTemp <= 85 and highTemp >= 51 and highTemp <= 85 then "Continental"
when lowTemp > 85 and highTemp > 85 then "Tropical"
when lowTemp < 25 and (highTemp >= 25 and highTemp <= 50) then "Polar-Cool" 
when lowTemp < 25 and (highTemp >= 25 and highTemp <= 85) then "Polar-Cool-Continental" 
when lowTemp < 25 and highTemp > 85 then "Polar-Cool-Continental-Tropical" 
when (lowTemp >= 25 and lowTemp <= 50) and (highTemp >= 51 and highTemp <= 85) then "Cool-Continental" 
when (lowTemp >= 25 and lowTemp <= 50) and highTemp >= 85 then "Cool-Continental-Tropical" 
when (lowTemp >= 51 and lowTemp <= 85) and highTemp > 85 then "Continental-Tropical" 
end

And, in [Load Temp Class Mapping], source (Alias) should be ["Temperature_Classes_Mapping"].

Good Luck
Regards,
LinThaw.
 
Martin O'connellMartin O'connell
Amended JSON but still same issue { "Add Temp Class": { "action": "computeExpression", "parameters": { "source": "Define Temp Range", "mergeWithSource": true, "computedFields": [ { "name": "TempKey", "label": "TempKey", "type": "Text", "saqlExpression": "case \nwhen lowTemp < 25 and highTemp < 25 then \"Polar\" \nwhen lowTemp >= 25 and lowTemp = 25 and highTemp = 51 and lowTemp = 51 and highTemp 85 and highTemp > 85 then \"Tropical\"\nwhen lowTemp < 25 and (highTemp >= 25 and highTemp = 25 and highTemp 85 then \"Polar-Cool-Continental-Tropical\" \nwhen (lowTemp >= 25 and lowTemp = 51 and highTemp = 25 and lowTemp = 85 then \"Cool-Continental-Tropical\" \nwhen (lowTemp >= 51 and lowTemp 85 then \"Continental-Tropical\" \nend", "defaultValue": "\"Continental\"" } ] } }, "Calculate Acreage": { "action": "computeExpression", "parameters": { "source": "Load Seed Chart", "mergeWithSource": true, "computedFields": [ { "precision": 18, "name": "Acreage", "saqlExpression": "(Seeds_Pound*Spacing)/6272640", "scale": 6, "label": "Acreage", "type": "Numeric" } ] } }, "Create Seed Bank": { "action": "sfdcRegister", "parameters": { "name": "Seed Bank", "alias": "seed_bank", "source": "CleanUp" } }, "Load Seed Chart": { "action": "edgemart", "parameters": { "alias": "Seed_Chart" } }, "Augment Temp Class": { "action": "augment", "parameters": { "right_key": [ "TempKey" ], "left": "Add Temp Class", "left_key": [ "TempKey" ], "right_select": [ "TempClass" ], "right": "Load Temp Class Mapping", "relationship": "Climate", "operation": "LookupMultiValue" } }, "Load Temp Class Mapping": { "action": "edgemart", "parameters": { "alias": "Temperature_Classes_Mapping" } }, "CleanUp": { "action": "sliceDataset", "parameters": { "mode": "drop", "source": "Augment Temp Class", "fields": [ { "name": "TempKey" }, { "name": "highTemp" }, { "name": "lowTemp" } ] } }, "Define Temp Range": { "action": "computeExpression", "parameters": { "source": "Calculate Acreage", "mergeWithSource": true, "computedFields": [ { "precision": 3, "name": "lowTemp", "saqlExpression": "string_to_number(substr(Temperature, 1, 2))", "scale": 1, "label": "lowTemp", "type": "Numeric" }, { "precision": 3, "name": "highTemp", "saqlExpression": "string_to_number(substr(Temperature, 4, 2))", "scale": 1, "label": "highTemp", "type": "Numeric" } ] } } }
LinThawLinThaw
Hi Martin, not yet amended saql.
LinThawLinThaw
Hi Martin,

If you have still same issue found after edit saql.
please change left source and right source in [Augment Temp Class] node.

Then, stunk with still same issue,
please check [Load Seed Bank Agencies w/Climate Data] data flow too.

Regards,
LinThaw
 
Rebecca GrayRebecca Gray
Emilien Guichard 40 & LinThaw, Thank you!  Step 3.  Load Seed Bank Agencies  dataflow.
Any help will be much appreciated!! 

Data Manager
Load Seed Bank Agencies
DATAFLOW
Load Seed Bank Agencies


JSON for 'Load Seed Bank Agencies'

{ "Load Account": { "action": "sfdcDigest", "parameters": { "fields": [ { "name": "Name" }, { "name": "AccountNumber" }, { "name": "Phone" }, { "name": "ShippingCity" }, { "name": "ShippingCountry" }, { "name": "ShippingState" }, { "name": "ShippingStreet" }, { "name": "ShippingPostalCode" } ], "object": "Account" } }, "IsAgency": { "action": "filter", "parameters": { "filter": "IsAgency:EQ:TRUE", "source": "ID Agency Records" } }, "Create Seed Bank Agencies": { "action": "sfdcRegister", "parameters": { "name": "Seed Bank Agencies", "alias": "Seed_bank_agencies", "source": "IsAgency" } }, "Add Agency Fields": { "action": "augment", "parameters": { "right_key": [ "AccountNumber" ], "left": "Load Account", "left_key": [ "AccountNumber" ], "right_select": [ "Currency", "Acres", "SubRegion", "Region", "Latitude", "Longitude" ], "right": "Load Agency Detail", "relationship": "AgencyDetail", "operation": "LookupSingleValue" } }, "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\n", "label": "IsAgency", "type": "Text" } ] } }, "Load Agency Detail": { "action": "edgemart", "parameters": { "alias": "Load_Agency_Detail" } } }
 
LinThawLinThaw
Hi Rebecca,

Please update followings.

1. In [Load Agency Detail], Select ["Agency_Detail"] for Alias (Source).
2. In [Create Seed Bank Agencies], change Alias name to [seed_bank_agencies].

Please be careful naming of Alias in sfdcRegister, for later challenge.

Good Luck
Regards,
LinThaw
Justin BaidooJustin Baidoo
Hi all, 

I have followed LinTaw's excellent diagram for #3 but I'm still getting the 'Couldn’t find the 'Create Seed Bank Agencies' node or required fields are missing' error.

I have deleted and recreated the dataflow and it works as expected and also created the Top 5 Agencies lense so I have put my JSON file here to see if you can spot what is wrong as I can't see anything.

Many thanks

Justin
 
{
  "Load Account": {
    "action": "sfdcDigest",
    "parameters": {
      "fields": [
         { "name": "AccountNumber" },
         { "name": "Name" },
         { "name": "Phone" },
         { "name": "ShippingCity" },
         { "name": "ShippingCountry" },
         { "name": "ShippingPostalCode" },
         { "name": "ShippingState" },
         { "name": "ShippingStreet" }
      ],
      "object": "Account"
    }
  },
  "Load Agency Detail": {
    "action": "edgemart",
    "parameters": {
      "alias": "Agency_Detail"
    }
  },
  "Add Agency Fields": {
    "action": "augment",
    "parameters": {
      "operation": "LookupSingleValue",
      "relationship": "AgencyDetail",
      "left": "Load Account",
      "left_key": [
        "AccountNumber"
      ],
      "right": "Load Agency Detail",
      "right_key": [
        "AccountNumber"
      ],
      "right_select": [
        "Acres",
        "Currency",
        "Latitude",
        "Longitude",
        "Region",
        "SubRegion"
      ]
    }
  },
  "ID Agency Records": {
    "action": "computeExpression",
    "parameters": {
      "mergeWithSource": true,
      "source": "Add Agency Fields",
      "computedFields": [
        {
          "name": "IsAgency",
          "label": "IsAgency",
          "type": "Text",
          "saqlExpression": "case when Phone is not null then \"TRUE\" else \"FALSE\" end"
        }
      ]
    }
  },
  "Filter Agency Records": {
    "action": "filter",
    "parameters": {
      "source": "ID Agency Records",
      "filter": "IsAgency:EQ:TRUE"
    }
  },
  "Create Seed Bank Agencies": {
    "action": "sfdcRegister",
    "parameters": {
      "source": "Filter Agency Records",
      "alias": "seed_bank_agencies",
      "name": "Seed Bank Agencies"
    }
  }
}

 
Rebecca GrayRebecca Gray
Hello LinThaw,
Thank you for the feedback!  I adjusted the names - recreated the Agency_Detail dataset in order to fix the alias name, and adusted the alias name for the sfdcRegister node... same error message. I am going to recreate the whole dataflow in a new org -with special attention to the alias names.
I'll respond to the thread if I'm still having issues! 
 
LinThawLinThaw
Hi Rebecca,
Good Luck, when you create dataset from txt files, please don't change dataset's name.

Hi Justin,
Your dataflow is perfect, you need to create lens again.
I hope you can pass this challenge.

Regards,
LinThaw
Stephane PlanckeStephane Plancke

Hi I have problem with #3 

Challenge Not yet complete... here's what's wrong: 
Couldn’t find the 'Load Seed Bank Agencies' dataflow. Confirm the dataflow matches the name as described in the challenge.

Created 10 times again my DataFlow , Dataset and lens. --> still no succes

Here is my Json

{
  "Load Account": {
    "action": "sfdcDigest",
    "parameters": {
      "fields": [
         { "name": "AccountNumber" },
         { "name": "Name" },
         { "name": "Phone" },
         { "name": "ShippingCity" },
         { "name": "ShippingCountry" },
         { "name": "ShippingPostalCode" },
         { "name": "ShippingState" },
         { "name": "ShippingStreet" }
      ],
      "object": "Account"
    }
  },
  "Load Agency Detail": {
    "action": "edgemart",
    "parameters": {
      "alias": "Agency_Detail"
    }
  },
  "Add Agency Fields": {
    "action": "augment",
    "parameters": {
      "operation": "LookupSingleValue",
      "relationship": "AgencyDetail",
      "left": "Load Account",
      "left_key": [
        "AccountNumber"
      ],
      "right": "Load Agency Detail",
      "right_key": [
        "AccountNumber"
      ],
      "right_select": [
        "Acres",
        "Currency",
        "Latitude",
        "Longitude",
        "Region",
        "SubRegion"
      ]
    }
  },
  "ID Agency Records": {
    "action": "computeExpression",
    "parameters": {
      "mergeWithSource": true,
      "source": "Add Agency Fields",
      "computedFields": [
        {
          "name": "IsAgency",
          "label": "IsAgency",
          "type": "Text",
          "saqlExpression": "case when Phone is not null then \"TRUE\" else \"FALSE\" end"
        }
      ]
    }
  },
  "Filter Agency Records": {
    "action": "filter",
    "parameters": {
      "source": "ID Agency Records",
      "filter": "IsAgency:EQ:TRUE"
    }
  },
  "Create Seed Bank Agencies": {
    "action": "sfdcRegister",
    "parameters": {
      "source": "Filter Agency Records",
      "alias": "seed_bank_agencies",
      "name": "Seed Bank Agencies"
    }
  }
}
 



 

 

LinThawLinThaw
Hi Stephane,

json is fine.
Please check your dataflow name is [Load Seed Bank Agencies].
And your challenge playground is selected correctly.

Regards,
LinThaw
Stephane PlanckeStephane Plancke
@LinThaw 

Playground is correct and dataflow name is Load Seed Bank Agencies.

It succs --> step 3 works fine. why it will not check.

 
LinThawLinThaw
Hi Stephane, please try with new playground.
Rebecca GrayRebecca Gray
LinThaw- Would you mind looking at this again?
I re-created everthing for a third time in a new org, and I'm still getting the same error message:
Couldn’t find the 'Create Seed Bank Agencies' node or required fields are missing. Check the challenge and confirm the node name, alias, and required fields.

It's driving me a little crazy :) 

{ "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": "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": [ "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": [ { "name": "IsAgency", "saqlExpression": "case when Phone is not null then \"TRUE\" else \"FALSE\" end", "label": "IsAgency", "type": "Text" } ] } } }
LinThawLinThaw
Hi Rebecca Gray,

json is fine.
field and node name also correct.

Please check did you create Lens with latest dataset?
I think before run dataflow, please delete old dataset and lens.
dataset > Seed Bank Agencies
lens > Top 5 Agencies
and did you save lens in Mosaic App?
please show me your lens.

Regards,
LinThaw
Sushma VemireddySushma Vemireddy
Hi LinThaw ,

Please find the below JSON. I am facing below error.


Data Manager

    Load Seed Bank Agencies

Dataflow
Load Seed Bank Agencies
Update Dataflow
JSON for 'Load Seed Bank Agencies'
Download JSON
{
  "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": "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": [
        "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": [
        {
          "name": "IsAgency",
          "saqlExpression": "case when Phone is not null then \"TRUE\" else \"FALSE\" end",
          "label": "IsAgency",
          "type": "Text"
        }
      ]
    }
  }
}
Close
hidden


User-added image

Please help to clear Challenge#3.

thanks & Regards,
Sushma Vemireddy
LinThawLinThaw
Hi Sushma Vemireddy,

json is fine.

please check followig.
did you upload correctly [Accounts and Contacts] as business requirement, and [Agency Detail.txt].
did you created [Top 5 Agencies] lens according to business req.
This is my dataflow run result,
User-added image
please check compare with your result, input and output row counts.

Regards,
LinThaw
Sushma VemireddySushma Vemireddy
Thank you LinThaw. I have Passed Challenge #3.

Thanks for the support.
LinThawLinThaw
Great Sushma!
Sushma VemireddySushma Vemireddy
Hi LinThaw,

For Challenge #6 I am facing below error. Please help me to clear.

User-added image
LinThawLinThaw
Hi Sushma, please upload two json of data flow.
Sushma VemireddySushma Vemireddy
1. Load Seed Bank w/Temperature Classification

{
  "Add Temp Class": {
    "action": "computeExpression",
    "parameters": {
      "source": "Define Temp Range",
      "mergeWithSource": true,
      "computedFields": [
        {
          "defaultValue": "\"Continental\"",
          "name": "TempKey",
          "saqlExpression": "case \nwhen lowTemp < 25 and highTemp < 25 then \"Polar\" \nwhen lowTemp >= 25 and lowTemp <= 50 and highTemp >= 25 and highTemp <= 50 then \"Cool\"\nwhen lowTemp >= 51 and lowTemp <= 85 and highTemp >= 51 and highTemp <= 85 then \"Continental\"\nwhen lowTemp > 85 and highTemp > 85 then \"Tropical\"\nwhen lowTemp < 25 and (highTemp >= 25 and highTemp <= 50) then \"Polar-Cool\" \nwhen lowTemp < 25 and (highTemp >= 25 and highTemp <= 85) then \"Polar-Cool-Continental\" \nwhen lowTemp < 25 and highTemp > 85 then \"Polar-Cool-Continental-Tropical\" \nwhen (lowTemp >= 25 and lowTemp <= 50) and (highTemp >= 51 and highTemp <= 85) then \"Cool-Continental\" \nwhen (lowTemp >= 25 and lowTemp <= 50) and highTemp >= 85 then \"Cool-Continental-Tropical\" \nwhen (lowTemp >= 51 and lowTemp <= 85) and highTemp > 85 then \"Continental-Tropical\" \nend",
          "label": "TempKey",
          "type": "Text"
        }
      ]
    }
  },
  "Calculate Acreage": {
    "action": "computeExpression",
    "parameters": {
      "source": "Load Seed Chart",
      "mergeWithSource": true,
      "computedFields": [
        {
          "precision": 18,
          "name": "Acreage",
          "saqlExpression": "(Seeds_Pound*Spacing)/6272640",
          "scale": 6,
          "label": "Acreage",
          "type": "Numeric"
        }
      ]
    }
  },
  "Create Seed Bank": {
    "action": "sfdcRegister",
    "parameters": {
      "name": "Seed Bank",
      "alias": "seed_bank",
      "source": "CleanUp"
    }
  },
  "Load Seed Chart": {
    "action": "edgemart",
    "parameters": {
      "alias": "Seed_Chart"
    }
  },
  "Augment Temp Class": {
    "action": "augment",
    "parameters": {
      "right_key": [
        "TempKey"
      ],
      "left": "Add Temp Class",
      "left_key": [
        "TempKey"
      ],
      "right_select": [
        "TempClass"
      ],
      "right": "Load Temp Class Mapping",
      "relationship": "Climate",
      "operation": "LookupMultiValue"
    }
  },
  "Load Temp Class Mapping": {
    "action": "edgemart",
    "parameters": {
      "alias": "Temperature_Classes_Mapping"
    }
  },
  "CleanUp": {
    "action": "sliceDataset",
    "parameters": {
      "mode": "drop",
      "source": "Augment Temp Class",
      "fields": [
        {
          "name": "TempKey"
        },
        {
          "name": "highTemp"
        },
        {
          "name": "lowTemp"
        }
      ]
    }
  },
  "Define Temp Range": {
    "action": "computeExpression",
    "parameters": {
      "source": "Calculate Acreage",
      "mergeWithSource": true,
      "computedFields": [
        {
          "precision": 3,
          "name": "lowTemp",
          "saqlExpression": "string_to_number(substr(Temperature, 1, 2))",
          "scale": 1,
          "label": "lowTemp",
          "type": "Numeric"
        },
        {
          "precision": 3,
          "name": "highTemp",
          "saqlExpression": "string_to_number(substr(Temperature, 4, 2))",
          "scale": 1,
          "label": "highTemp",
          "type": "Numeric"
        }
      ]
    }
  }
}

2. Load Seed Bank Agencies w/Climate Data

{
  "Add Temp Class": {
    "action": "computeExpression",
    "parameters": {
      "source": "Load Climate",
      "mergeWithSource": true,
      "computedFields": [
        {
          "defaultValue": "Continental",
          "name": "TempClass",
          "saqlExpression": "case when Temperature < 25 then \"Polar\" when Temperature >= 25 and Temperature <= 50 then \"Cool\" when Temperature >= 51 and Temperature <= 85 then \"Continental\" when Temperature > 85 then \"Tropical\" end",
          "label": "TempClass",
          "type": "Text"
        }
      ]
    }
  },
  "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": "ShippingPostalCode"
        },
        {
          "name": "ShippingState"
        },
        {
          "name": "ShippingStreet"
        }
      ],
      "object": "Account"
    }
  },
  "Create Seed Bank Agencies": {
    "action": "sfdcRegister",
    "parameters": {
      "name": "Seed Bank Agencies",
      "alias": "seed_bank_agencies",
      "source": "Add Temp Class"
    }
  },
  "Load Climate": {
    "action": "edgemart",
    "parameters": {
      "alias": "Global_Climates"
    }
  },
  "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"
    }
  },
  "Filter 2015": {
    "action": "filter",
    "parameters": {
      "filter": "Date_Year:EQ:2015",
      "source": "Load Climate"
    }
  },
  "Augment TempClass": {
    "action": "augment",
    "parameters": {
      "right_key": [
        "Country"
      ],
      "left": "Filter Agency Records",
      "left_key": [
        "ShippingCountry"
      ],
      "right_select": [
        "Country",
        "Date",
        "TempClass",
        "Temperature"
      ],
      "right": "Add Temp Class",
      "relationship": "Climate",
      "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"
        }
      ]
    }
  }
}
LinThawLinThaw
Hi Sushma, 

your flow is not order, please try your data flow look like this.
User-added image
User-added image
Regards,
LinThaw
Sushma VemireddySushma Vemireddy
Hi LinThiw,

Can you please post your JSON / Screenshots of each node?

thanks
Sushma VemireddySushma Vemireddy
Thanks LinThiw . I have Passed Challenge #6. JSONS are not required.
LinThawLinThaw
Greate job! Sushma, near to get superbadge! please try.
Regards,
LinThaw
Sushma VemireddySushma Vemireddy
Thanks for the support LinThiw. Completed Superbadge Successfully. :)
Mars Rover 1106Mars Rover 1106
Hello LinThaw,

I am facing issue in Challenge # 6 "Load Seed Bank w/Temperature Classification"

Here is my JSON :

{
  "Add Temp Class": {
    "action": "computeExpression",
    "parameters": {
      "source": "Define Temp Range",
      "mergeWithSource": true,
      "computedFields": [
        {
          "defaultValue": "\"Continental\"",
          "name": "TempKey",
          "saqlExpression": "case \nwhen lowTemp < 25 and highTemp < 25 then \"Polar\" \nwhen lowTemp >= 25 and lowTemp = 25 and highTemp = 51 and lowTemp = 51 and highTemp 85 and highTemp > 85 then \"Tropical\"\nwhen lowTemp < 25 and (highTemp >= 25 and highTemp = 25 and highTemp 85 then \"Polar-Cool-Continental-Tropical\" \nwhen (lowTemp >= 25 and lowTemp = 51 and highTemp = 25 and lowTemp = 85 then \"Cool-Continental-Tropical\" \nwhen (lowTemp >= 51 and lowTemp 85 then \"Continental-Tropical\" \nend",
          "label": "TempKey",
          "type": "Text"
        }
      ]
    }
  },
  "Calculate Acreage": {
    "action": "computeExpression",
    "parameters": {
      "source": "Load Seed Chart",
      "mergeWithSource": true,
      "computedFields": [
        {
          "precision": 18,
          "name": "Acreage",
          "saqlExpression": "(Seeds_Pound*Spacing)/6272640",
          "scale": 6,
          "label": "Acreage",
          "type": "Numeric"
        }
      ]
    }
  },
  "Create Seed Bank": {
    "action": "sfdcRegister",
    "parameters": {
      "name": "Seed Bank",
      "alias": "seed_bank",
      "source": "CleanUp"
    }
  },
  "Load Seed Chart": {
    "action": "edgemart",
    "parameters": {
      "alias": "Seed_Chart"
    }
  },
  "Augment Temp Class": {
    "action": "augment",
    "parameters": {
      "right_key": [
        "TempKey"
      ],
      "left": "Add Temp Class",
      "left_key": [
        "TempKey"
      ],
      "right_select": [
        "TempClass"
      ],
      "right": "Load Temp Class Mapping",
      "relationship": "Climate",
      "operation": "LookupMultiValue"
    }
  },
  "Load Temp Class Mapping": {
    "action": "edgemart",
    "parameters": {
      "alias": "Temperature_Classes_Mapping"
    }
  },
  "CleanUp": {
    "action": "sliceDataset",
    "parameters": {
      "mode": "drop",
      "source": "Augment Temp Class",
      "fields": [
        {
          "name": "TempKey"
        },
        {
          "name": "highTemp"
        },
        {
          "name": "lowTemp"
        }
      ]
    }
  },
  "Define Temp Range": {
    "action": "computeExpression",
    "parameters": {
      "source": "Calculate Acreage",
      "mergeWithSource": true,
      "computedFields": [
        {
          "precision": 3,
          "name": "lowTemp",
          "saqlExpression": "string_to_number(substr(Temperature, 1, 2))",
          "scale": 1,
          "label": "lowTemp",
          "type": "Numeric"
        },
        {
          "precision": 3,
          "name": "highTemp",
          "saqlExpression": "string_to_number(substr(Temperature, 4, 2))",
          "scale": 1,
          "label": "highTemp",
          "type": "Numeric"
        }
      ]
    }
  }
}

Please help me to clear this challenge.

Thanks,
Indu
LinThawLinThaw
Hi Indu,

please change SAQL of TempKey as follows.

case 
when lowTemp < 25 and highTemp < 25 then "Polar" 
when lowTemp >= 25 and lowTemp <= 50 and highTemp >= 25 and highTemp <= 50 then "Cool"
when lowTemp >= 51 and lowTemp <= 85 and highTemp >= 51 and highTemp <= 85 then "Continental"
when lowTemp > 85 and highTemp > 85 then "Tropical"
when lowTemp < 25 and (highTemp >= 25 and highTemp <= 50) then "Polar-Cool" 
when lowTemp < 25 and (highTemp >= 25 and highTemp <= 85) then "Polar-Cool-Continental" 
when lowTemp < 25 and highTemp > 85 then "Polar-Cool-Continental-Tropical" 
when (lowTemp >= 25 and lowTemp <= 50) and (highTemp >= 51 and highTemp <= 85) then "Cool-Continental" 
when (lowTemp >= 25 and lowTemp <= 50) and highTemp >= 85 then "Cool-Continental-Tropical" 
when (lowTemp >= 51 and lowTemp <= 85) and highTemp > 85 then "Continental-Tropical" 
end

Regards,
LinThaw
Justin BaidooJustin Baidoo
I'm still stuck on Challenge #3 I've set up a new dev org and still getting the same error message despite the lens, JSON and everything else appearing correct. 

Thanks for your help anyway but I am out of options.

Regards

Justin
Mars Rover 1106Mars Rover 1106
Thanks LinThaw, Passed # 6, and facing issue in Challenge #7, Here is JSON

{
  "Add Temp Class": {
    "action": "computeExpression",
    "parameters": {
      "source": "Filter 2015",
      "mergeWithSource": true,
      "computedFields": [
        {
          "defaultValue": "Continental",
          "name": "TempClass",
          "saqlExpression": "case when Temperature < 25 then \"Polar\" when Temperature >= 25 and Temperature <= 50 then \"Cool\" when Temperature >= 51 and Temperature <= 85 then \"Continental\" when Temperature > 85 then \"Tropical\" end",
          "label": "TempClass",
          "type": "Text"
        }
      ]
    }
  },
  "Load Seed Orders": {
    "action": "edgemart",
    "parameters": {
      "alias": "Seed_Bank_Orders"
    }
  },
  "Create Order History": {
    "action": "sfdcRegister",
    "parameters": {
      "name": "Order History",
      "alias": "order_history",
      "source": "Add Seed Orders"
    }
  },
  "Augment Temp Class": {
    "action": "augment",
    "parameters": {
      "left": "Add Temp Class",
      "right": "Load Account",
      "relationship": "AugmentTempClass",
      "operation": "LookupSingleValue",
      "left_key": [
        "Country"
      ],
      "right_key": [
        "ShippingCountry"
      ],
      "right_select": [
        "AccountNumber",
        "Name",
        "Phone",
        "ShippingCity",
        "ShippingCountry",
        "ShippingPostalCode",
        "ShippingState",
        "ShippingStreet"
      ]
    }
  },
  "Load Climate": {
    "action": "edgemart",
    "parameters": {
      "alias": "Global_Climates"
    }
  },
  "Filter 2015": {
    "action": "filter",
    "parameters": {
      "filter": "Date_Year:EQ:2015'",
      "source": "Load Climate"
    }
  },
  "Add Agency Detail Fields": {
    "action": "augment",
    "parameters": {
      "left": "Load Account",
      "right": "Load Agency",
      "relationship": "AgencyDetail",
      "operation": "LookupSingleValue",
      "left_key": [
        "AccountNumber"
      ],
      "right_key": [
        "AccountNumber"
      ],
      "right_select": [
        "AccountNumber",
        "Acres",
        "Currency",
        "Latitude",
        "Longitude",
        "Region",
        "SubRegion"
      ]
    }
  },
  "ID Agency Records": {
    "action": "computeExpression",
    "parameters": {
      "source": "Add Agency Detail Fields",
      "mergeWithSource": true,
      "computedFields": [
        {
          "name": "IsAgency",
          "label": "IsAgency",
          "type": "Text",
          "saqlExpression": "case when Phone is not null then \"TRUE\" else \"FALSE\" end"
        }
      ]
    }
  },
  "Load Agency": {
    "action": "edgemart",
    "parameters": {
      "alias": "Agency_Detail"
    }
  },
  "Filter Agency Records": {
    "action": "filter",
    "parameters": {
      "filter": "Climate.IsAgency:EQ:TRUE",
      "source": "Add Agency Fields"
    }
  },
  "Load Account": {
    "action": "sfdcDigest",
    "parameters": {
      "fields": [
        {
          "name": "AccountNumber"
        },
        {
          "name": "Name"
        },
        {
          "name": "Phone"
        },
        {
          "name": "ShippingCity"
        },
        {
          "name": "ShippingCountry"
        },
        {
          "name": "ShippingPostalCode"
        },
        {
          "name": "ShippingState"
        },
        {
          "name": "ShippingStreet"
        }
      ],
      "object": "Account"
    }
  },
  "Add Agency Fields": {
    "action": "augment",
    "parameters": {
      "operation": "LookupSingleValue",
      "left": "Augment Temp Class",
      "relationship": "Climate",
      "right": "ID Agency Records",
      "left_key": [
        "AugmentTempClass.AccountNumber"
      ],
      "right_key": [
        "AccountNumber"
      ],
      "right_select": [
        "AccountNumber",
        "IsAgency",
        "Name",
        "Phone",
        "ShippingCity",
        "ShippingCountry",
        "ShippingPostalCode",
        "ShippingState",
        "ShippingStreet"
      ]
    }
  },
  "Add Seed Orders": {
    "action": "augment",
    "parameters": {
      "operation": "LookupSingleValue",
      "right": "Filter Agency Records",
      "left": "Load Seed Orders",
      "relationship": "SeedOrders",
      "left_key": [
        "Agency_ID"
      ],
      "right_key": [
        "Climate.Phone"
      ],
      "right_select": [
        "AugmentTempClass.AccountNumber",
        "AugmentTempClass.Name",
        "AugmentTempClass.Phone",
        "AugmentTempClass.ShippingCity",
        "AugmentTempClass.ShippingCountry",
        "AugmentTempClass.ShippingPostalCode",
        "AugmentTempClass.ShippingState",
        "AugmentTempClass.ShippingStreet"
      ]
    }
  }
}

Please help me to clear.

Thanks,
Indira
Mars Rover 1106Mars Rover 1106
Thanks LinThaw,

I cleared Superbadge, Thanks a ton :)
Rebecca GrayRebecca Gray
Hi LinThaw!  This superbadge may actually drive me crazy!  
I deleted my lense and re-created this morning after running the data flow. 

I'm still getting the same error message: "Coudn't find the 'Create Seed Bank Agencies' node or required fields are missing...."
I've created the data flow in three separate orgs, and get the same error every time.  I'm sure I'm missing something small! 
Thank you! 

Lens
Sunil SharmaSunil Sharma
Hello,  stuck at step #7 with this error :User-added image
LinThawLinThaw
Hi, Rebecca Gray
It should be crazy.....

Congrats Indira,
I think you edited like this, as I mentioned in old post.

-remove unnecessary single code in filter of [Filter 2015].

 and then please used same key on [Add Seed Orders] node.
-change right key to ["Climate.AccountNumber"].

Hi, Sunil Sharma
please use Indira's json and modify as above.

Good Luck,
Regards,
LinThaw.
LinThawLinThaw
Hi Rebecca and Justin,

you two stuck on Challenge #3 with same error.
please retry it on playground that you passed step 1 and 2.
or please try on new one by reading business requirement carefully.

Regards,
LinThaw
 
Rebecca GrayRebecca Gray
Thanks LinThaw!  Justin- I've created this dataflow/lense three times now with the same error message.
(Each time in a new org, starting from the top of the instructions.)

I'm sure there is some sort of tiny error, but I have not found it yet!
I'll post if I find the issue! 
LinThawLinThaw
Hi Jeremiah Cochran,

[Load Climate] node is 'Load Global Climate'.
How about your alias name and output fields?
User-added image
User-added image

If you have still face with this error, please upload json here.

Regards,
LinThaw
Simone Zocchi 1Simone Zocchi 1
Hi,
I'm stuck on Challenge 7 getting this error:
Error message

This is my flow
{
  "Add Temp Class": {
    "action": "computeExpression",
    "parameters": {
      "source": "Filter 2015",
      "mergeWithSource": true,
      "computedFields": [
        {
          "defaultValue": "Continental",
          "name": "TempClass",
          "saqlExpression": "case when Temperature < 25 then \"Polar\" when Temperature >= 25 and Temperature <= 50 then \"Cool\" when Temperature >= 51 and Temperature <= 85 then \"Continental\" when Temperature > 85 then \"Tropical\" end",
          "label": "TempClass",
          "type": "Text"
        }
      ]
    }
  },
  "Load Seed Orders": {
    "action": "edgemart",
    "parameters": {
      "alias": "Seed_Bank_Orders"
    }
  },
  "Create Order History": {
    "action": "sfdcRegister",
    "parameters": {
      "name": "Order History",
      "alias": "order_history",
      "source": "Add Seed Orders"
    }
  },
  "Augment Temp Class": {
    "action": "augment",
    "parameters": {
      "left": "Add Temp Class",
      "right": "Load Account",
      "relationship": "AugmentTempClass",
      "operation": "LookupSingleValue",
      "left_key": [
        "Country"
      ],
      "right_key": [
        "ShippingCountry"
      ],
      "right_select": [
        "AccountNumber",
        "Name",
        "Phone",
        "ShippingCity",
        "ShippingCountry",
        "ShippingPostalCode",
        "ShippingState",
        "ShippingStreet"
      ]
    }
  },
  "Load Climate": {
    "action": "edgemart",
    "parameters": {
      "alias": "Global_Climates"
    }
  },
  "Filter 2015": {
    "action": "filter",
    "parameters": {
      "filter": "Date_Year:EQ:2015",
      "source": "Load Climate"
    }
  },
  "Add Agency Detail Fields": {
    "action": "augment",
    "parameters": {
      "left": "Load Account",
      "right": "Load Agency",
      "relationship": "AgencyDetail",
      "operation": "LookupSingleValue",
      "left_key": [
        "AccountNumber"
      ],
      "right_key": [
        "AccountNumber"
      ],
      "right_select": [
        "AccountNumber",
        "Acres",
        "Currency",
        "Latitude",
        "Longitude",
        "Region",
        "SubRegion"
      ]
    }
  },
  "ID Agency Records": {
    "action": "computeExpression",
    "parameters": {
      "source": "Add Agency Detail Fields",
      "mergeWithSource": true,
      "computedFields": [
        {
          "name": "IsAgency",
          "label": "IsAgency",
          "type": "Text",
          "saqlExpression": "case when Phone is not null then \"TRUE\" else \"FALSE\" end"
        }
      ]
    }
  },
  "Load Agency": {
    "action": "edgemart",
    "parameters": {
      "alias": "Agency_Detail"
    }
  },
  "Filter Agency Records": {
    "action": "filter",
    "parameters": {
      "filter": "Climate.IsAgency:EQ:TRUE",
      "source": "Add Agency Fields"
    }
  },
  "Load Account": {
    "action": "sfdcDigest",
    "parameters": {
      "fields": [
        {
          "name": "AccountNumber"
        },
        {
          "name": "Name"
        },
        {
          "name": "Phone"
        },
        {
          "name": "ShippingCity"
        },
        {
          "name": "ShippingCountry"
        },
        {
          "name": "ShippingPostalCode"
        },
        {
          "name": "ShippingState"
        },
        {
          "name": "ShippingStreet"
        }
      ],
      "object": "Account"
    }
  },
  "Add Agency Fields": {
    "action": "augment",
    "parameters": {
      "operation": "LookupSingleValue",
      "left": "Augment Temp Class",
      "relationship": "Climate",
      "right": "ID Agency Records",
      "left_key": [
        "AugmentTempClass.AccountNumber"
      ],
      "right_key": [
        "AccountNumber"
      ],
      "right_select": [
        "AccountNumber",
        "IsAgency",
        "Name",
        "Phone",
        "ShippingCity",
        "ShippingCountry",
        "ShippingPostalCode",
        "ShippingState",
        "ShippingStreet"
      ]
    }
  },
  "Add Seed Orders": {
    "action": "augment",
    "parameters": {
      "operation": "LookupSingleValue",
      "right": "Filter Agency Records",
      "left": "Load Seed Orders",
      "relationship": "SeedOrders",
      "left_key": [
        "Agency_ID"
      ],
      "right_key": [
        "Climate.AccountNumber"
      ],
      "right_select": [
        "AugmentTempClass.AccountNumber",
        "AugmentTempClass.Name",
        "AugmentTempClass.Phone",
        "AugmentTempClass.ShippingCity",
        "AugmentTempClass.ShippingCountry",
        "AugmentTempClass.ShippingPostalCode",
        "AugmentTempClass.ShippingState",
        "AugmentTempClass.ShippingStreet"
      ]
    }
  }
}

And this is the Lens:
{
    "name": "Top_5_Seed_Bank_Orders",
    "label": "Top 5 Seed Bank Orders",
    "visualizationType": "hbar",
    "state": {
        "steps": {
            "aggregateflex": {
                "type": "aggregateflex",
                "query": {
                    "measures": [
                        [
                            "sum",
                            "Quantity_Ordered"
                        ]
                    ],
                    "order": [
                        [
                            "sum_Quantity_Ordered",
                            {
                                "ascending": false
                            }
                        ]
                    ],
                    "groups": [
                        "Seed_ID"
                    ],
                    "limit": 5
                },
                "visualizationParameters": {
                    "visualizationType": "hbar",
                    "options": {}
                },
                "datasets": [
                    {
                        "name": "order_history"
                    }
                ],
                "useGlobal": true,
                "isGlobal": false,
                "selectMode": "multi",
                "broadcastFacet": false,
                "receiveFacet": false
            }
        },
        "widgets": {
            "aggregateflex_chart": {
                "type": "chart",
                "parameters": {
                    "visualizationType": "hbar",
                    "autoFitMode": "keepLabels",
                    "theme": "wave",
                    "step": "aggregateflex",
                    "showValues": true,
                    "bins": {
                        "breakpoints": {
                            "high": 100,
                            "low": 0
                        },
                        "bands": {
                            "high": {
                                "color": "#008000",
                                "label": ""
                            },
                            "low": {
                                "color": "#B22222",
                                "label": ""
                            },
                            "medium": {
                                "color": "#ffa500",
                                "label": ""
                            }
                        }
                    },
                    "legend": {
                        "descOrder": false,
                        "showHeader": true,
                        "show": true,
                        "customSize": "auto",
                        "position": "right-top",
                        "inside": false
                    },
                    "axisMode": "multi",
                    "tooltip": {
                        "showBinLabel": true,
                        "measures": "",
                        "showPercentage": true,
                        "showDimensions": true,
                        "showMeasures": true,
                        "customizeTooltip": false,
                        "dimensions": ""
                    },
                    "exploreLink": true,
                    "title": {
                        "fontSize": 14,
                        "subtitleFontSize": 11,
                        "label": "",
                        "align": "center",
                        "subtitleLabel": ""
                    },
                    "binValues": false,
                    "trellis": {
                        "flipLabels": false,
                        "showGridLines": true,
                        "size": [
                            100,
                            100
                        ],
                        "enable": false,
                        "type": "x",
                        "chartsPerLine": 4
                    },
                    "columnMap": {
                        "trellis": [],
                        "dimensionAxis": [
                            "Seed_ID"
                        ],
                        "plots": [
                            "sum_Quantity_Ordered"
                        ]
                    },
                    "measureAxis2": {
                        "sqrtScale": false,
                        "showTitle": true,
                        "showAxis": true,
                        "title": "",
                        "customDomain": {
                            "showDomain": false
                        }
                    },
                    "measureAxis1": {
                        "sqrtScale": false,
                        "showTitle": true,
                        "showAxis": true,
                        "title": "",
                        "customDomain": {
                            "showDomain": false
                        }
                    },
                    "dimensionAxis": {
                        "showTitle": true,
                        "customSize": "auto",
                        "showAxis": true,
                        "title": "",
                        "icons": {
                            "useIcons": false,
                            "iconProps": {
                                "fit": "cover",
                                "column": "",
                                "type": "round"
                            }
                        }
                    },
                    "applyConditionalFormatting": true
                }
            }
        }
    },
    "datasets": [
        {
            "id": "0Fb0N000000JkFrSAK",
            "name": "order_history",
            "url": "/services/data/v43.0/wave/datasets/0Fb0N000000JkFrSAK"
        }
    ]
}

Thank you for your help,

Kind Regards​
Simone
 
LinThawLinThaw
Hi Simone,

Please try with my json for challenge 7.
It maybe a litte different with you.
I passed with this last one!
Good luck to you all.
{
  "Add Temp Class": {
    "action": "computeExpression",
    "parameters": {
      "source": "Filter 2015",
      "mergeWithSource": true,
      "computedFields": [
        {
          "defaultValue": "Continental",
          "name": "TempClass",
          "saqlExpression": "case when Temperature < 25 then \"Polar\" when Temperature >= 25 and Temperature <= 50 then \"Cool\" when Temperature >= 51 and Temperature <= 85 then \"Continental\" when Temperature > 85 then \"Tropical\" end",
          "label": "TempClass",
          "type": "Text"
        }
      ]
    }
  },
  "Load Seed Orders": {
    "action": "edgemart",
    "parameters": {
      "alias": "Seed_Bank_Orders"
    }
  },
  "Create Order History": {
    "action": "sfdcRegister",
    "parameters": {
      "name": "Order History",
      "alias": "order_history",
      "source": "Add Seed Orders"
    }
  },
  "Augment Temp Class": {
    "action": "augment",
    "parameters": {
      "right_key": [
        "Country"
      ],
      "left": "Load Account",
      "left_key": [
        "ShippingCountry"
      ],
      "right_select": [
        "TempClass",
        "Country",
        "Date",
        "Temperature"
      ],
      "right": "Add Temp Class",
      "relationship": "Climate",
      "operation": "LookupSingleValue"
    }
  },
  "Load Climate": {
    "action": "edgemart",
    "parameters": {
      "alias": "Global_Climates"
    }
  },
  "Add Seed Orders": {
    "action": "augment",
    "parameters": {
      "right_key": [
        "AccountNumber"
      ],
      "left": "Load Seed Orders",
      "left_key": [
        "Agency_ID"
      ],
      "right_select": [
        "Name",
        "Phone"
      ],
      "right": "Filter Agency Records",
      "relationship": "Agency",
      "operation": "LookupSingleValue"
    }
  },
  "Filter 2015": {
    "action": "filter",
    "parameters": {
      "filter": "Date_Year:R:2015",
      "source": "Load Climate"
    }
  },
  "ID Agency Records": {
    "action": "computeExpression",
    "parameters": {
      "source": "Add Agency Detail Fields",
      "mergeWithSource": true,
      "computedFields": [
        {
          "name": "IsAgency",
          "saqlExpression": "case when Phone is not null then \"TRUE\" else \"FALSE\" end",
          "label": "IsAgency",
          "type": "Text"
        }
      ]
    }
  },
  "Add Agency Detail Fields": {
    "action": "augment",
    "parameters": {
      "right_key": [
        "AccountNumber"
      ],
      "left": "Load Account",
      "left_key": [
        "AccountNumber"
      ],
      "right_select": [
        "AccountNumber",
        "Acres",
        "Currency",
        "Latitude",
        "Longitude",
        "Region",
        "SubRegion"
      ],
      "right": "Load Agency",
      "relationship": "AgencyDetail",
      "operation": "LookupSingleValue"
    }
  },
  "Load Agency": {
    "action": "edgemart",
    "parameters": {
      "alias": "Agency_Detail"
    }
  },
  "Filter Agency Records": {
    "action": "filter",
    "parameters": {
      "filter": "Climate.IsAgency:EQ:TRUE",
      "source": "Add Agency Fields"
    }
  },
  "Load Account": {
    "action": "sfdcDigest",
    "parameters": {
      "fields": [
        {
          "name": "AccountNumber"
        },
        {
          "name": "Name"
        },
        {
          "name": "Phone"
        },
        {
          "name": "ShippingCity"
        },
        {
          "name": "ShippingCountry"
        },
        {
          "name": "ShippingPostalCode"
        },
        {
          "name": "ShippingState"
        },
        {
          "name": "ShippingStreet"
        }
      ],
      "object": "Account"
    }
  },
  "Add Agency Fields": {
    "action": "augment",
    "parameters": {
      "right_key": [
        "AccountNumber"
      ],
      "left": "Augment Temp Class",
      "left_key": [
        "AccountNumber"
      ],
      "right_select": [
        "AccountNumber",
        "IsAgency",
        "Name",
        "Phone",
        "ShippingCity",
        "ShippingCountry",
        "ShippingPostalCode",
        "ShippingState",
        "ShippingStreet",
        "AgencyDetail.Currency",
        "AgencyDetail.Region",
        "AgencyDetail.SubRegion",
        "AgencyDetail.AccountNumber",
        "AgencyDetail.Latitude",
        "AgencyDetail.Acres",
        "AgencyDetail.Longitude"
      ],
      "right": "ID Agency Records",
      "relationship": "Climate",
      "operation": "LookupSingleValue"
    }
  }
}

Regards,
LinThaw
Simone Zocchi 1Simone Zocchi 1
Hi LinThaw,
I used your dataflow but still getting the same error.
My lens gives this results.
User-added image
Is it correct?

Regards
Simone
LinThawLinThaw
Hi Simone,

last record is different.
this is my lens.
User-added image
Regards,
LinThaw
Simone Zocchi 1Simone Zocchi 1
Hi LinThaw,
I was applying the wrong filter.
My lens now is exactely like your but still same error.
I also did all the steps again in a new org but still same result.
Any suggestion?

Thanks
Simone
LinThawLinThaw
Hi Simone,

unlucky, there should be no error.

Did you save your Lens to the Mosaic App?
Dataflow name is correct? Load Order History?
or did you make changes to txt from ea-data-preparation-specialist-data.zip?

Regards,
LinThaw.
Justin BaidooJustin Baidoo

Hi everyone stuck on challenge #3

I finally discovered what the problem was. So though the JSON and everything else was right, the issue was being caused by my customisation of the Agency Detail fields. I changed the latititude and longitude fields to dimensions instead of measures. You should leave it as-is and then it will work!

Finally figured out what I have done wrong! So I deleted my lens, dataset and dataflow and started again with the Agency Detail dataset and re-uploaded my JSON file for the Dataflow and I passed it!

Hope this helps others like Rebecca!

Thanks LinThaw for your continued advice and support

Rebecca GrayRebecca Gray
Justin Baidoo- That was the issue! Thank you!
I just had to edit the Agency Detail dataset and re--upload the file, leaving the latitude / longitude fields as they are.
 
LinThawLinThaw
Glad to hear! Congrats Justin and Rebecca.
Robert Greaves 22Robert Greaves 22
@LinThaw,

Now I'm stuck with the couldn't find the correct values error.  I'm sure everything is correct, however and I've reproduced the lens several time.  Any ideas?
User-added image
Simone Zocchi 1Simone Zocchi 1
@Robert we are in the same situation.
If you find a solution post it here please!

Thank you
Robert Greaves 22Robert Greaves 22
Here is the dataflow JSON,

{
  "Add Temp Class": {
    "action": "computeExpression",
    "parameters": {
      "source": "Filter 2015",
      "mergeWithSource": true,
      "computedFields": [
        {
          "defaultValue": "Continental",
          "name": "TempClass",
          "saqlExpression": "case when Temperature < 25 then \"Polar\" when Temperature >= 25 and Temperature <= 50 then \"Cool\" when Temperature >= 51 and Temperature <= 85 then \"Continental\" when Temperature > 85 then \"Tropical\" end",
          "label": "TempClass",
          "type": "Text"
        }
      ]
    }
  },
  "Load Seed Orders": {
    "action": "edgemart",
    "parameters": {
      "alias": "Seed_Bank_Orders"
    }
  },
  "Create Order History": {
    "action": "sfdcRegister",
    "parameters": {
      "name": "Order History",
      "alias": "order_history",
      "source": "Add Seed Orders"
    }
  },
  "Augment Temp Class": {
    "action": "augment",
    "parameters": {
      "right_key": [
        "Country"
      ],
      "left": "Load Account",
      "left_key": [
        "ShippingCountry"
      ],
      "right_select": [
        "TempClass",
        "Country",
        "Date",
        "Temperature"
      ],
      "right": "Add Temp Class",
      "relationship": "Climate",
      "operation": "LookupSingleValue"
    }
  },
  "Load Climate": {
    "action": "edgemart",
    "parameters": {
      "alias": "Global_Climates"
    }
  },
  "Add Seed Orders": {
    "action": "augment",
    "parameters": {
      "right_key": [
        "AccountNumber"
      ],
      "left": "Load Seed Orders",
      "left_key": [
        "Agency_ID"
      ],
      "right_select": [
        "Name",
        "Phone"
      ],
      "right": "Filter Agency Records",
      "relationship": "Agency",
      "operation": "LookupSingleValue"
    }
  },
  "Filter 2015": {
    "action": "filter",
    "parameters": {
      "filter": "Date_Year:R:2015",
      "source": "Load Climate"
    }
  },
  "ID Agency Records": {
    "action": "computeExpression",
    "parameters": {
      "source": "Add Agency Detail Fields",
      "mergeWithSource": true,
      "computedFields": [
        {
          "name": "IsAgency",
          "saqlExpression": "case when Phone is not null then \"TRUE\" else \"FALSE\" end",
          "label": "IsAgency",
          "type": "Text"
        }
      ]
    }
  },
  "Add Agency Detail Fields": {
    "action": "augment",
    "parameters": {
      "right_key": [
        "AccountNumber"
      ],
      "left": "Load Account",
      "left_key": [
        "AccountNumber"
      ],
      "right_select": [
        "AccountNumber",
        "Acres",
        "Currency",
        "Latitude",
        "Longitude",
        "Region",
        "SubRegion"
      ],
      "right": "Load Agency",
      "relationship": "AgencyDetail",
      "operation": "LookupSingleValue"
    }
  },
  "Load Agency": {
    "action": "edgemart",
    "parameters": {
      "alias": "Agency_Detail"
    }
  },
  "Filter Agency Records": {
    "action": "filter",
    "parameters": {
      "filter": "Climate.IsAgency:EQ:TRUE",
      "source": "Add Agency Fields"
    }
  },
  "Load Account": {
    "action": "sfdcDigest",
    "parameters": {
      "fields": [
        {
          "name": "AccountNumber"
        },
        {
          "name": "Name"
        },
        {
          "name": "Phone"
        },
        {
          "name": "ShippingCity"
        },
        {
          "name": "ShippingCountry"
        },
        {
          "name": "ShippingPostalCode"
        },
        {
          "name": "ShippingState"
        },
        {
          "name": "ShippingStreet"
        }
      ],
      "object": "Account"
    }
  },
  "Add Agency Fields": {
    "action": "augment",
    "parameters": {
      "right_key": [
        "AccountNumber"
      ],
      "left": "Augment Temp Class",
      "left_key": [
        "AccountNumber"
      ],
      "right_select": [
        "AccountNumber",
        "IsAgency",
        "Name",
        "Phone",
        "ShippingCity",
        "ShippingCountry",
        "ShippingPostalCode",
        "ShippingState",
        "ShippingStreet",
        "AgencyDetail.Currency",
        "AgencyDetail.Region",
        "AgencyDetail.SubRegion",
        "AgencyDetail.AccountNumber",
        "AgencyDetail.Latitude",
        "AgencyDetail.Acres",
        "AgencyDetail.Longitude"
      ],
      "right": "ID Agency Records",
      "relationship": "Climate",
      "operation": "LookupSingleValue"
    }
  }
}
Robert Greaves 22Robert Greaves 22
I have not made any changes to the data such as was mentioned above.  Everything is saved in Mosaic and you can see that the dataflow and lens are named correctly.  I don't know where to turn.
LinThawLinThaw
Hi Anil,

I am not sure,
please select last row as below.
User-added image

Hi Robert and Simone,

your error is hard to find.
How about your Account Replication?
User-added image
If it is fine, please try run Account Replication again before your dataflow run.

Regards,
LinThaw.
Anil Shivaraj1Anil Shivaraj1
Your screenshot helped me get the problem, thanks Lin. Issue was with my 5th selection in the bar graph, for some reason it was removing the last row i selected and replacing the 6th row (that seems not very clean way of focus function working)
So i paid attention to the selection and made sure the correct top 5 are selected and it passed now. On to #4. Thanks again
LinThawLinThaw
Yes, that is right when working on focus function we need to focus.
Robert Greaves 22Robert Greaves 22
My problem was the same as Anil's.  This morning I removed the filter and this time the highlighting of the 5 rows worked and I passed.  It's done!

@Simone let me know if you still need help.  Maybe we can do a WebEx and figure it out.
Tom NovelleTom Novelle
Hi, im having a problem with challenge 4. 

Challenge Not yet complete... here's what's wrong: 
Couldn’t find the 'Load Seed Chart' node in the dataflow. Confirm the node name matches the name as described in the challenge.


that node is in the my dataflow ive made and re made the dataset, the dataflow, the nodes and the lens for this challenge but it wont work :(

User-added image
LinThawLinThaw
Hi Tom Novelle,

In first node, you have to select dataset ["Seed_Chart"].

if still got error, plz upload your json.

Regards,
LinThaw
Tom NovelleTom Novelle
Yesterday i tried with a dataset called "Seed_Bank" and one called "Seed_Chart" but neither worked today Seed Chart worked, thanks :)
Ramon DelSaltoRamon DelSalto
Hello All, i need a bit of help here with the Einstein Analytics Data Preparation Specialist item #6 Determine Optimal Climates. i'm getting the follwoing error:
"Challenge Not yet complete... here's what's wrong:
Couldn’t find the 'Create Seed Bank' node or required fields are missing. Check the challenge and confirm the node name and required fields."

Belos is the json and the data flow. thanks in advance.
Ramon
User-added image


JSON

{
  "Add Temp Class": {
    "action": "computeExpression",
    "parameters": {
      "source": "Filter 2015",
      "mergeWithSource": true,
      "computedFields": [
        {
          "defaultValue": "Continental",
          "name": "TempClass",
          "saqlExpression": "case when Temperature < 25 then \"Polar\" when Temperature >= 25 and Temperature <= 50 then \"Cool\" when Temperature >= 51 and Temperature <= 85 then \"Continental\" when Temperature > 85 then \"Tropical\" end",
          "label": "TempClass",
          "type": "Text"
        }
      ]
    }
  },
  "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": "ShippingState"
        },
        {
          "name": "ShippingStreet"
        },
        {
          "name": "ShippingPostalCode"
        }
      ],
      "object": "Account"
    }
  },
  "Create Seed Bank Agencies": {
    "action": "sfdcRegister",
    "parameters": {
      "rowLevelSecurityFilter": "",
      "name": "Seed Bank Agencies",
      "alias": "seed_bank_agencies",
      "source": "Augment TempClass"
    }
  },
  "Load Climate": {
    "action": "edgemart",
    "parameters": {
      "alias": "Global_Climates"
    }
  },
  "Add Agency Fields": {
    "action": "augment",
    "parameters": {
      "right_key": [
        "AccountNumber"
      ],
      "left": "Load Account",
      "left_key": [
        "AccountNumber"
      ],
      "right_select": [
        "Acres",
        "Currency",
        "Longitude",
        "Latitude",
        "Region",
        "SubRegion"
      ],
      "right": "Load Agency Detail",
      "relationship": "AgencyDetail",
      "operation": "LookupSingleValue"
    }
  },
  "Filter 2015": {
    "action": "filter",
    "parameters": {
      "filter": "Date_Year:EQ:2015",
      "source": "Load Climate"
    }
  },
  "Augment TempClass": {
    "action": "augment",
    "parameters": {
      "right_key": [
        "Country"
      ],
      "left": "Filter Agency Records",
      "left_key": [
        "ShippingCountry"
      ],
      "right_select": [
        "Country",
        "Date",
        "TempClass",
        "Temperature"
      ],
      "right": "Add Temp Class",
      "relationship": "Climate",
      "operation": "LookupSingleValue"
    }
  },
  "Load Agency Detail": {
    "action": "edgemart",
    "parameters": {
      "alias": "Load_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 NovelleTom Novelle
Hi guys,
im having trouble with challenge #6

i have the Couldn’t find the 'Create Seed Bank' node error. i think i am getting the wrong output fields on this node but im not sure at which point i am going wrong.

JSON:
{
  "Calculate Acreage": {
    "action": "computeExpression",
    "parameters": {
      "source": "Load Seed Chart",
      "mergeWithSource": true,
      "computedFields": [
        {
          "precision": 18,
          "name": "Acreage",
          "saqlExpression": "(Seeds_Pound*Spacing)/6272640",
          "scale": 6,
          "label": "Acreage",
          "type": "Numeric"
        }
      ]
    }
  },
  "Load Seed Chart": {
    "action": "edgemart",
    "parameters": {
      "alias": "Seed_Chart"
    }
  },
  "Load Temp Class Mapping": {
    "action": "edgemart",
    "parameters": {
      "alias": "Temperature_Classes_Mapping"
    }
  },
  "Add Temp Class": {
    "action": "computeExpression",
    "parameters": {
      "mergeWithSource": true,
      "computedFields": [
        {
          "name": "Temp_Class",
          "label": "Temp_Class",
          "type": "Text",
          "saqlExpression": "case\nwhen lowTemp < 25 and highTemp < 25 then \"Polar\" \nwhen lowTemp >= 25 and lowTemp <= 50 and highTemp >= 25 and highTemp <= 50 then \"Cool\"\nwhen lowTemp >= 51 and lowTemp <= 85 and highTemp >= 51 and highTemp <= 85 then \"Continental\"\nwhen lowTemp > 85 and highTemp > 85 then \"Tropical\"\nwhen lowTemp < 25 and (highTemp >= 25 and highTemp <= 50) then \"Polar-Cool\" \nwhen lowTemp < 25 and (highTemp >= 25 and highTemp <= 85) then \"Polar-Cool-Continental\" \nwhen lowTemp < 25 and highTemp > 85 then \"Polar-Cool-Continental-Tropical\" \nwhen (lowTemp >= 25 and lowTemp <= 50) and (highTemp >= 51 and highTemp <= 85) then \"Cool-Continental\" \nwhen (lowTemp >= 25 and lowTemp <= 50) and highTemp >= 85 then \"Cool-Continental-Tropical\" \nwhen (lowTemp >= 51 and lowTemp <= 85) and highTemp > 85 then \"Continental-Tropical\" \nend",
          "defaultValue": "Continental"
        }
      ],
      "source": "Define Temp Range"
    }
  },
  "Augment Temp Class": {
    "action": "augment",
    "parameters": {
      "operation": "LookupSingleValue",
      "left": "Add Temp Class",
      "relationship": "Climate",
      "right": "Load Temp Class Mapping",
      "left_key": [
        "Temp_Class"
      ],
      "right_key": [
        "TempClass"
      ],
      "right_select": [
        "TempKey",
        "TempClass"
      ]
    }
  },
  "Define Temp Range": {
    "action": "computeExpression",
    "parameters": {
      "mergeWithSource": true,
      "source": "Calculate Acreage",
      "computedFields": [
        {
          "name": "lowTemp",
          "label": "lowTemp",
          "type": "Numeric",
          "saqlExpression": "string_to_number(substr(Temperature, 1, 2)) ",
          "precision": 18,
          "scale": 2,
          "defaultValue": "0"
        },
        {
          "name": "highTemp",
          "label": "highTemp",
          "type": "Numeric",
          "saqlExpression": "string_to_number(substr(Temperature, -2, 2)) ",
          "precision": 18,
          "scale": 2,
          "defaultValue": "0"
        }
      ]
    }
  },
  "Clean Up": {
    "action": "sliceDataset",
    "parameters": {
      "mode": "drop",
      "fields": [
        {
          "name": "lowTemp"
        },
        {
          "name": "highTemp"
        },
        {
          "name": "Climate.TempKey"
        },
        {
          "name": "Climate.TempClass"
        },
        {
          "name": "Temp_Class"
        }
      ],
      "source": "Augment Temp Class"
    }
  },
  "Create Seed Bank": {
    "action": "sfdcRegister",
    "parameters": {
      "source": "Clean Up",
      "alias": "seed_bank",
      "name": "Seed Bank"
    }
  }
}

Thanks for all the help :)
LinThawLinThaw
Hi Tom and Ramon,

First, try with following correction in your flow, if it is not solved please use my json.

>Ramos
please use dataset name ["Agency_Detail"] instead of ["Load_Agency_Detail"] at [Load Agency Detail] node.

>Tom
please change field name and label from [Temp_Class] to [TempClass] at [Add Temp Class] node.
and
please change left source and right source at [Augment Temp Class] node.

----------------------------------------------
Load Seed Bank Agencies w/Climate Data
----------------------------------------------
{
  "Add Temp Class": {
    "action": "computeExpression",
    "parameters": {
      "source": "Filter 2015",
      "mergeWithSource": true,
      "computedFields": [
        {
          "defaultValue": "Continental",
          "name": "TempClass",
          "saqlExpression": "case when Temperature < 25 then \"Polar\" when Temperature >= 25 and Temperature <= 50 then \"Cool\" when Temperature >= 51 and Temperature <= 85 then \"Continental\" when Temperature > 85 then \"Tropical\" end",
          "label": "TempClass",
          "type": "Text"
        }
      ]
    }
  },
  "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": "Augment TempClass"
    }
  },
  "Load Climate": {
    "action": "edgemart",
    "parameters": {
      "alias": "Global_Climates"
    }
  },
  "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"
    }
  },
  "Filter 2015": {
    "action": "filter",
    "parameters": {
      "filter": "Date_Year:EQ:2015",
      "source": "Load Climate"
    }
  },
  "Augment TempClass": {
    "action": "augment",
    "parameters": {
      "right_key": [
        "Country"
      ],
      "left": "Filter Agency Records",
      "left_key": [
        "ShippingCountry"
      ],
      "right_select": [
        "Country",
        "Date",
        "TempClass",
        "Temperature"
      ],
      "right": "Add Temp Class",
      "relationship": "Climate",
      "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"
        }
      ]
    }
  }
}
---------------------------------------------------
Load Seed Bank w/Temperature Classification
---------------------------------------------------
{
  "Add Temp Class": {
    "action": "computeExpression",
    "parameters": {
      "source": "Define Temp Range",
      "mergeWithSource": true,
      "computedFields": [
        {
          "name": "TempClass",
          "saqlExpression": "case \nwhen lowTemp < 25 and highTemp < 25 then \"Polar\" \nwhen lowTemp >= 25 and lowTemp <= 50 and highTemp >= 25 and highTemp <= 50 then \"Cool\"\nwhen lowTemp >= 51 and lowTemp <= 85 and highTemp >= 51 and highTemp <= 85 then \"Continental\"\nwhen lowTemp > 85 and highTemp > 85 then \"Tropical\"\nwhen lowTemp < 25 and (highTemp >= 25 and highTemp <= 50) then \"Polar-Cool\" \nwhen lowTemp < 25 and (highTemp >= 25 and highTemp <= 85) then \"Polar-Cool-Continental\" \nwhen lowTemp < 25 and highTemp > 85 then \"Polar-Cool-Continental-Tropical\" \nwhen (lowTemp >= 25 and lowTemp <= 50) and (highTemp >= 51 and highTemp <= 85) then \"Cool-Continental\" \nwhen (lowTemp >= 25 and lowTemp <= 50) and highTemp >= 85 then \"Cool-Continental-Tropical\" \nwhen (lowTemp >= 51 and lowTemp <= 85) and highTemp > 85 then \"Continental-Tropical\" \nend",
          "label": "TempClass",
          "type": "Text"
        }
      ]
    }
  },
  "Calculate Acreage": {
    "action": "computeExpression",
    "parameters": {
      "source": "Load Seed Chart",
      "mergeWithSource": true,
      "computedFields": [
        {
          "defaultValue": "0",
          "precision": 18,
          "name": "Acreage",
          "saqlExpression": "(Seeds_Pound*Spacing)/6272640",
          "scale": 6,
          "label": "Acreage",
          "type": "Numeric"
        }
      ]
    }
  },
  "Create Seed Bank": {
    "action": "sfdcRegister",
    "parameters": {
      "name": "Seed Bank",
      "alias": "seed_bank",
      "source": "CleanUp"
    }
  },
  "Load Seed Chart": {
    "action": "edgemart",
    "parameters": {
      "alias": "Seed_Chart"
    }
  },
  "Augment Temp Class": {
    "action": "augment",
    "parameters": {
      "right_key": [
        "TempClass"
      ],
      "left": "Load Temp Class Mapping",
      "left_key": [
        "TempKey"
      ],
      "right_select": [
        "Acreage",
        "highTemp",
        "Lifecycle",
        "lowTemp",
        "Quantity_Pounds",
        "Seed",
        "Seeds_Pound",
        "Seed_ID",
        "Seed_Type",
        "Spacing",
        "TempClass",
        "Temperature"
      ],
      "right": "Add Temp Class",
      "relationship": "Climate",
      "operation": "LookupSingleValue"
    }
  },
  "Load Temp Class Mapping": {
    "action": "edgemart",
    "parameters": {
      "alias": "Temperature_Classes_Mapping"
    }
  },
  "CleanUp": {
    "action": "sliceDataset",
    "parameters": {
      "mode": "drop",
      "source": "Augment Temp Class",
      "fields": [
        {
          "name": "TempClass"
        },
        {
          "name": "TempKey"
        },
        {
          "name": "Climate.highTemp"
        },
        {
          "name": "Climate.lowTemp"
        }
      ]
    }
  },
  "Define Temp Range": {
    "action": "computeExpression",
    "parameters": {
      "source": "Calculate Acreage",
      "mergeWithSource": true,
      "computedFields": [
        {
          "defaultValue": "0",
          "precision": 18,
          "name": "lowTemp",
          "saqlExpression": "string_to_number( substr(Temperature, 1, 2))",
          "scale": 2,
          "label": "lowTemp",
          "type": "Numeric"
        },
        {
          "defaultValue": "0",
          "precision": 18,
          "name": "highTemp",
          "saqlExpression": "string_to_number(substr(Temperature, -2, 2))",
          "scale": 2,
          "label": "highTemp",
          "type": "Numeric"
        }
      ]
    }
  }
}

Regards,
LinThaw​
LinThawLinThaw
world cup is overwriting my memory,
sorry not Ramos, Ramon!
Tom NovelleTom Novelle
Thanks Lin,
passed the super badge now, thank you for all the help :)
LinThawLinThaw
Congrats Tom!
Mathieu NobletMathieu Noblet
Hi

I'm stuck on step 3 with that error message : Couldn’t find the correct values. Please check your work.

Does anyone have an idea on what's wrong? I created the dataflow following Lin's advices. It ran normally. I created the "Top 5" Lens on the MOsaic app. 
I can't figure out what's going on...

Thanks!
LinThawLinThaw
Hi Mathieu,

Did you try this?
User-added image
Regards,
LinThaw
Mathieu NobletMathieu Noblet
I started over and deleted the dataflow, dataset and the lens and did it again and I passed it! 

Thanks.
LinThawLinThaw
Congrats Mathieu!
Mathieu NobletMathieu Noblet
Superbadge Completed!
Thanks for your support guys!
User-added image 
Ducamp SebastienDucamp Sebastien
Hello Simone, Robert
I was stuck at the same point and my problem came from the filters applied in the lens on the column seed id: this one should be in the exact same order than the descending order found, that is A1040, A1019, A1030, A1026, P1009 ! After checking the image you uploaded Robert, it seems that you have exactly the same problem than mine. To do that, respect exactly the path given: use the focus and do not select manually the seed id. In my case, I had to select the first 6 lines to get the 5 lines required :-)
Please check the image below and test!
User-added image
Sébastien
 
Shobha JamesShobha James
I am stuck in#3.. i think something wrong with node:ID Agency record
getting the error when running the Dataflow

Application Error
WARNING: Your dataflow definition contains errors that will cause your dataflow to fail.
The dataflow definition validation failed for the Load_Seed_Bank_Agencies dataflow.
The dataflow can't have an empty value for [saqlExpression] under parameter 'computedFields' in node [ID Agency Records].
Continue

can someone please help me on this?

Shobha
Shobha JamesShobha James
i resolved the above issue but still i am getting the error:
Challenge Not yet complete... here's what's wrong: 
Couldn’t find Agency records from the Account object.
 
LinThawLinThaw
Hi Shobha James, ​did you create [Top 5 Agencies] Lens?
Shobha JamesShobha James
Hi LinThaw,
yes i had created ...
LinThawLinThaw
Hi Shobha, please show me your lens.
Shobha JamesShobha James
 then i gone through the above all threads and i deleted the dataflow and data sets and again created all..now my dataset: Seed Bank Agencies returns 0 rows ,and not able to create the Lens..

User-added image
will give you the steps i followed :
1.Created the Data set-Agency Detail, using AgencyDetail.txt
2 Created the Data set Seed Bank Agency-using Account
Created the work flow as per the instruction 

This is the output  fields of the Create Seed Bank Agencies: sfdcRegisterUser-added image


can you please help me on this?
thanks,
Shobha
LinThawLinThaw
Hi Shobha,

output rows of [Filter Agency Records] node is 383.
In your case, there is no output rows.

please check filter again.
User-added image
Regards,
LinThaw.
LinThawLinThaw
check this one too.
User-added image
 
Shobha JamesShobha James
thanks a lot  LinThaw..i passed the step #3....there was an "" symbol in my SAQL expression..that was the error..
LinThawLinThaw
Greate!
Mohit BMohit B

Hi Lin,

I am facing the below error while running the dataflow in steps 6 :

"Something went wrong while executing the Augment Temp Class node: Right select in augment node must properly refer to the right input column. Node Augment Temp Class refers to field TempClass not present in right source. (02K7F000000JVZ8UAO_03C7F000001V2ZhUAK)"


Below is the output field which I am getting in "Augment Temp Class" steps :

Climate.TempClass                       Add Temp Class(computeExpression) -> Augment Temp Class(augment)

Please review and share your thoughts on the same.

Thanks
Mohit

LinThawLinThaw
Hi Mohit, please upload your dataflow json.
Mohit BMohit B

Thanks for your quick response !!

Please find below json code :

{
  "Add Temp Class": {
    "action": "computeExpression",
    "parameters": {
      "source": "Filter 2015",
      "mergeWithSource": true,
      "computedFields": [
        {
          "defaultValue": "Continental",
          "name": "TempClass",
          "saqlExpression": "case when Temperature < 25 then \"Polar\" when Temperature >= 25 and Temperature <= 50 then \"Cool\" when Temperature >= 51 and Temperature <= 85 then \"Continental\" when Temperature > 85 then \"Tropical\" end\"",
          "label": "TempClass",
          "type": "Text"
        }
      ]
    }
  },
  "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"
    }
  },
  "Augment Temp Class": {
    "action": "augment",
    "parameters": {
      "right_key": [
        "Country"
      ],
      "left": "Filter Agency Records",
      "left_key": [
        "ShippingCountry"
      ],
      "right_select": [
        "Country",
        "Date",
        "Temperature",
        "TempClass"
      ],
      "right": "Add Temp Class",
      "relationship": "Climate",
      "operation": "LookupSingleValue"
    }
  },
  "Create Seed Bank Agencies": {
    "action": "sfdcRegister",
    "parameters": {
      "name": "Seed Bank Agencies",
      "alias": "seed_bank_agencies",
      "source": "Augment Temp Class"
    }
  },
  "Load Climate": {
    "action": "edgemart",
    "parameters": {
      "alias": "Global_Climates"
    }
  },
  "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"
    }
  },
  "Filter 2015": {
    "action": "filter",
    "parameters": {
      "filter": "Date_Year:EQ: 2015'",
      "source": "Load Climate"
    }
  },
  "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\n",
          "label": "IsAgency",
          "type": "Text"
        }
      ]
    }
  }
}

LinThawLinThaw
Hi Mohit,

this error cos of your typo?
please edit as follow.

@ Node [Filter 2015]
remove space and single code
Date_Year:EQ: 2015' 

like this
Date_Year:EQ:2015

@ SAQL Expression of Node [Add Temp Class]
remove last double code
case when Temperature < 25 then "Polar" when Temperature >= 25 and Temperature <= 50 then "Cool" when Temperature >= 51 and Temperature <= 85 then "Continental" when Temperature > 85 then "Tropical" end"

like this
case when Temperature < 25 then "Polar" when Temperature >= 25 and Temperature <= 50 then "Cool" when Temperature >= 51 and Temperature <= 85 then "Continental" when Temperature > 85 then "Tropical" end

Regards & Goodluck
LinThaw
Mohit BMohit B
Thank you Lin, You are awesome !! I am able to complete step 6 now. 
LinThawLinThaw
Congrats Mohit!
zack reeserzack reeser
Hi Lin,
I am stuck on Step 4, getting the error 
Challenge Not yet complete... here's what's wrong: 
Couldn’t find the Acreage field. Check the challenge and confirm required field setting.

Here is my json, and I am not sure why it cannot find the Acreage field

{ "Create Seed Bank": { "action": "sfdcRegister", "parameters": { "name": "Seed Bank", "alias": "Seed_bank", "source": "Calculate Acrage" } }, "Load Seed Chart": { "action": "edgemart", "parameters": { "alias": "Seed_Chart" } }, "Calculate Acrage": { "action": "computeExpression", "parameters": { "source": "Load Seed Chart", "mergeWithSource": true, "computedFields": [ { "name": "Acreage", "label": "Acreage", "type": "Numeric", "saqlExpression": "(Seeds_Pound*Spacing)/6272640", "precision": 18, "scale": 6 } ] } } }
 
LinThawLinThaw
Hi zack,

your node name is wrong, correct is [Calculate Acreage].
and please edit Alias of [Create Seed Bank] node to seed_bank.
also be care when naming Alias of sfdcRegister in next challenge.

Regards,
LinThaw
 
zack reeserzack reeser
Wow, knew it was something simple, thank you!
Shobha JamesShobha James
Superbadge Complete!
+4750 Points
George VazquezGeorge Vazquez
Hi LinThaw,
I am receiving the error for #6 
Challenge Not yet complete... here's what's wrong: 
Couldn’t find the 'Create Seed Bank Agencies' node or required fields are missing. Check the challenge and confirm the node name and required fields.


I tried copying your JSON to rule out that my code was incorrect, but I am not sure if it is my output fields that are incorrect. My register node looks correct as well. The documentation states the output fields should look like this:
Registers the Seed Bank dataset with the new Temp Class field.
Climate.TempClass
Acreage
Seed ID
Seed Type
Seed
Spacing
Seeds_Pound
Quantity_Pounds
Lifecycle
Temperature

Any advice? 

w/Temperature
User-added image
User-added image
w/Climate Data
User-added image
LinThawLinThaw
Hi George,

There are some error in [Create Seed Bank Agencies: sfdcRegister] of w/Climate Data.
Please refer below image.
User-added image

Regards,
LinThaw
GunwantGunwant
Hi Lin,

I am getting warning at Challenge#3 . Could you help me here?
"The dataflow was completed, but the LookupSingleValue node didn't augment any columns. Either the node didn't find any matches, or a join key contains only null values."
 
LinThawLinThaw
Hi Gunwant please upload your json here.
GunwantGunwant

Hi Lin,
 

Thanks for your quick response. Please find the below JSON generated from dataflow.

{
  "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": "ShippingStreet"
        },
        {
          "name": "ShippingState"
        },
        {
          "name": "ShippingCountry"
        },
        {
          "name": "OwnerId"
        }
      ],
      "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",
        "Longitude",
        "Latitude"
      ],
      "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"
        }
      ]
    }
  }
}

LinThawLinThaw
Hi Gunwant,
your dataflow is running success,
please show me warning screen.
 
GunwantGunwant
Warning There is no data because of warning message
LinThawLinThaw
Hi Gunwant, please check your existing account data imported.
User-added image
Dataset and Flow Result is as follows.
User-added image
User-added image
Regards,
LinThaw
GunwantGunwant
Hi Lin,

I have checked the account records. I do have in my org. Agency detail data is having 383 records, but Seed Bank Agencies dataset is not having any records.
I think "Seed Bank Agencies" dataset will be filled with records once dataflow will be executed successfully. Here it is not giving any records when i run it. 
When I click on challenge, i do not get errors about dataflow, but i get error 'Couldn’t find 'Top 5 Agencies' lens. Please confirm the name as described'. When i try to create this lens, i cannot see any records on chart and i cannot filter our records on account name on vertical axis. that is where i got stuck. Your help much appreciated.
User-added image
LinThawLinThaw
Hi Gunwant,

your phone number format is different with me. 
but it is not problem I think because phone is not null is condition.

please check all 383 record has AccountNumber as follow.
because AccountNumber is key to join Account in org and Agency Detail from CSV.
User-added image

And please also check Agency Detail dataset has AccountNumber.
User-added image

Regards,
LinThaw
ASHISH VARMAASHISH VARMA
Hi Every one,

I am stucked in #3 Create Seed Bank Agencies. Facing weird issue that i could not figure out despite of many attempts and many checks. Please assist.

Challenge Not yet complete... here's what's wrong:  Couldn’t find Account Name filter.
Please find the dataflow JSON and help me figure out the issue.

{
  "Filter Agency Records": {
    "action": "filter",
    "parameters": {
      "filter": "IsAgency:EQ:true",
      "source": "ID Agency Records"
    }
  },
  "Load Account": {
    "action": "sfdcDigest",
    "parameters": {
      "fields": [
        {
          "name": "AccountNumber"
        },
        {
          "name": "AccountSource"
        },
        {
          "name": "AnnualRevenue"
        },
        {
          "name": "BillingCity"
        },
        {
          "name": "BillingCountry"
        },
        {
          "name": "BillingLatitude"
        },
        {
          "name": "BillingLongitude"
        },
        {
          "name": "BillingPostalCode"
        },
        {
          "name": "BillingStreet"
        },
        {
          "name": "CleanStatus"
        },
        {
          "name": "CustomerPriority__c"
        },
        {
          "name": "Description"
        },
        {
          "name": "DunsNumber"
        },
        {
          "name": "Id"
        },
        {
          "name": "Industry"
        },
        {
          "name": "MasterRecordId"
        },
        {
          "name": "NaicsDesc"
        },
        {
          "name": "NaicsCode"
        },
        {
          "name": "Name"
        },
        {
          "name": "NumberOfEmployees"
        },
        {
          "name": "NumberofLocations__c"
        },
        {
          "name": "Ownership"
        },
        {
          "name": "OwnerId"
        },
        {
          "name": "ParentId"
        },
        {
          "name": "Phone"
        },
        {
          "name": "Segment__c"
        },
        {
          "name": "ShippingCity"
        },
        {
          "name": "ShippingCountry"
        },
        {
          "name": "ShippingLatitude"
        },
        {
          "name": "ShippingLongitude"
        },
        {
          "name": "ShippingState"
        },
        {
          "name": "ShippingStreet"
        },
        {
          "name": "ShippingPostalCode"
        },
        {
          "name": "Sic"
        },
        {
          "name": "SLAExpirationDate__c"
        },
        {
          "name": "SLA__c"
        },
        {
          "name": "SLASerialNumber__c"
        },
        {
          "name": "Type"
        },
        {
          "name": "UpsellOpportunity__c"
        }
      ],
      "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": {
      "left": "Load Account",
      "right": "Load Agency Detail",
      "relationship": "AgencyDetail",
      "operation": "LookupSingleValue",
      "left_key": [
        "AccountNumber"
      ],
      "right_key": [
        "AccountNumber"
      ],
      "right_select": [
        "SubRegion",
        "Region",
        "Latitude",
        "Longitude",
        "Currency",
        "Acres",
        "AccountNumber"
      ]
    }
  },
  "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",
          "label": "IsAgency",
          "type": "Text"
        }
      ]
    }
  }
}

Please find the lens created as well.


User-added image

Please share your thoughts.
GunwantGunwant
Hi Ashish,

Click on down arrow of Bar length and then sort it by ascending order. Click apply. You would see 3 accounts with 5 count and 2 accounts with 4 counts. 
Go to filter then select Account Name and select all account names and apply.
Please select this as best answer if it helps you to pass the challenge.
Top 5 Agencies:
Top 5 agenciesUser-added image
 
GunwantGunwant
User-added imageHi Lin,

I am stuck at challenge#7. I am getting correct data same as you have shown in your lens. but still getting below error.
 Could you help here to pass this challenge?
Challenge Not yet complete... here's what's wrong: 
Couldn’t find the correct values. Please check your work.

User-added image

thanks
Gunwant
Olivier CATHERINE 6Olivier CATHERINE 6
Hi Gunwant,
Maybe the issue comes from your "filter 2015". Could you please try with this syntax : Date_Year:EQ:2015.
Regards,
Olivier
 
LinThawLinThaw
case when Phone is not null then "TRUE" else "FALSE" end
here you go!
LinThawLinThaw
Hi Kate,
We already have saql expression in this long post.
you can find it in json in this post.
please create new dataflow with these json and get you need.
Regards,
LinThaw
Sharath kumar SFDCSharath kumar SFDC
Hi LinThaw,

I am getting below error could you. Please guide me. 

User-added image


My Jason

{
  "Add Temp Class": {
    "action": "computeExpression",
    "parameters": {
      "source": "Filter 2015",
      "mergeWithSource": true,
      "computedFields": [
        {
          "defaultValue": "Continental",
          "name": "TempClass",
          "saqlExpression": "case when Temperature < 25 then \"Polar\" when Temperature >= 25 and Temperature <= 50 then \"Cool\" when Temperature >= 51 and Temperature <= 85 then \"Continental\" when Temperature > 85 then \"Tropical\" end",
          "label": "TempClass",
          "type": "Text"
        }
      ]
    }
  },
  "Load Seed Orders": {
    "action": "edgemart",
    "parameters": {
      "alias": "Seed_Bank_Orders"
    }
  },
  "Create Order History": {
    "action": "sfdcRegister",
    "parameters": {
      "name": "Order History",
      "alias": "order_history",
      "source": "Add Seed Orders"
    }
  },
  "Augment Temp Class": {
    "action": "augment",
    "parameters": {
      "right_key": [
        "Country"
      ],
      "left": "Load Account",
      "left_key": [
        "ShippingCountry"
      ],
      "right_select": [
        "TempClass",
        "Country",
        "Date",
        "Temperature"
      ],
      "right": "Add Temp Class",
      "relationship": "Climate",
      "operation": "LookupSingleValue"
    }
  },
  "Load Climate": {
    "action": "edgemart",
    "parameters": {
      "alias": "Global_Climates"
    }
  },
  "Add Seed Orders": {
    "action": "augment",
    "parameters": {
      "right_key": [
        "Climate.AccountNumber"
      ],
      "left": "Load Seed Orders",
      "left_key": [
        "Agency_ID"
      ],
      "right_select": [
        "Name",
        "Phone"
      ],
      "right": "Filter Agency Records",
      "relationship": "Agency",
      "operation": "LookupSingleValue"
    }
  },
  "Filter 2015": {
    "action": "filter",
    "parameters": {
      "filter": "Date_Year:R:2015",
      "source": "Load Climate"
    }
  },
  "ID Agency Records": {
    "action": "computeExpression",
    "parameters": {
      "source": "Add Agency Detail Fields",
      "mergeWithSource": true,
      "computedFields": [
        {
          "name": "IsAgency",
          "saqlExpression": "case when Phone is not null then \"TRUE\" else \"FALSE\" end",
          "label": "IsAgency",
          "type": "Text"
        }
      ]
    }
  },
  "Add Agency Detail Fields": {
    "action": "augment",
    "parameters": {
      "right_key": [
        "AccountNumber"
      ],
      "left": "Load Account",
      "left_key": [
        "AccountNumber"
      ],
      "right_select": [
        "AccountNumber",
        "Acres",
        "Currency",
        "Latitude",
        "Longitude",
        "Region",
        "SubRegion"
      ],
      "right": "Load Agency",
      "relationship": "AgencyDetail",
      "operation": "LookupSingleValue"
    }
  },
  "Load Agency": {
    "action": "edgemart",
    "parameters": {
      "alias": "Agency_Detail"
    }
  },
  "Filter Agency Records": {
    "action": "filter",
    "parameters": {
      "filter": "Climate.IsAgency:EQ:TRUE",
      "source": "Add Agency Fields"
    }
  },
  "Load Account": {
    "action": "sfdcDigest",
    "parameters": {
      "fields": [
        {
          "name": "AccountNumber"
        },
        {
          "name": "Name"
        },
        {
          "name": "Phone"
        },
        {
          "name": "ShippingCity"
        },
        {
          "name": "ShippingCountry"
        },
        {
          "name": "ShippingPostalCode"
        },
        {
          "name": "ShippingState"
        },
        {
          "name": "ShippingStreet"
        }
      ],
      "object": "Account"
    }
  },
  "Add Agency Fields": {
    "action": "augment",
    "parameters": {
      "right_key": [
        "AccountNumber"
      ],
      "left": "Augment Temp Class",
      "left_key": [
        "AccountNumber"
      ],
      "right_select": [
        "AccountNumber",
        "IsAgency",
        "Name",
        "Phone",
        "ShippingCity",
        "ShippingCountry",
        "ShippingPostalCode",
        "ShippingState",
        "ShippingStreet",
        "AgencyDetail.Currency",
        "AgencyDetail.Region",
        "AgencyDetail.SubRegion",
        "AgencyDetail.AccountNumber",
        "AgencyDetail.Latitude",
        "AgencyDetail.Acres",
        "AgencyDetail.Longitude"
      ],
      "right": "ID Agency Records",
      "relationship": "Climate",
      "operation": "LookupSingleValue"
    }
  }
}


My Data Flow 

User-added image












 
LinThawLinThaw
Hi Sharath, please check your lens.
User-added image
Sharath kumar SFDCSharath kumar SFDC
Hi Lin,

Please check  my lens

.User-added image
 
Kumara Murali 42Kumara Murali 42
Kindly help!

I am stuck with Challenge 3:  
Here is My JSON:

{ "Load Account": { "action": "sfdcDigest", "parameters": { "fields": [ { "name": "AccountNumber" }, { "name": "Name" }, { "name": "Phone" }, { "name": "ShippingCity" }, { "name": "ShippingCountry" }, { "name": "ShippingPostalCode" }, { "name": "ShippingState" }, { "name": "ShippingStreet" } ], "object": "Account" } }, "Load Agency Detail": { "action": "edgemart", "parameters": { "alias": "Agency_Detail" } }, "Add Agency Fields": { "action": "augment", "parameters": { "operation": "LookupSingleValue", "left": "Load Account", "left_key": [ "AccountNumber" ], "relationship": "AgencyDetail", "right": "Load Agency Detail", "right_key": [ "AccountNumber" ], "right_select": [ "Acres", "Currency", "Latitude", "Longitude", "Region", "SubRegion" ] } }, "ID Agency Records": { "action": "computeExpression", "parameters": { "mergeWithSource": true, "source": "Add Agency Fields", "computedFields": [ { "name": "IsAgency", "label": "IsAgency", "type": "Text", "saqlExpression": "case when Phone is not null then \"TRUE\" else \"FALSE\" end" } ] } }, "Filter Agency Records": { "action": "filter", "parameters": { "filter": "IsAgency:EQ:TRUE", "source": "ID Agency Records" } }, "Create Seed Bank Agencies": { "action": "sfdcRegister", "parameters": { "alias": "seed_bank_agencies", "source": "Filter Agency Records", "name": "Seed Bank Agencies" } } }User-added imageUser-added image
LinThawLinThaw
Hi Kumara,
your flow is working well in my org.
please compare with my flow result
User-added image

Hi Sharath,
did you solve it?

Regards,
LinThaw
Sharath kumar SFDCSharath kumar SFDC
Hi Lin,
No I am still getting error
User-added imageUser-added imageUser-added image
Olivier GrisezOlivier Grisez
Hi, 

I follow LinThaw instructions for step 3 but I can complete challenge.

Error message : "Challenge Not yet complete... here's what's wrong: 
Couldn’t find the 'Load Agency Detail' node in the dataflow. Confirm the node name matches the name as described in the challenge."

Dataflow JSON : 
{
  "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": [
        "Acres",
        "Currency",
        "Latitude",
        "Longitude",
        "Region",
        "SubRegion"
      ],
      "right": "Load Agency Detail",
      "relationship": "AgencyDetail",
      "operation": "LookupSingleValue"
    }
  },
  "Load Agency Detail": {
    "action": "edgemart",
    "parameters": {
      "alias": "Dataset_Agency_Detail"
    }
  },
  "ID Agency Records": {
    "action": "computeExpression",
    "parameters": {
      "source": "Add Agency Fields",
      "mergeWithSource": true,
      "computedFields": [
        {
          "name": "IsAgency",
          "label": "IsAgency",
          "type": "Text",
          "saqlExpression": "case when Phone != \"\" then \"TRUE\" end",
          "defaultValue": "FALSE"
        }
      ]
    }
  }
}

Please help me =)

Sharath kumar SFDCSharath kumar SFDC
Hi 
LinThaw

Finally I have completed the module:)

Thanks a lot.User-added image
HiteshPHiteshP
Hi LinThaw &  Sharath kumar SFDC,

I'm facing the same issue at #7 

Challenge Not yet complete... here's what's wrong:
Couldn’t find the correct values. Please check your work.

User-added image

Pleasae advise 

Thanks,
Hitesh Patel
Sharath kumar SFDCSharath kumar SFDC
Hi Hitesh,
 Check your Jason with My or Lin Jason. If it Matches. Just refresh your trailhead module. Move your lens from  Private App to  Mosaic app.

Best of Luck.
Alex Miller 80Alex Miller 80
Is anyone having the issue of incorrect data and users being populated within the original Developer Edition org? In the instructions for the superbadge, it says that "Mosaics project team already exists as Salesforce users in the org." My org is populated with different users. I've tried downloading a new DE org (multiple times and with different information) and I still can't get the correct users. I've also treid altering the existing users to match the users from the superbadge instructions, but there don't seem to be enough useable liscences for that to work. Any suggestions would be helpful.
Yoanna DimitrovaYoanna Dimitrova
Hi Everyone,
I get the "The dataflow was completed, but the LookupSingleValue node didn't augment any columns. Either the node didn't find any matches, or a join key contains only null values." warning when I run the dataflow after I created the Add Agency Fields augment. Please take a look at the JSON file and advise what am I doing wrong...
Thanks so much in advance!
{
  "Load Account": {
    "action": "sfdcDigest",
    "parameters": {
      "fields": [
        {
          "name": "AccountNumber"
        },
        {
          "name": "Name"
        },
        {
          "name": "Phone"
        },
        {
          "name": "ShippingState"
        },
        {
          "name": "ShippingPostalCode"
        },
        {
          "name": "ShippingCountry"
        },
        {
          "name": "ShippingCity"
        },
        {
          "name": "ShippingStreet"
        }
      ],
      "object": "Account"
    }
  },
  "Add Agency Fields": {
    "action": "augment",
    "parameters": {
      "right_key": [
        "AccountNumber"
      ],
      "left": "Load Account",
      "left_key": [
        "AccountNumber"
      ],
      "right_select": [
        "Currency",
        "Region",
        "SubRegion",
        "Latitude",
        "Acres",
        "Longitude"
      ],
      "right": "Load Agency Detail",
      "relationship": "AgencyDetail",
      "operation": "LookupSingleValue"
    }
  },
  "Load Agency Detail": {
    "action": "edgemart",
    "parameters": {
      "alias": "Load_Agency_Detail"
    }
  }
}

 
LinThawLinThaw
hi Yoanna,

"alias": "Load_Agency_Detail" should be "alias": "Agency_Detail"

please try with these 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": "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": [
        "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": [
        {
          "name": "IsAgency",
          "saqlExpression": "case when Phone is not null then \"TRUE\" else \"FALSE\" end",
          "label": "IsAgency",
          "type": "Text"
        }
      ]
    }
  }
}

hi Alex,
Did you create an Einstein Analytics Developer Edition (DE) org for this challenge?
Yoanna DimitrovaYoanna Dimitrova
Hi LinThaw,
Many thanks! I noticed that it is not showing me Alias when I created it and now:

User-added image

Why do I see a different screen?
Yoanna DimitrovaYoanna Dimitrova
Hi again LinThaw,

I tried to removed the Load in the JSON file and got this error. I also tried your JSON but again the same error:

User-added image

This is because the Alias of my Load Agency Detail dataset is Load_Agency_Detail, not Agency_Detail but I cannot find where to change the alias:

User-added image
LinThawLinThaw
hi Yoanna,
In edgemart node, Dataset name means Alias.
when loading Agency Detail.txt please leave dataset name as default.
Good luck
Yoanna DimitrovaYoanna Dimitrova
Hi LinThaw,
Thanks a lot for your quick response! I did create the dataset again and I keep getting this warning. Please check the JSON of the dataflow now:
{
  "Load Account": {
    "action": "sfdcDigest",
    "parameters": {
      "fields": [
        {
          "name": "AccountNumber"
        },
        {
          "name": "Name"
        },
        {
          "name": "Phone"
        },
        {
          "name": "ShippingState"
        },
        {
          "name": "ShippingPostalCode"
        },
        {
          "name": "ShippingCountry"
        },
        {
          "name": "ShippingCity"
        },
        {
          "name": "ShippingStreet"
        }
      ],
      "object": "Account"
    }
  },
  "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"
    }
  }
}

Thanks!
Alex Miller 80Alex Miller 80
Hi LinThaw,

Yes, I did. It is loaded with different users than the ones used in the superbadge instructions. I have even tried creating a new one with a different email and still have the same issue.
Yoanna DimitrovaYoanna Dimitrova
Hi Alex Miller 80,
The users are not really in the org and you won't have to actually assign any Psets to them. The challange is a test what you they need to have.
LinThawLinThaw
hi Yoanna,

I didn't find following nodes in your json.
[ID Agency Records]
[Filter Agency Records]
[Create Seed Bank Agencies]
please try with my json I mentioned in above.

Regards,
LinThaw
Yoanna DimitrovaYoanna Dimitrova
Hi LinThaw,
I tried with yours but the warning remains. The issue is with the Load Agency Detail file that doesn't return any values:

User-added image

I tried deleting everything and creating it from scratch. I don't know what is wrong with this file. It seems fine when I open it.
LinThawLinThaw
hi Yoanna,

maybe OUTPUT ROWS of Load Account is not correct,
please check [Pre-work and Notes] section, imported Agency Data.txt correctly.
dataflow result is as follow.
User-added image
Regards,
LinThaw
Yoanna DimitrovaYoanna Dimitrova
Hi LinThaw,
I managed to pass this by creating a brand new org. I don't know why the Account records were not actually updated with the Account Data file although it was successfully uploaded.
Now my next stumble is the lens. When I click on the Seed Bank Agencies dataset and the new lens opens, it has no Vertical Axis field as I see you here see:

User-added imagePlease advise what I have to amend.

Thanks in advance!
LinThawLinThaw
hi Yoanna,

please run this query in Developer Console,
Select Name, Phone From Account Where Phone <> ''

and check data is loaded correctly.
User-added image
Regards,
LinThaw
 
Yoanna DimitrovaYoanna Dimitrova
Hi LinThaw,
I ran the query and got 383 results.
User-added image

 
Yoanna DimitrovaYoanna Dimitrova
P.S. The number of accounts in the Agency Detail file is exactly 383. I am not sure how you get 384 out of it.
LinThawLinThaw
hi Yoanna, 383 is correct, extra one is my test account not concern with challenge.
LinThawLinThaw
please check join key [AccountNumber].
Agency Detail Dataset
User-added image
Target Records on Account obj
User-added image
MENDELSOHN CHANMENDELSOHN CHAN
Hi Everyone, 

I am currently on question 6 of the data prep superbadge - my dataflow was successful but had a warning that said this: 

WARNING: "The dataflow was completed, but the LookupSingleValue node didn't augment any columns. Either the node didn't find any matches, or a join key contains only null values." 

In my Seed Bank Temp Class lens, my viz resulted in only one temperature category; 

Temp Class

Something might have gone wrong with my join / augment node? 

Thanks in advance! 
 
LinThawLinThaw
hi Chan and Yoanna,

your errors are same.

please try with following steps.

1. Select Setup >> Account
User-added image
2. Check required fields are selected and click Continue
User-added image
3. Check Phone and AccountNumber are imported correctly then Save
 User-added image

Finally, please rerun your dataflow, then warning will clear. Goodluck!

Regards,
LinThaw
MENDELSOHN CHANMENDELSOHN CHAN
Solved it! It's so annoying, the highlight bars function to select Focus mode is prone to error. Thanks again LinThaw for all your help! 
Jayachandra RJayachandra R
hi LinThaw,
I'm facing this error even though my flow is working fine, can you please check and help me out
Challenge Not yet complete... here's what's wrong: 
Couldn’t find the 'Create Seed Bank Agencies' node or required fields are missing. Check the challenge and confirm the node name, alias, and required fields.
 
{
  "Add Agency Details": {
    "action": "augment",
    "parameters": {
      "right_key": [
        "AccountNumber"
      ],
      "left": "Filter Agency Records",
      "left_key": [
        "AccountNumber"
      ],
      "right_select": [
        "Currency",
        "Acres",
        "SubRegion",
        "Region",
        "Latitude",
        "Longitude"
      ],
      "right": "Load Agency Details",
      "relationship": "AgencyDetail",
      "operation": "LookupSingleValue"
    }
  },
  "Add Temp Class": {
    "action": "computeExpression",
    "parameters": {
      "source": "Filter 2015",
      "mergeWithSource": true,
      "computedFields": [
        {
          "defaultValue": "Continental",
          "name": "TempClass",
          "saqlExpression": "case \nwhen Temperature < 25 then \"Polar\" \nwhen Temperature >= 25 and Temperature <= 50 then \"Cool\" \nwhen Temperature >= 51 and Temperature <= 85 then \"Continental\" \nwhen Temperature > 85 then \"Tropical\" \nend",
          "label": "TempClass",
          "type": "Text"
        }
      ]
    }
  },
  "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": "ShippingStreet"
        },
        {
          "name": "ShippingState"
        }
      ],
      "object": "Account"
    }
  },
  "Load Agency Details": {
    "action": "edgemart",
    "parameters": {
      "alias": "Agency_Detail"
    }
  },
  "Create Seed Bank Agencies": {
    "action": "sfdcRegister",
    "parameters": {
      "name": "Seed Bank Agencies",
      "alias": "Seed_Bank_Agencies",
      "source": "Augment TempClass"
    }
  },
  "Load Climate": {
    "action": "edgemart",
    "parameters": {
      "alias": "Global_Climates"
    }
  },
  "Filter 2015": {
    "action": "filter",
    "parameters": {
      "filter": "Date_Year:EQ:2015",
      "source": "Load Climate"
    }
  },
  "Augment TempClass": {
    "action": "augment",
    "parameters": {
      "right_key": [
        "Country"
      ],
      "left": "Add Agency Details",
      "left_key": [
        "ShippingCountry"
      ],
      "right_select": [
        "Country",
        "Date",
        "TempClass",
        "Temperature"
      ],
      "right": "Add Temp Class",
      "relationship": "Climate",
      "operation": "LookupSingleValue"
    }
  },
  "ID Agency Records": {
    "action": "computeExpression",
    "parameters": {
      "source": "Load Account",
      "mergeWithSource": true,
      "computedFields": [
        {
          "name": "IsAgency",
          "saqlExpression": "case when Phone is not null then \"TRUE\" else \"FALSE\" end",
          "label": "IsAgency",
          "type": "Text"
        }
      ]
    }
  }
}
 
{
  "Add Temp Class": {
    "action": "computeExpression",
    "parameters": {
      "source": "Define Temp Range",
      "mergeWithSource": true,
      "computedFields": [
        {
          "defaultValue": "Continental",
          "name": "TempKey",
          "saqlExpression": "case \nwhen lowTemp < 25 and highTemp < 25 then \"Polar\" \nwhen lowTemp >= 25 and lowTemp <= 50 and highTemp >= 25 and highTemp <= 50 then \"Cool\"\nwhen lowTemp >= 51 and lowTemp <= 85 and highTemp >= 51 and highTemp <= 85 then \"Continental\"\nwhen lowTemp > 85 and highTemp > 85 then \"Tropical\"\nwhen lowTemp < 25 and (highTemp >= 25 and highTemp <= 50) then \"Polar-Cool\" \nwhen lowTemp < 25 and (highTemp >= 25 and highTemp <= 85) then \"Polar-Cool-Continental\" \nwhen lowTemp < 25 and highTemp > 85 then \"Polar-Cool-Continental-Tropical\" \nwhen (lowTemp >= 25 and lowTemp <= 50) and (highTemp >= 51 and highTemp <= 85) then \"Cool-Continental\" \nwhen (lowTemp >= 25 and lowTemp <= 50) and highTemp >= 85 then \"Cool-Continental-Tropical\" \nwhen (lowTemp >= 51 and lowTemp <= 85) and highTemp > 85 then \"Continental-Tropical\" \nend",
          "label": "TempKey",
          "type": "Text"
        }
      ]
    }
  },
  "Calculate Acreage": {
    "action": "computeExpression",
    "parameters": {
      "source": "Load Seed Chart",
      "mergeWithSource": true,
      "computedFields": [
        {
          "precision": 18,
          "name": "Acreage",
          "saqlExpression": "(Seeds_Pound*Spacing)/6272640",
          "scale": 6,
          "label": "Acreage",
          "type": "Numeric"
        }
      ]
    }
  },
  "Create Seed Bank": {
    "action": "sfdcRegister",
    "parameters": {
      "name": "Seed Bank",
      "alias": "Seed_Bank",
      "source": "CleanUp"
    }
  },
  "Load Seed Chart": {
    "action": "edgemart",
    "parameters": {
      "alias": "Seed_Chart"
    }
  },
  "Augment Temp Class": {
    "action": "augment",
    "parameters": {
      "right_key": [
        "TempKey"
      ],
      "left": "Add Temp Class",
      "left_key": [
        "TempKey"
      ],
      "right_select": [
        "TempClass",
        "TempKey"
      ],
      "right": "Load Temp Class Mapping",
      "relationship": "Climate",
      "operation": "LookupMultiValue"
    }
  },
  "Load Temp Class Mapping": {
    "action": "edgemart",
    "parameters": {
      "alias": "Temperature_Classes_Mapping"
    }
  },
  "CleanUp": {
    "action": "sliceDataset",
    "parameters": {
      "mode": "drop",
      "source": "Augment Temp Class",
      "fields": [
        {
          "name": "Climate.TempKey"
        },
        {
          "name": "highTemp"
        },
        {
          "name": "lowTemp"
        },
        {
          "name": "TempKey"
        }
      ]
    }
  },
  "Define Temp Range": {
    "action": "computeExpression",
    "parameters": {
      "source": "Calculate Acreage",
      "mergeWithSource": true,
      "computedFields": [
        {
          "precision": 3,
          "name": "lowTemp",
          "saqlExpression": "string_to_number(substr(Temperature, 1, 2))",
          "scale": 1,
          "label": "lowTemp",
          "type": "Numeric"
        },
        {
          "precision": 3,
          "name": "highTemp",
          "saqlExpression": "string_to_number(substr(Temperature, 4, 2))",
          "scale": 1,
          "label": "highTemp",
          "type": "Numeric"
        }
      ]
    }
  }
}

 
Thomas IvyThomas Ivy
Hi LinThaw;   Thank you so much for all the advice you have given on Challange #3.  That was super hard.   

Does anyone know of a Trailhead or tutorial that shows how to create computeExpressions and filters?   That was the hardest thing and I didn't see any mention of them on that other badges to open the challenge.  I do see information in Salesforce help, but it's highly technical and doesn't show examples using the Data Manager.  
LinThawLinThaw
hi Thomas Ivy,
please find in following pdf.
<computeExpression Transformation>

hi Jayachandra,
your components in json are too many.
please refer following json.

json for Load Seed Bank
{
  "Calculate Acreage": {
    "action": "computeExpression",
    "parameters": {
      "source": "Load Seed Chart",
      "mergeWithSource": true,
      "computedFields": [
        {
          "defaultValue": "0",
          "precision": 18,
          "name": "Acreage",
          "saqlExpression": "(Seeds_Pound*Spacing)/6272640",
          "scale": 6,
          "label": "Acreage",
          "type": "Numeric"
        }
      ]
    }
  },
  "Create Seed Bank": {
    "action": "sfdcRegister",
    "parameters": {
      "name": "Seed Bank",
      "alias": "seed_bank",
      "source": "Calculate Acreage"
    }
  },
  "Load Seed Chart": {
    "action": "edgemart",
    "parameters": {
      "alias": "Seed_Chart"
    }
  }
}

json for Load Seed Bank Agencies
{
  "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": [
        "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": [
        {
          "name": "IsAgency",
          "saqlExpression": "case when Phone is not null then \"TRUE\" else \"FALSE\" end",
          "label": "IsAgency",
          "type": "Text"
        }
      ]
    }
  }
}

and also please take care for Alias naming for all remaining challenges,
seed_bank_agencies <-- OK
seed_bank <-- OK
Seed_Bank_Agencies <-- NG
Seed_Bank <-- NG

Regards,
LinThaw
LinThawLinThaw
sorry, forgot to add link.
<computeExpression Transformation>
https://resources.docs.salesforce.com/sfdc/pdf/bi_admin_guide_data_integration_guide.pdf
Thomas IvyThomas Ivy
Thanks again LinThaw;
I'll read over this.    It looked like it will benefit not only this Superbadge by my overall use of Analytics.
 
Tereasa WilkinsonTereasa Wilkinson
Hi 

I am stuck on section 3 

I had initially been confused and built a custom field into the setup, Build , Customize , Accounts , Fields  and then created a custom IsAgency field in there  - and proceded to follow the steps associated with the badge and managed to get a successful dataflow but then error message when checking the challenge - i tried everthing to resolve the error messages which brought me to this page - i deleted everything i did previously including the IsAgency custom field and started again 

But now Analytics will not let me create the Load Account Dataset for some reason and it keeps bringing up this error message 

Replication dataflow for object 'Account'.

Status:
Failed

Reason for Failure:
Something went wrong while executing the Replication_Account node: Fields [IsAgency_c__c, IsAgency__c, IsAgency_del__c] are not available. Verify that the fields exists and that the Analytics Cloud Integration User profile has Read level access on the fields. (02K1t000000LbbnEAC_03C1t000000hIaFEAU)

My Mosaic datasets remain without Load Account data as it keeps failing despite my JSON reading as below whic obvously makes the dataflow fail also.  

i have gone over the process so many times now and just keep getting the same error message - ANY Help would be much appreciated 

Many Thanks 

Tereasa 

my JSON reads as below 
{
  "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": "ShippingCountry"
        },
        {
          "name": "ShippingPostalCode"
        },
        {
          "name": "ShippingState"
        },
        {
          "name": "ShippingStreet"
        },
        {
          "name": "ShippingCity"
        }
      ],
      "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": [
        "AccountNumber",
        "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": [
        {
          "name": "IsAgency",
          "saqlExpression": "\"case when Phone is not null then \\\"TRUE\\\" else \\\"FALSE\\\" end\"",
          "label": "IsAgency",
          "type": "Text"
        }
      ]
    }
  }
}

 
LinThawLinThaw
hi Tereasa Wilkinson

please check Account dataset and save again.
if you used custom fields [IsAgency__c] in filter, clear it.
User-added image
User-added image
User-added image
good luck

Regards,
LinThaw
Mark Tossell 4Mark Tossell 4
I cannot pass challenge 3 on the Einstein Analytics Superbadge, even though my answer matches the correct answer of a colleague who passed.  
Error
LinThawLinThaw
hi Mark Tossell, let me check your json.
Mark Tossell 4Mark Tossell 4
Thanks, Lin. 

{
  "Filter Agency Records": {
    "action": "filter",
    "parameters": {
      "filter": "IsAgency:EQ:Yes",
      "source": "ID Agency Records"
    }
  },
  "Load Account": {
    "action": "sfdcDigest",
    "parameters": {
      "fields": [
        {
          "name": "AccountNumber"
        },
        {
          "name": "Name"
        },
        {
          "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": "Add Agency Fields"
    }
  },
  "Add Agency Fields": {
    "action": "augment",
    "parameters": {
      "right_key": [
        "AccountNumber"
      ],
      "left": "Filter Agency Records",
      "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_Detail"
    }
  },
  "ID Agency Records": {
    "action": "computeExpression",
    "parameters": {
      "source": "Load Account",
      "mergeWithSource": true,
      "computedFields": [
        {
          "name": "IsAgency",
          "saqlExpression": "case when 'Phone' is null then \"No\" else \"Yes\" end",
          "label": "IsAgency",
          "type": "Text"
        }
      ]
    }
  }
}
LinThawLinThaw
Hi Mark,
please try with this one.
{
  "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": [
        "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": [
        {
          "name": "IsAgency",
          "saqlExpression": "case when Phone is not null then \"TRUE\" else \"FALSE\" end",
          "label": "IsAgency",
          "type": "Text"
        }
      ]
    }
  }
}

maybe solve.
Mark Tossell 4Mark Tossell 4
Still not working even after deleting the dataflow, dataset and lens, then recreating. What a waste of time!
LinThawLinThaw
Hi Mark,
how about this solution?
User-added image
good luck
Regards,
LinThaw
Mark Tossell 4Mark Tossell 4
AWESOME! It worked. THANKS! 
Tereasa WilkinsonTereasa Wilkinson
Hi All 

The Isagency fields were sitting in the My First Analytics App Account Dataset - i deleted the fields from here - as suggested by Lin and started again. 

This time i have managed to get Load Account dataset back successfully, all agency details are in and i created the create seed bank dataflow which status in monitor is saying is running successfully but when i go back to the Mosaic App to the seed bank agencies dataset and click in here to build the top 5 the bar chart says  - No results found  .... 

Any Ideas ? 

Apologies 

Tereasa  
Marissa Geller 9Marissa Geller 9
Thank you so much @LinThaw and @Justin Baidoo - I also updated the Latitude/Longitude fields.  I thought I would go crazy.  Challenge 3 finally completed.
Thomas IvyThomas Ivy
@LinThaw, @Jennifer W. Lee, @Mathieu Noblet, @Priyanka Vaidya 29, @Michele Losch 4

I have a quick question for those who seem to have passed step 6.  It's about the "Define Temp Range" requirement.  Because maybe I'm over thinking something.   For example, the Global Climates sheet has 12 Temperatures in 2015 for Afghanistan.  Do I need to set Analytics to search through all 12 and identify which one is the high and low temperature?   Then based on that we assign a Temp Class for Afghanistan?   

This is what I think should be done.  However, when I look through this post and Google search I can't figure out how to Search all the rows for a region and identify the high or low value.  If this were a flow I would establish a loop that checks each value and saved the highest and lowest temp. But I don't see where anyone did anything like this.    Can someone give me some direction on this?
LinThawLinThaw
Hi Tereasa,

please run Account dataset again and your dataflow.
and try to create lens.
run results are look like below.
User-added image
User-added image
Regards,
LinThaw
LinThawLinThaw
Hi Thomas,

[Define Temp Range] node is a part of [Load Seed Bank w/Temperature Classification] dataflow.
Temperature that is used in calculation for new fields lowTemp and highTemp is come from Seed Chart NOT from Global Climates.

Reegards,
LinThaw
Thomas IvyThomas Ivy
Thank you again LinThaw; I don't know how I missed that, but that oversight cost me a lot of time. Next time I'll re-read carefully when I'm lost on future challenges. Thanks to you I passed step 6!! Almost done!
Tereasa WilkinsonTereasa Wilkinson
Thank you LinThaw for your patience and replies but now it just brings up yet another error message  .. i think maybe i should completely delete and recreate again 

current error message is " Couldn't find Account Name Filter"  plus i dont see the "Setup" section in data manager that is in your image above - mine shows "connect" instead

when i look at the Account object fields for selection it shows "Name" ... but not Account Name as the field for selection  ... which is the one i have picked  .... 

once again any help would be much appreciated  - 

Best Regards 

Tereasa 




 
LinThawLinThaw
hi Tereasa 

some names are changed in winter19. 
my images in previous post are from previous version.

please confirm [Enable Data Sync and Connections] is enabled
and take a look [Replication is Now Called Data Sync] section in following pdf.
https://resources.docs.salesforce.com/216/latest/en-us/sfdc/pdf/salesforce_winter19_release_notes.pdf

Regards,
LinThaw
Ramon DelSaltoRamon DelSalto
Hi All, i need a bit of help on step 6 i'm getteing the follwoing error.
"Challenge Not yet complete... here's what's wrong:
Couldn’t find the 'Create Seed Bank Agencies' node or required fields are missing. Check the challenge and confirm the node name and required fields."

'Load Seed Bank Agencies w/Climate Data'

{
  "Add Temp Class": {
    "action": "computeExpression",
    "parameters": {
      "source": "Define Temp Range",
      "mergeWithSource": true,
      "computedFields": [
        {
          "name": "TempClass",
          "saqlExpression": "case \nwhen lowTemp < 25 and highTemp < 25 then \"Polar\" \nwhen lowTemp >= 25 and lowTemp <= 50 and highTemp >= 25 and highTemp <= 50 then \"Cool\"\nwhen lowTemp >= 51 and lowTemp <= 85 and highTemp >= 51 and highTemp <= 85 then \"Continental\"\nwhen lowTemp > 85 and highTemp > 85 then \"Tropical\"\nwhen lowTemp < 25 and (highTemp >= 25 and highTemp <= 50) then \"Polar-Cool\" \nwhen lowTemp < 25 and (highTemp >= 25 and highTemp <= 85) then \"Polar-Cool-Continental\" \nwhen lowTemp < 25 and highTemp > 85 then \"Polar-Cool-Continental-Tropical\" \nwhen (lowTemp >= 25 and lowTemp <= 50) and (highTemp >= 51 and highTemp <= 85) then \"Cool-Continental\" \nwhen (lowTemp >= 25 and lowTemp <= 50) and highTemp >= 85 then \"Cool-Continental-Tropical\" \nwhen (lowTemp >= 51 and lowTemp <= 85) and highTemp > 85 then \"Continental-Tropical\" \nend",
          "label": "TempClass",
          "type": "Text"
        }
      ]
    }
  },
  "Calculate Acreage": {
    "action": "computeExpression",
    "parameters": {
      "source": "Load Seed Chart",
      "mergeWithSource": true,
      "computedFields": [
        {
          "defaultValue": "0",
          "precision": 18,
          "name": "Acreage",
          "saqlExpression": "(Seeds_Pound*Spacing)/6272640",
          "scale": 6,
          "label": "Acreage",
          "type": "Numeric"
        }
      ]
    }
  },
  "Create Seed Bank": {
    "action": "sfdcRegister",
    "parameters": {
      "name": "Seed Bank",
      "alias": "seed_bank",
      "source": "CleanUp"
    }
  },
  "Load Seed Chart": {
    "action": "edgemart",
    "parameters": {
      "alias": "Seed_Chart"
    }
  },
  "Augment Temp Class": {
    "action": "augment",
    "parameters": {
      "right_key": [
        "TempClass"
      ],
      "left": "Load Temp Class Mapping",
      "left_key": [
        "TempKey"
      ],
      "right_select": [
        "Acreage",
        "highTemp",
        "Lifecycle",
        "lowTemp",
        "Quantity_Pounds",
        "Seed",
        "Seeds_Pound",
        "Seed_ID",
        "Seed_Type",
        "Spacing",
        "TempClass",
        "Temperature"
      ],
      "right": "Add Temp Class",
      "relationship": "Climate",
      "operation": "LookupSingleValue"
    }
  },
  "Load Temp Class Mapping": {
    "action": "edgemart",
    "parameters": {
      "alias": "Temperature_Classes_Mapping"
    }
  },
  "CleanUp": {
    "action": "sliceDataset",
    "parameters": {
      "mode": "drop",
      "source": "Augment Temp Class",
      "fields": [
        {
          "name": "TempClass"
        },
        {
          "name": "TempKey"
        },
        {
          "name": "Climate.highTemp"
        },
        {
          "name": "Climate.lowTemp"
        }
      ]
    }
  },
  "Define Temp Range": {
    "action": "computeExpression",
    "parameters": {
      "source": "Calculate Acreage",
      "mergeWithSource": true,
      "computedFields": [
        {
          "defaultValue": "0",
          "precision": 18,
          "name": "lowTemp",
          "saqlExpression": "string_to_number( substr(Temperature, 1, 2))",
          "scale": 2,
          "label": "lowTemp",
          "type": "Numeric"
        },
        {
          "defaultValue": "0",
          "precision": 18,
          "name": "highTemp",
          "saqlExpression": "string_to_number(substr(Temperature, -2, 2))",
          "scale": 2,
          "label": "highTemp",
          "type": "Numeric"
        }
      ]
    }
  }
}



and here is the Load Seed Bank w/Temperature Classification



{
  "Add Temp Class": {
    "action": "computeExpression",
    "parameters": {
      "source": "Define Temp Range",
      "mergeWithSource": true,
      "computedFields": [
        {
          "name": "TempClass",
          "saqlExpression": "case \nwhen lowTemp < 25 and highTemp < 25 then \"Polar\" \nwhen lowTemp >= 25 and lowTemp <= 50 and highTemp >= 25 and highTemp <= 50 then \"Cool\"\nwhen lowTemp >= 51 and lowTemp <= 85 and highTemp >= 51 and highTemp <= 85 then \"Continental\"\nwhen lowTemp > 85 and highTemp > 85 then \"Tropical\"\nwhen lowTemp < 25 and (highTemp >= 25 and highTemp <= 50) then \"Polar-Cool\" \nwhen lowTemp < 25 and (highTemp >= 25 and highTemp <= 85) then \"Polar-Cool-Continental\" \nwhen lowTemp < 25 and highTemp > 85 then \"Polar-Cool-Continental-Tropical\" \nwhen (lowTemp >= 25 and lowTemp <= 50) and (highTemp >= 51 and highTemp <= 85) then \"Cool-Continental\" \nwhen (lowTemp >= 25 and lowTemp <= 50) and highTemp >= 85 then \"Cool-Continental-Tropical\" \nwhen (lowTemp >= 51 and lowTemp <= 85) and highTemp > 85 then \"Continental-Tropical\" \nend",
          "label": "TempClass",
          "type": "Text"
        }
      ]
    }
  },
  "Calculate Acreage": {
    "action": "computeExpression",
    "parameters": {
      "source": "Load Seed Chart",
      "mergeWithSource": true,
      "computedFields": [
        {
          "defaultValue": "0",
          "precision": 18,
          "name": "Acreage",
          "saqlExpression": "(Seeds_Pound*Spacing)/6272640",
          "scale": 6,
          "label": "Acreage",
          "type": "Numeric"
        }
      ]
    }
  },
  "Create Seed Bank": {
    "action": "sfdcRegister",
    "parameters": {
      "name": "Seed Bank",
      "alias": "seed_bank",
      "source": "CleanUp"
    }
  },
  "Load Seed Chart": {
    "action": "edgemart",
    "parameters": {
      "alias": "Seed_Chart"
    }
  },
  "Augment Temp Class": {
    "action": "augment",
    "parameters": {
      "right_key": [
        "TempClass"
      ],
      "left": "Load Temp Class Mapping",
      "left_key": [
        "TempKey"
      ],
      "right_select": [
        "Acreage",
        "highTemp",
        "Lifecycle",
        "lowTemp",
        "Quantity_Pounds",
        "Seed",
        "Seeds_Pound",
        "Seed_ID",
        "Seed_Type",
        "Spacing",
        "TempClass",
        "Temperature"
      ],
      "right": "Add Temp Class",
      "relationship": "Climate",
      "operation": "LookupSingleValue"
    }
  },
  "Load Temp Class Mapping": {
    "action": "edgemart",
    "parameters": {
      "alias": "Temperature_Classes_Mapping"
    }
  },
  "CleanUp": {
    "action": "sliceDataset",
    "parameters": {
      "mode": "drop",
      "source": "Augment Temp Class",
      "fields": [
        {
          "name": "TempClass"
        },
        {
          "name": "TempKey"
        },
        {
          "name": "Climate.highTemp"
        },
        {
          "name": "Climate.lowTemp"
        }
      ]
    }
  },
  "Define Temp Range": {
    "action": "computeExpression",
    "parameters": {
      "source": "Calculate Acreage",
      "mergeWithSource": true,
      "computedFields": [
        {
          "defaultValue": "0",
          "precision": 18,
          "name": "lowTemp",
          "saqlExpression": "string_to_number( substr(Temperature, 1, 2))",
          "scale": 2,
          "label": "lowTemp",
          "type": "Numeric"
        },
        {
          "defaultValue": "0",
          "precision": 18,
          "name": "highTemp",
          "saqlExpression": "string_to_number(substr(Temperature, -2, 2))",
          "scale": 2,
          "label": "highTemp",
          "type": "Numeric"
        }
      ]
    }
  }
}
LinThawLinThaw
you are uploading same json for two flows.
Ramon DelSaltoRamon DelSalto
Thanks Lin for the help. now i'm getting stuck on challenge 7. the error message reads "Looks like something went wrong, please try again later."

here is the JSON

{
  "Add Temp Class": {
    "action": "computeExpression",
    "parameters": {
      "source": "Filter 2015",
      "mergeWithSource": true,
      "computedFields": [
        {
          "defaultValue": "Continental",
          "name": "TempClass",
          "saqlExpression": "case when Temperature < 25 then \"Polar\" when Temperature >= 25 and Temperature <= 50 then \"Cool\" when Temperature >= 51 and Temperature <= 85 then \"Continental\" when Temperature > 85 then \"Tropical\" end",
          "label": "TempClass",
          "type": "Text"
        }
      ]
    }
  },
  "Load Seed Orders": {
    "action": "edgemart",
    "parameters": {
      "alias": "seed_bank_agencies"
    }
  },
  "Create Order History": {
    "action": "sfdcRegister",
    "parameters": {
      "name": "Order History",
      "alias": "order_history",
      "source": "Add Seed Orders"
    }
  },
  "Augment Temp Class": {
    "action": "augment",
    "parameters": {
      "right_key": [
        "Country"
      ],
      "left": "Load Account",
      "left_key": [
        "ShippingCountry"
      ],
      "right_select": [
        "TempClass",
        "Country",
        "Date",
        "Temperature"
      ],
      "right": "Add Temp Class",
      "relationship": "Climate",
      "operation": "LookupSingleValue"
    }
  },
  "Load Climate": {
    "action": "edgemart",
    "parameters": {
      "alias": "Global_Climates"
    }
  },
  "Add Seed Orders": {
    "action": "augment",
    "parameters": {
      "right_key": [
        "AccountNumber"
      ],
      "left": "Order",
      "right_select": [
        "Name",
        "Phone"
      ],
      "right": "Filter Agency Records",
      "relationship": "Agency",
      "operation": "LookupSingleValue"
    }
  },
  "Filter 2015": {
    "action": "filter",
    "parameters": {
      "filter": "Date_Year:R:2015",
      "source": "Load Climate"
    }
  },
  "ID Agency Records": {
    "action": "computeExpression",
    "parameters": {
      "source": "Add Agency Detail Fields",
      "mergeWithSource": true,
      "computedFields": [
        {
          "name": "IsAgency",
          "saqlExpression": "case when Phone is not null then \"TRUE\" else \"FALSE\" end",
          "label": "IsAgency",
          "type": "Text"
        }
      ]
    }
  },
  "Add Agency Detail Fields": {
    "action": "augment",
    "parameters": {
      "right_key": [
        "AccountNumber"
      ],
      "left": "Load Account",
      "left_key": [
        "AccountNumber"
      ],
      "right_select": [
        "AccountNumber",
        "Acres",
        "Currency",
        "Latitude",
        "Longitude",
        "Region",
        "SubRegion"
      ],
      "right": "Load Agency",
      "relationship": "AgencyDetail",
      "operation": "LookupSingleValue"
    }
  },
  "Load Agency": {
    "action": "edgemart",
    "parameters": {
      "alias": "Agency_Detail"
    }
  },
  "Filter Agency Records": {
    "action": "filter",
    "parameters": {
      "filter": "Climate.IsAgency:EQ:TRUE",
      "source": "Add Agency Fields"
    }
  },
  "Load Account": {
    "action": "sfdcDigest",
    "parameters": {
      "fields": [
        {
          "name": "AccountNumber"
        },
        {
          "name": "Name"
        },
        {
          "name": "Phone"
        },
        {
          "name": "ShippingCity"
        },
        {
          "name": "ShippingCountry"
        },
        {
          "name": "ShippingPostalCode"
        },
        {
          "name": "ShippingState"
        },
        {
          "name": "ShippingStreet"
        }
      ],
      "object": "Account"
    }
  },
  "Add Agency Fields": {
    "action": "augment",
    "parameters": {
      "right_key": [
        "AccountNumber"
      ],
      "left": "Augment Temp Class",
      "left_key": [
        "AccountNumber"
      ],
      "right_select": [
        "AccountNumber",
        "IsAgency",
        "Name",
        "Phone",
        "ShippingCity",
        "ShippingCountry",
        "ShippingPostalCode",
        "ShippingState",
        "ShippingStreet",
        "AgencyDetail.Currency",
        "AgencyDetail.Region",
        "AgencyDetail.SubRegion",
        "AgencyDetail.AccountNumber",
        "AgencyDetail.Latitude",
        "AgencyDetail.Acres",
        "AgencyDetail.Longitude"
      ],
      "right": "ID Agency Records",
      "relationship": "Climate",
      "operation": "LookupSingleValue"
    }
  }
}



Thanks,
Ramon
NehashriNehashri
Thank you all, It helped me a lot in completing my superbadge.
Paula BertoloPaula Bertolo
Hi Lin, I'm stuck on challeng #7.

Here is my jSON, my Lens and Results from datasets. Could you help me?
 
{
  "Add Temp Class": {
    "action": "computeExpression",
    "parameters": {
      "source": "Filter 2015",
      "mergeWithSource": true,
      "computedFields": [
        {
          "defaultValue": "Continental",
          "name": "TempClass",
          "saqlExpression": "case when Temperature < 25 then \"Polar\" when Temperature >= 25 and Temperature <= 50 then \"Cool\" when Temperature >= 51 and Temperature <= 85 then \"Continental\" when Temperature > 85 then \"Tropical\" end",
          "label": "TempClass",
          "type": "Text"
        }
      ]
    }
  },
  "Load Seed Orders": {
    "action": "edgemart",
    "parameters": {
      "alias": "Seed_Bank_Orders"
    }
  },
  "Create Order History": {
    "action": "sfdcRegister",
    "parameters": {
      "name": "Order History",
      "alias": "order_history",
      "source": "Add Seed Orders"
    }
  },
  "Augment Temp Class": {
    "action": "augment",
    "parameters": {
      "right_key": [
        "Country"
      ],
      "left": "Load Account",
      "left_key": [
        "ShippingCountry"
      ],
      "right_select": [
        "TempClass",
        "Country",
        "Date",
        "Temperature"
      ],
      "right": "Add Temp Class",
      "relationship": "Climate",
      "operation": "LookupSingleValue"
    }
  },
  "Load Climate": {
    "action": "edgemart",
    "parameters": {
      "alias": "Global_Climates"
    }
  },
  "Add Seed Orders": {
    "action": "augment",
    "parameters": {
      "right_key": [
        "AccountNumber"
      ],
      "left": "Load Seed Orders",
      "left_key": [
        "Agency_ID"
      ],
      "right_select": [
        "Name",
        "Phone"
      ],
      "right": "Filter Agency Records",
      "relationship": "Agency",
      "operation": "LookupSingleValue"
    }
  },
  "Filter 2015": {
    "action": "filter",
    "parameters": {
      "filter": "Date_Year:EQ:2015",
      "source": "Load Climate"
    }
  },
  "ID Agency Records": {
    "action": "computeExpression",
    "parameters": {
      "source": "Add Agency Detail Fields",
      "mergeWithSource": true,
      "computedFields": [
        {
          "name": "IsAgency",
          "saqlExpression": "case when Phone is not null then \"TRUE\" else \"FALSE\" end",
          "label": "IsAgency",
          "type": "Text"
        }
      ]
    }
  },
  "Add Agency Detail Fields": {
    "action": "augment",
    "parameters": {
      "right_key": [
        "AccountNumber"
      ],
      "left": "Load Account",
      "left_key": [
        "AccountNumber"
      ],
      "right_select": [
        "AccountNumber",
        "Acres",
        "Currency",
        "Latitude",
        "Longitude",
        "Region",
        "SubRegion"
      ],
      "right": "Load Agency",
      "relationship": "AgencyDetail",
      "operation": "LookupSingleValue"
    }
  },
  "Load Agency": {
    "action": "edgemart",
    "parameters": {
      "alias": "Agency_Detail"
    }
  },
  "Filter Agency Records": {
    "action": "filter",
    "parameters": {
      "filter": "Climate.IsAgency:EQ:TRUE",
      "source": "Add Agency Fields"
    }
  },
  "Load Account": {
    "action": "sfdcDigest",
    "parameters": {
      "fields": [
        {
          "name": "AccountNumber"
        },
        {
          "name": "Name"
        },
        {
          "name": "Phone"
        },
        {
          "name": "ShippingCity"
        },
        {
          "name": "ShippingCountry"
        },
        {
          "name": "ShippingPostalCode"
        },
        {
          "name": "ShippingState"
        },
        {
          "name": "ShippingStreet"
        }
      ],
      "object": "Account"
    }
  },
  "Add Agency Fields": {
    "action": "augment",
    "parameters": {
      "right_key": [
        "AccountNumber"
      ],
      "left": "Augment Temp Class",
      "left_key": [
        "AccountNumber"
      ],
      "right_select": [
        "AccountNumber",
        "IsAgency",
        "Name",
        "Phone",
        "ShippingCity",
        "ShippingCountry",
        "ShippingPostalCode",
        "ShippingState",
        "ShippingStreet",
        "AgencyDetail.Currency",
        "AgencyDetail.Region",
        "AgencyDetail.SubRegion",
        "AgencyDetail.AccountNumber",
        "AgencyDetail.Latitude",
        "AgencyDetail.Acres",
        "AgencyDetail.Longitude"
      ],
      "right": "ID Agency Records",
      "relationship": "Climate",
      "operation": "LookupSingleValue"
    }
  }
}

User-added imageUser-added image
LinThawLinThaw
Hi Paula Bertolo,

your json is fine.
please try to edit order of Seed ID as follow.
User-added image
Regards,
LinThaw
LinThawLinThaw
Hi Ramon,
your json is broken something.
please upload again.
Regards,
LinThaw
Neelima SakepallyNeelima Sakepally
Hi Everyone,

I am stuck at challenge #4. I am getting below error. Everything looks fine and i could not find what is missing to pass this challenge. Please help me.

User-added imageUser-added image
Neelima SakepallyNeelima Sakepally
Figured it out. It is because of Alias name. I changed it to seed_bank and challenge worked.
Varona RaposoVarona Raposo
Hi all, 

I'm getting stuck on challenge 7. I tried LinThaw's JSON and it seems we both get same results on the lense. Anyone else with same problem?

I receive this error:  
Couldn’t find the correct values. Please check your work.

Not very descriptive so I don't know what is wrong with my results :/  Anyone else with same problem? I'd really like to finish this project.


Thank you!!

User-added image

 
LinThawLinThaw
hi Varona Raposo,
please try with these Seed Id and order.
A1040, A1019, A1030, A1026, P1009
User-added image
Good luck.
Varona RaposoVarona Raposo
Thanks for your help Lin!!

You gave me the key, it was the order in the filters! I had exactly the same filters but I added them manually because selecting the bars was not working right. If I selected five, it always left out the one where I was clicking to focus.

So I did manually, but then, Salesforce was ordering the values alphabetically so they did not were exactly the same as yours. How frustrating!

Finally I manage to get same filters by selecting all bars and clicking out of the chart to focus. Then I got the filters in same order as yours and finally was able to finish the project.

Hope this info helps to others.

Thank you!
LinThawLinThaw
Hi Thejas,
there is no space at AccountName.
please upload your dataflow.
User-added image
Regards,
LinThaw
LinThawLinThaw
Hi Thejas,
dataflow is fine.
I don't know why your AccountName is not contain space.
please check Account dataset and try to recreate lens again.
Regads,
LinThaw
Plamen PenevPlamen Penev
Hi LinThaw,
I've read your comment and was very useful.

I have a issue with Challenge 4: Challenge Not yet complete... here's what's wrong:
Couldn’t find 'Seed Bank' node exists.


User-added image
Here is my JSON file.
Challenge Not yet complete... here's what's wrongCouldn’t find 'Seed Bank' node exists.
{
  "Calculate Acreage": {
    "action": "computeExpression",
    "parameters": {
      "source": "Load Seed Chart",
      "mergeWithSource": true,
      "computedFields": [
        {
          "precision": 18,
          "name": "Acreage",
          "saqlExpression": "(Seeds_Pound*Spacing)/6272640",
          "scale": 6,
          "label": "Acreage",
          "type": "Numeric"
        }
      ]
    }
  },
  "Create Seed Bank": {
    "action": "sfdcRegister",
    "parameters": {
      "name": "Seed Bank",
      "alias": "Seed_Chart",
      "source": "Calculate Acreage"
    }
  },
  "Load Seed Chart": {
    "action": "edgemart",
    "parameters": {
      "alias": "Seed_Chart"
    }
  }
}
Thejas PThejas P
Thank You @LinThaw. I earned My SuperBadge!!
Plamen PenevPlamen Penev
Hi LinThaw,
The Alias was different, I fixed it.
Ramon DelSaltoRamon DelSalto
Hi Lin, hope all is well and thanks for the help. still stuck on challenge 7 here is the error message "Challenge Not yet complete... here's what's wrong:
Couldn’t find 'Seed ID' in the Order History dataset."

on the data monitor i see the follwoing warning
"The dataflow was completed, but the LookupSingleValue node didn't augment any columns. Either the node didn't find any matches, or a join key contains only null values."

here is the  JSON and thanks for all the help.

{
  "Add Temp Class": {
    "action": "computeExpression",
    "parameters": {
      "source": "Filter 2015",
      "mergeWithSource": true,
      "computedFields": [
        {
          "defaultValue": "Continental",
          "name": "TempClass",
          "saqlExpression": "case when Temperature < 25 then \"Polar\" when Temperature >= 25 and Temperature <= 50 then \"Cool\" when Temperature >= 51 and Temperature <= 85 then \"Continental\" when Temperature > 85 then \"Tropical\" end",
          "label": "TempClass",
          "type": "Text"
        }
      ]
    }
  },
  "Load Seed Orders": {
    "action": "edgemart",
    "parameters": {
      "alias": "seed_bank_agencies"
    }
  },
  "Create Order History": {
    "action": "sfdcRegister",
    "parameters": {
      "name": "Order History",
      "alias": "order_history",
      "source": "Add Seed Orders"
    }
  },
  "Augment Temp Class": {
    "action": "augment",
    "parameters": {
      "right_key": [
        "Country"
      ],
      "left": "Load Account",
      "left_key": [
        "ShippingCountry"
      ],
      "right_select": [
        "TempClass",
        "Country",
        "Date",
        "Temperature"
      ],
      "right": "Add Temp Class",
      "relationship": "Climate",
      "operation": "LookupSingleValue"
    }
  },
  "Load Climate": {
    "action": "edgemart",
    "parameters": {
      "alias": "Global_Climates"
    }
  },
  "Add Seed Orders": {
    "action": "augment",
    "parameters": {
      "right_key": [
        "AccountNumber"
      ],
      "left": "Load Seed Orders",
      "left_key": [
        "Agency_ID"
      ],
      "right_select": [
        "Name",
        "Phone"
      ],
      "right": "Filter Agency Records",
      "relationship": "Agency",
      "operation": "LookupSingleValue"
    }
  },
  "Filter 2015": {
    "action": "filter",
    "parameters": {
      "filter": "Date_Year:R:2015",
      "source": "Load Climate"
    }
  },
  "ID Agency Records": {
    "action": "computeExpression",
    "parameters": {
      "source": "Add Agency Detail Fields",
      "mergeWithSource": true,
      "computedFields": [
        {
          "name": "IsAgency",
          "saqlExpression": "case when Phone is not null then \"TRUE\" else \"FALSE\" end",
          "label": "IsAgency",
          "type": "Text"
        }
      ]
    }
  },
  "Add Agency Detail Fields": {
    "action": "augment",
    "parameters": {
      "right_key": [
        "AccountNumber"
      ],
      "left": "Load Account",
      "left_key": [
        "AccountNumber"
      ],
      "right_select": [
        "AccountNumber",
        "Acres",
        "Currency",
        "Latitude",
        "Longitude",
        "Region",
        "SubRegion"
      ],
      "right": "Load Agency",
      "relationship": "AgencyDetail",
      "operation": "LookupSingleValue"
    }
  },
  "Load Agency": {
    "action": "edgemart",
    "parameters": {
      "alias": "Agency_Detail"
    }
  },
  "Filter Agency Records": {
    "action": "filter",
    "parameters": {
      "filter": "Climate.IsAgency:EQ:TRUE",
      "source": "Add Agency Fields"
    }
  },
  "Load Account": {
    "action": "sfdcDigest",
    "parameters": {
      "fields": [
        {
          "name": "AccountNumber"
        },
        {
          "name": "Name"
        },
        {
          "name": "Phone"
        },
        {
          "name": "ShippingCity"
        },
        {
          "name": "ShippingCountry"
        },
        {
          "name": "ShippingPostalCode"
        },
        {
          "name": "ShippingState"
        },
        {
          "name": "ShippingStreet"
        }
      ],
      "object": "Account"
    }
  },
  "Add Agency Fields": {
    "action": "augment",
    "parameters": {
      "right_key": [
        "AccountNumber"
      ],
      "left": "Augment Temp Class",
      "left_key": [
        "AccountNumber"
      ],
      "right_select": [
        "AccountNumber",
        "IsAgency",
        "Name",
        "Phone",
        "ShippingCity",
        "ShippingCountry",
        "ShippingPostalCode",
        "ShippingState",
        "ShippingStreet",
        "AgencyDetail.Currency",
        "AgencyDetail.Region",
        "AgencyDetail.SubRegion",
        "AgencyDetail.AccountNumber",
        "AgencyDetail.Latitude",
        "AgencyDetail.Acres",
        "AgencyDetail.Longitude"
      ],
      "right": "ID Agency Records",
      "relationship": "Climate",
      "operation": "LookupSingleValue"
    }
  }
}
LinThawLinThaw
Great job Plamen Penev, Thejas P.

Hi Ramon,
At the node [Load Seed Orders],
please change Dataset from ["seed_bank_agencies"] to ["Seed_Bank_Orders"].

Goodluck
LinThaw
Ramon DelSaltoRamon DelSalto
LinThaw, just wanted to say thanks for all the help. 
User-added image
LinThawLinThaw
Congrats Ramon!
Tom Flynn 19Tom Flynn 19
I can't seem to get past step #6...

Why do both Load Seed Bank Agencies w/Climate Data and Load Seed Bank w/Temperature Classification have the Add Temp Class node yet only Load Seed Bank w/ Temperature requires the Define Temp Range node? I'm getting an error on w/Climate Data because it doesn't recognize lowTemp/highTemp.  I would think it is because the Define Temp Range needs to be in both yet that seems like it would have been included in the diretions. Any help would be very much apprecitaed.
LinThawLinThaw
hi Tom

- Load Seed Bank Agencies w/Climate Data,
TempClass SAQL from [Add Temp Class] node don't use lowTemp/highTemp.
<SAQL>
case 
when Temperature < 25 then "Polar" 
when Temperature >= 25 and Temperature <= 50 then "Cool" 
when Temperature >= 51 and Temperature <= 85 then "Continental" 
when Temperature > 85 then "Tropical" 
end

- Load Seed Bank w/Temperature Classification,
TempClass SAQL from [Add Temp Class] node use lowTemp/highTemp from previous node [Define Temp Range].
<SAQL>
case 
when lowTemp < 25 and highTemp < 25 then "Polar" 
when lowTemp >= 25 and lowTemp <= 50 and highTemp >= 25 and highTemp <= 50 then "Cool"
when lowTemp >= 51 and lowTemp <= 85 and highTemp >= 51 and highTemp <= 85 then "Continental"
when lowTemp > 85 and highTemp > 85 then "Tropical"
when lowTemp < 25 and (highTemp >= 25 and highTemp <= 50) then "Polar-Cool" 
when lowTemp < 25 and (highTemp >= 25 and highTemp <= 85) then "Polar-Cool-Continental" 
when lowTemp < 25 and highTemp > 85 then "Polar-Cool-Continental-Tropical" 
when (lowTemp >= 25 and lowTemp <= 50) and (highTemp >= 51 and highTemp <= 85) then "Cool-Continental" 
when (lowTemp >= 25 and lowTemp <= 50) and highTemp >= 85 then "Cool-Continental-Tropical" 
when (lowTemp >= 51 and lowTemp <= 85) and highTemp > 85 then "Continental-Tropical" 
end

Regards,
LinThaw
Kunaal Mathur 19Kunaal Mathur 19
Hi Lin, Gunwant and All - Hope you are doing well!

I am stuck on Challenge 3 with the following message. Any help would be much appreciated. Thanks!

"Challenge Not yet complete... here's what's wrong: 
Couldn’t find 'Top 5 Agencies' lens. Please confirm the name as described."

The 'Load Seed Bank Agencies' dataflow ran successfully. However, the newly created Seed Bank Agencies Dataset was empty (with 0 rows).

Lin - I verified that the Accounts (loaded with Agency Data txt file) have the account numbers and phone numbers in the required format (same as yours) AND the Agency Details file has the Account Numbers as well.
 
Any advice about what might be missing is welcome.

Here is my JSON for your reference:

{ "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": [ { "name": "IsAgency", "saqlExpression": "\"case when Phone is not null then \\\"TRUE\\\" else \\\"FALSE\\\" end\"", "label": "IsAgency", "type": "Text" } ] } } }
LinThawLinThaw
Hi Kunaal Mathur,

please use following SAQL Expression for IsAgency at node [ID Agency Records].
case when Phone is not null then "TRUE" else "FALSE" end

Good luck & Regards,
LinThaw
 
Kunaal Mathur 19Kunaal Mathur 19
Thanks a lot, LinThaw! It worked. Now on Challenge #6!

Regards,
Kunaal.
LinThawLinThaw
Great!
Hiroaki NishiyamaHiroaki Nishiyama
I got this badge that is first superbadge for me.
Thanks for all the help!!
Pia-Han Kersting 5Pia-Han Kersting 5
Hello everonyone, I stuck on challenge #6. I hope that anybody could help me.

"Challenge Not yet complete... here's what's wrong: 
We can't find the 'Create Seed Bank Agencies' node or required fields are missing. Check the challenge and confirm the node name and required fields."

Here is my json:

{
  "Filter Agency Records": {
    "action": "filter",
    "parameters": {
      "filter": "IsAgency:EQ:TRUE",
      "source": "ID Agency Records"
    }
  },
  "Load Account": {
    "action": "sfdcDigest",
    "parameters": {
      "fields": [
        {
          "name": "Phone"
        },
        {
          "name": "ShippingCity"
        },
        {
          "name": "ShippingCountry"
        },
        {
          "name": "AccountNumber"
        },
        {
          "name": "Name"
        },
        {
          "name": "ShippingState"
        },
        {
          "name": "ShippingStreet"
        },
        {
          "name": "ShippingPostalCode"
        }
      ],
      "object": "Account"
    }
  },
  "Add TempClass": {
    "action": "computeExpression",
    "parameters": {
      "source": "Filter 2015",
      "mergeWithSource": true,
      "computedFields": [
        {
          "defaultValue": "Continental",
          "name": "TempClass",
          "saqlExpression": " case when Temperature < 25 then \"Polar\" when Temperature >= 25 and Temperature <= 50 then \"Cool\" when Temperature >= 51 and Temperature <= 85 then \"Continental\" when Temperature > 85 then \"Tropical\" end",
          "label": "TempClass",
          "type": "Text"
        }
      ]
    }
  },
  "Create Seed Bank Agencies": {
    "action": "sfdcRegister",
    "parameters": {
      "name": "Seed Bank Agencies w/Climate Data",
      "alias": "seed_bank_agencies_with_climate_data",
      "source": "Augment TempClass"
    }
  },
  "Load Climate": {
    "action": "edgemart",
    "parameters": {
      "alias": "Global_Climates"
    }
  },
  "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"
    }
  },
  "Filter 2015": {
    "action": "filter",
    "parameters": {
      "filter": "Date_Year:EQ:2015",
      "source": "Load Climate"
    }
  },
  "Augment TempClass": {
    "action": "augment",
    "parameters": {
      "right_key": [
        "Country"
      ],
      "left": "Filter Agency Records",
      "left_key": [
        "ShippingCountry"
      ],
      "right_select": [
        "Country",
        "Date",
        "Temperature",
        "TempClass"
      ],
      "right": "Add TempClass",
      "relationship": "Climate",
      "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"
        }
      ]
    }
  }
}
cheryl bunch 11cheryl bunch 11
I'm hoping someone can help becauase I cannot get past #3 on the Einstein Analytics Data Preparation Super Badge.  I have redone it in 8 different orgs already and also have uploaded 4 other people's json files that have succeeded for them but fail for me. I have checked EVERYTHING multiple times against all forum posts and have exactly the same setup but it fails. All dataflows run successfully and match to my pivot tables of the raw data, but I cannot "check" step 3 successfully. I have even created a separate Trailhead account in case it had something to do with my account - same error. It has to have something to do with something outside the data flow since the json that works for others does not work for me.  
I am COMPLETELY baffled without a good IDE to troubleshoot.

I have even tried "checking" a blank data flow labled "Load Seed Bank Agencies" and get the exact samee error so the error is not specific to what is really wrong. I have had another person walk through my entire work and he didn't find anything out of place. The error is as follows:

Load Seed Bank Agencies Dataflow Error

Here is setup:
User-added imageUser-added imageUser-added image
cheryl bunch 11cheryl bunch 11
Here is my json. @LinThaw do you see anything out of place?{
  "Filter Agency Records": {
    "action": "filter",
    "parameters": {
      "filter": "IsAgency:EQ:TRUE",
      "source": "ID Agency Records"
    }
  },
  "Load Account": {
    "action": "sfdcDigest",
    "parameters": {
      "fields": [
        {
          "name": "AccountNumber"
        },
        {
          "name": "ShippingPostalCode"
        },
        {
          "name": "ShippingState"
        },
        {
          "name": "ShippingStreet"
        },
        {
          "name": "ShippingCountry"
        },
        {
          "name": "ShippingCity"
        },
        {
          "name": "Name"
        },
        {
          "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": [
        {
          "name": "IsAgency",
          "saqlExpression": " case \n       when Phone is not null then \"TRUE\"  \n   else \"FALSE\"  \n end",
          "label": "IsAgency",
          "type": "Text"
        }
      ]
    }
  }
}

 
Emily Morse 17Emily Morse 17
Just wanted to throw in a shout out to everyone who contributed to this thread, especially LinThaw! I just completed the Superbadge, and every question or issue that came up for me was answered somewhere in here. Thank you!
cheryl bunch 11cheryl bunch 11
I resolved my issue after much time. I imported my Agency Details Longitude and Latitude fields as dimensions instead of measures because we were not going to calculate against them. That was it!
cheryl bunch 11cheryl bunch 11
@Pua-Han Kerating look at your Create Seed Bank Agencies register node. This should still have the same name and alias as the initial flow did “Seed Bank Agencies”. That’s why the check isn’t finding it.

  "Create Seed Bank Agencies": {
    "action": "sfdcRegister",
    "parameters": {
      "name": "Seed Bank Agencies",
      "alias": "seed_bank_agencies",
      "source": "Augment TempClass"
    } .find_in_page{background-color:#ffff00 !important;padding:0px;margin:0px;overflow:visible !important;}.findysel{background-color:#ff9632 !important;padding:0px;margin:0px;overflow:visible !important;}
LinThawLinThaw
Congrats cheryl bunch!
sorry, for delay reply.
if you got still stuck in other steps, please let me know.

Congrats Emily Morse too.

Hi Pia-Han Kersting,
according to cheryl bunch's mention, you have to rename on Alias and Name in Create Seed Bank Agencies.
If you still got this error, please refer my json.
{
  "Add Temp Class": {
    "action": "computeExpression",
    "parameters": {
      "source": "Filter 2015",
      "mergeWithSource": true,
      "computedFields": [
        {
          "defaultValue": "Continental",
          "name": "TempClass",
          "saqlExpression": "case when Temperature < 25 then \"Polar\" when Temperature >= 25 and Temperature <= 50 then \"Cool\" when Temperature >= 51 and Temperature <= 85 then \"Continental\" when Temperature > 85 then \"Tropical\" end",
          "label": "TempClass",
          "type": "Text"
        }
      ]
    }
  },
  "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": "Augment TempClass"
    }
  },
  "Load Climate": {
    "action": "edgemart",
    "parameters": {
      "alias": "Global_Climates"
    }
  },
  "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"
    }
  },
  "Filter 2015": {
    "action": "filter",
    "parameters": {
      "filter": "Date_Year:EQ:2015",
      "source": "Load Climate"
    }
  },
  "Augment TempClass": {
    "action": "augment",
    "parameters": {
      "right_key": [
        "Country"
      ],
      "left": "Filter Agency Records",
      "left_key": [
        "ShippingCountry"
      ],
      "right_select": [
        "Country",
        "Date",
        "TempClass",
        "Temperature"
      ],
      "right": "Add Temp Class",
      "relationship": "Climate",
      "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"
        }
      ]
    }
  }
}

Regards,
LinThaw
Cheryl Bunch 19Cheryl Bunch 19
Thanks Lin Thaw. I passed all steps that was my only issue to all steps! Now working on the more difficult Insights SuperBadge with much more SAQL coding. I haven’t coded in years so challenging.
LinThawLinThaw
Hi Cheryl Bunch,
Glad to hear! Good Luck for next SuperBadge!
Pia-Han Kersting 5Pia-Han Kersting 5
Thank you LinThaw and Cheryl Bunch, 
I followed your idea and I changed the field types of latitude and longitute from measure to dimension but it sady didn't work. I also tried to upload your JSON LinThaw but I get still the same error message.
Bernadette MisaBernadette Misa

I'm stuck in Challenge 7.

 

This is the error:

 

User-added image

This is the screenshot of my lens:

User-added image

If anyone can help, especially @LinThaw :D please do so. I created a new Analytics DE for this Superbadge.

 

Thanks!

LinThawLinThaw
Hi Bernadette Misa,

it is first time to see this kind of error for this Superbadge.
please try to post this error content on developer forum again,
I hope someone from salesfore will come and solve to it.

or please try with latest? analytics DE for this step.
https://developer.salesforce.com/promotions/orgs/analytics-de

Good luck, Regards,
LinThaw
Bernadette MisaBernadette Misa
Duly noted. Thanks Lin!
Bernadette MisaBernadette Misa

Your advice worked Lin. I signed up again for a new DE and redid the whole thing and it worked.

 

User-added image

 

It's so weird because I only signed up for the new Analytics DE this week. Oh well, finally had this Superbadge. Thanks for the help of everyone here!

LinThawLinThaw
Good Job Bernadette Misa! Congratulation.
Edward SandovalEdward Sandoval

I hit the "Couldn’t find Agency records from the Account object." The solution had nothing to do with the error message.
Make sure the "Load Seed Bank Agencies" dataflow has exactly the same number of nodes with the corresponding names.
I added a "CleanUp" node before the register  to get rid of the "IsAgency" field.  THis is consistent with the "Create Seed Bank Agencies" node definition (which does not include "IsAgency"). 

However, my extra "CleanUp" node, although consistent with the output, was making the challenge validation to fail. 

 

 

LinThawLinThaw
Hi  Edward Sandoval,
did you find solution from these comments?
User-added image