Apex Code Development You need to sign in to do that
Don't have an account?
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
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
Please refer below, I passed this step 3.
fig 1.
fig 2.
and create Top 5 Agencies lenses.
Regards,
LinThaw
All Answers
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.)
Brian- I initially got the error you are getting. Make sure the dataset is saved to the correct app.
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!
Not able to create dataset, while running the dataflow I am getting above error. What am I doing wrong?
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.
Thanks
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.
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
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
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
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.
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
Any assistance with this step would be greatly appreciated. Thank you!
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: Then, on the "Filter Agency Records" node, you have to use the following syntax:
dim:EQ:value
For example: If that doesn't do the trick, can you post the error?
Good luck!
Dave
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?
Regards,
LinThaw
Couldn’t find 'Create Seed Bank Agencies' node. Please check the name and alias spelling."
This is highly annoying. Any other thoughts?
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
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.
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.
Please refer below, I passed this step 3.
fig 1.
fig 2.
and create Top 5 Agencies lenses.
Regards,
LinThaw
'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'.
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
@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)
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
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?
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
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?
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
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?
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.
Regards,
LinThaw
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.
Regards,
LinThaw
please read business requirements again,
flow maybe like this.
Regards,
LinThaw
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 ??
@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 !
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
here is my [Add Temp Class] node.
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.
Regards,
LinThaw
this error is because [Quantity Ordered] field in dataset has prefix (relationship name).
So, please set [Load Seed Orders] in Left Source.
so, Lens setting will be look like this without prefix.
Regards,
LinThaw
Correct :-)
Just found it
Thanks a lot for your help
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.
Thanks.
Hi ankita,
how about your flow?
I think your flow is missing node.
my 'Create Seed Bank' node is as follow.
Regards,
LinThaw
Thanks,
Ankita Varma
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?
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.
Before [Filter Agency Records] node, I have [Add Agency Fields] in which I named Relationship as Climate, (it is optional)
finally [Filter Agency Records] node becomes,
Good Luck...
Regards,
LinThaw
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 !
it is described in following section. :)
my [Define Temp Range] node setting is as follow,
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.
Regards,
LinThaw
have you added these three nodes?
Regards,
LinThaw
thanks lin, i was got confused by two different data flows !!
THIS is my Final Lens, is this a valid lens ??
I am @klthaw on twitter just a reader.
Hi Aviral,
please add one row.
Regards
LinThaw
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.
Following are my screenshot of dataflow.
your flow seems perfect.
is there any node missing in (Load Seed Bank Agencies w/Climate Data) flow?
Regards,
LinThaw
I think you have problem in augment node just interchange the left and right node !!
No rows are missing in Load Seed Bank Agencies w/Climate Data.
This is my dataflow.
Thanks,
Ankita Varma
have you these three fields?
Regards,
LinThaw
I am stuck on Step #4 , Dall data set and dataflows are in place , Still gettinga n error :
Error and data flow :
flow look like as follow,
please change Source Node.
Good Luck
Regards,
LinThaw
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.
Please upload details of each node (Attributes and Output Fields).
Regards,
LinThaw
{ "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" } } }
Below are the Node details ;
In first node, select ["Seed_Chart"] NOT ["Seed_bank"].
I hope you solve it.
Regards,
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.
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.
Your guidence helped me to complete challenge #6.
Regards,
Ankita Varma
Regards,
Ankita Varma
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
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
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.
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?
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?
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
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 :
order of the nodes in flow is not correct.
please refer look like this.
and in SAQL you mentioned, please add double code to TRUE and FALSE.
[Add Agency Fields] node should be like this.
Regards,
LinThaw
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)".
Please upload your dataflow.
Regards,
LinThaw
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)
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
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 :
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
Special thanks to LinThaw, you took your precious time to help us.
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.
{ "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" ] } } }I am adding the monitor logs screenshot for additional help.
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
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)
change on which node?
please change [Climate] on this filter by new relationship name.
Climate.IsAgency:EQ:TRUE
Regards,
LinThaw
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" ] } } }{ "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" ] } } }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
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.".
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" } } }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
Finally Completed the Superbadge !
Thank you for all the help!!!!.
I also got study well on this Analytics.
Regards,
LinThaw
@LinThaw
My lens is this in challenge 3.
but this error [Couldn’t find the correct values. Please check your work.]
Heeeelp
I didn't found "Voomm" Account in your Top 5 records.
Please check your Agency Data correctly uploaded.
maybe Lens look like this.
Regards,
LinThaw
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
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
Is anyone else having this issue? I've checked the naming conventions several times- "Load_Agency_Detail" for the alias name.
Any help appreciated!
please upload your JSON.
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.
I passed this challenge.
If you had not helped me,I coundn't clear this.
Thanks a lot!!!
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.
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
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" } } }
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
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" } } }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!
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
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" } } }json is fine.
Please check your dataflow name is [Load Seed Bank Agencies].
And your challenge playground is selected correctly.
Regards,
LinThaw
Playground is correct and dataflow name is Load Seed Bank Agencies.
It succs --> step 3 works fine. why it will not check.
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" } ] } } }
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
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
Please help to clear Challenge#3.
thanks & Regards,
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,
please check compare with your result, input and output row counts.
Regards,
LinThaw
Thanks for the support.
For Challenge #6 I am facing below error. Please help me to clear.
{
"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"
}
]
}
}
}
your flow is not order, please try your data flow look like this.
Regards,
LinThaw
Can you please post your JSON / Screenshots of each node?
thanks
Regards,
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
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
Thanks for your help anyway but I am out of options.
Regards
Justin
{
"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
I cleared Superbadge, Thanks a ton :)
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!
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.
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
(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!
[Load Climate] node is 'Load Global Climate'.
How about your alias name and output fields?
If you have still face with this error, please upload json here.
Regards,
LinThaw
I'm stuck on Challenge 7 getting this error:
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
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
I used your dataflow but still getting the same error.
My lens gives this results.
Is it correct?
Regards
Simone
last record is different.
this is my lens.
Regards,
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
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.
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
I just had to edit the Agency Detail dataset and re--upload the file, leaving the latitude / longitude fields as they are.
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?
If you find a solution post it here please!
Thank you
{
"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"
}
}
}
I am not sure,
please select last row as below.
Hi Robert and Simone,
your error is hard to find.
How about your Account Replication?
If it is fine, please try run Account Replication again before your dataflow run.
Regards,
LinThaw.
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
@Simone let me know if you still need help. Maybe we can do a WebEx and figure it out.
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 :(
In first node, you have to select dataset ["Seed_Chart"].
if still got error, plz upload your json.
Regards,
LinThaw
"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
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"
}
]
}
}
}
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 :)
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
sorry not Ramos, Ramon!
passed the super badge now, thank you for all the help :)
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!
Did you try this?
Regards,
LinThaw
Thanks.
Thanks for your support guys!
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!
Sébastien
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
Challenge Not yet complete... here's what's wrong:
Couldn’t find Agency records from the Account object.
yes i had created ...
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: sfdcRegister
can you please help me on this?
thanks,
Shobha
output rows of [Filter Agency Records] node is 383.
In your case, there is no output rows.
please check filter again.
Regards,
LinThaw.
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
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"
}
]
}
}
}
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
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 } ] } } }
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
+4750 Points
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
w/Climate Data
There are some error in [Create Seed Bank Agencies: sfdcRegister] of w/Climate Data.
Please refer below image.
Regards,
LinThaw
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."
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"
}
]
}
}
}
your dataflow is running success,
please show me warning screen.
Dataset and Flow Result is as follows.
Regards,
LinThaw
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.
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.
And please also check Agency Detail dataset has AccountNumber.
Regards,
LinThaw
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.
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.
Please share your thoughts.
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:
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.
thanks
Gunwant
Maybe the issue comes from your "filter 2015". Could you please try with this syntax : Date_Year:EQ:2015.
Regards,
Olivier
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
I am getting below error could you. Please guide me.
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
Please check my lens
.
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" } } }
your flow is working well in my org.
please compare with my flow result
Hi Sharath,
did you solve it?
Regards,
LinThaw
No I am still getting error
.
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 =)
LinThaw
Finally I have completed the module:)
Thanks a lot.
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.
Pleasae advise
Thanks,
Hitesh Patel
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.
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" } } }"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?
Many thanks! I noticed that it is not showing me Alias when I created it and now:
Why do I see a different screen?
I tried to removed the Load in the JSON file and got this error. I also tried your JSON but again the same error:
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:
In edgemart node, Dataset name means Alias.
when loading Agency Detail.txt please leave dataset name as default.
Good luck
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!
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.
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.
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
I tried with yours but the warning remains. The issue is with the Load Agency Detail file that doesn't return any values:
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.
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.
Regards,
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:
Thanks in advance!
please run this query in Developer Console,
and check data is loaded correctly.
Regards,
LinThaw
I ran the query and got 383 results.
Agency Detail Dataset
Target Records on Account obj
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;
Something might have gone wrong with my join / augment node?
Thanks in advance!
your errors are same.
please try with following steps.
1. Select Setup >> Account
2. Check required fields are selected and click Continue
3. Check Phone and AccountNumber are imported correctly then Save
Finally, please rerun your dataflow, then warning will clear. Goodluck!
Regards,
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" } ] } } }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.
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
<computeExpression Transformation>
https://resources.docs.salesforce.com/sfdc/pdf/bi_admin_guide_data_integration_guide.pdf
I'll read over this. It looked like it will benefit not only this Superbadge by my overall use of Analytics.
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"
}
]
}
}
}
please check Account dataset and save again.
if you used custom fields [IsAgency__c] in filter, clear it.
good luck
Regards,
LinThaw
{
"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"
}
]
}
}
}
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.
how about this solution?
good luck
Regards,
LinThaw
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
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?
please run Account dataset again and your dataflow.
and try to create lens.
run results are look like below.
Regards,
LinThaw
[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
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
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
"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"
}
]
}
}
}
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
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" } } }your json is fine.
please try to edit order of Seed ID as follow.
Regards,
LinThaw
your json is broken something.
please upload again.
Regards,
LinThaw
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.
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!!
please try with these Seed Id and order.
A1040, A1019, A1030, A1026, P1009
Good luck.
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!
there is no space at AccountName.
please upload your dataflow.
Regards,
LinThaw
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
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.
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"
}
}
}
The Alias was different, I fixed it.
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"
}
}
}
Hi Ramon,
At the node [Load Seed Orders],
please change Dataset from ["seed_bank_agencies"] to ["Seed_Bank_Orders"].
Goodluck
LinThaw
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.
- Load Seed Bank Agencies w/Climate Data,
TempClass SAQL from [Add Temp Class] node don't use lowTemp/highTemp.
<SAQL>
- Load Seed Bank w/Temperature Classification,
TempClass SAQL from [Add Temp Class] node use lowTemp/highTemp from previous node [Define Temp Range].
<SAQL>
Regards,
LinThaw
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" } ] } } }
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
Regards,
Kunaal.
Thanks for all the help!!
"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"
}
]
}
}
}
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:
Here is setup:
"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"
}
]
}
}
}
"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;}
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
Glad to hear! Good Luck for next SuperBadge!
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.
I'm stuck in Challenge 7.
This is the error:
This is the screenshot of my lens:
If anyone can help, especially @LinThaw :D please do so. I created a new Analytics DE for this Superbadge.
Thanks!
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
Your advice worked Lin. I signed up again for a new DE and redid the whole thing and it worked.
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!
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.
did you find solution from these comments?
I'm getting an error on challenge 7 saying "We can't confirm the correct values were found. Please check your work."
Everything is correct with my dataflow as well as my Top 5 Seed Bank Orders lens so I don't know what to do as I'm stuck.
How do i do this part? I've uploaded Agency data via import wizard and create an Agency Detail dataset. I've tried combining them with recipe but I can't find the Agency data there.
The part you mentioned above is overview description.
Did you create dataflow and lens, according to business requirement under section "Dataflow Name: Load Seed Bank Agencies"
Regards,
LinThaw
Hi LinThaw,
I've tried Create --> Dataset --> Salesforce Data and when it asked me to add to existing dataflow, I've only have the default dataflow. How do I create a new one? I've looked online and all of them uses the default dataflow. Thanks!
This superbadge need to play with many Dataflows.
you can find Create Dataflow button as follow.
some references,
https://help.salesforce.com/articleView?id=000267071&type=1
https://help.salesforce.com/articleView?id=bi_integrate_workflow_overview.htm&type=5
Regards,
LinThaw
Aneske
Hi All,
I'm currently stuck on Step 6 and am not sure what I'm doing wrong. I have all of the lens outputs saved and they look correct, but I've gone through two new Developer Edition orgs and am still getting the error below. Has anyone hit this issue in the past? Any ideas for troubleshooting would be much appreciated.
Best,
Jamie
-Jamie
Can anyone please help me with the challenge 3 and 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": "AccountNumber"
},
{
"name": "Name"
},
{
"name": "Phone"
},
{
"name": "ShippingCity"
},
{
"name": "ShippingCountry"
},
{
"name": "ShippingState"
},
{
"name": "ShippingPostalCode"
},
{
"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 here is what I am getting when I am creating the lens and I dont know where I am doing wrong:
and one more thing when i run the query "select name, phone, accountnumber from account where phone <> ''
I only got 183 records while I have uploaded the files successfully.
Regards,
Akash Garg
I have changed the alias name in the Create Seed Bank Agencies node from Seed_Bank_Agencies to seed_bank_agencies. My Dataflow runs successfully but when i am creating the lens and sorting it descending then it is still not showing the accurate data.
Challenge error:
We can't confirm you found the correct values. Please check your work.
Regards,
Akash