Hello all! It's time for another superbadge! I started this superbadge a long time ago... it's time to finish it! My goal is to complete this badge before my little brother starts to walk. He's getting close...
Step 2- This is one checkbox in setup. You're on your own!
Step 3- Let's talk about that.... Dataflow.
The best tool to use when crafting your dataflow is the data monitor. It can help troubleshoot issues to find which part of the process needs some work. For example.... Why were rows not created?
The problem?
A box was checked that should not be checked....
The alias name was not correct for the "register" node.
Once you see that beautiful green "Success" message, it's time to check the challenge. Do not be discouraged if you get a few error messages. This superbadge is EXTREMELY picky on syntax. A few common errors:
You can see this error and still have the "Load Agency Detail" node in your dataflow. Check for spelling, and if this is correct, double check the name of the dataset used to create the node. The dataset name should be auto generated based upon the name of the CSV upload file.
The dataset may also be saved to the incorrect app. Double check this from the Analytics Studio - "Datasets."
&
Thanks! This was helpful!
ReplyDeletehi, I am stuck with the IsAgency computed Field. I try to use this expression (Case when Phone is null then "False" else "True" end) but it doesn't work.
ReplyDeleteAny idea about what I'm doing wrong?
Thank You!
You are so close! Try reversing.... Case when Phone is not null then "TRUE" else "FALSE" end)
DeleteMany thanks man! Awesome help!
ReplyDeleteI keep getting the following error while trying to complete challenge three:
ReplyDelete'Something went wrong while executing the ID Agency Records node: invalid field expression for field 'IsAgency': Syntax Error at position [line 1: column 10] after token EQ :: '
Can I p;lease get some sage advice on this section I have spent all afternoon on it and can't get anywhere. Thanks ahead of time.
Just because I like your style.... "sage" is a fabulous word.
DeleteI'd try something like: case when Phone is not null then....
Type text.
Hi, I am not able to see my dataset, I have created the dataflow and its success. Then I went to Datasets > Create using dataflow > then it goes to data manager and I don't know what to select in it.
ReplyDeleteDid you create the dataset needed for the dataflow first?
DeleteThe process should look like:
1) Create dataset - "Agency Detail" using the CSV upload
2) Create the dataflow- which brings in the Salesforce data and smashes it in with the Agency Detail data
3) View results/create lens
Hi @Trailheadbaby I am working on Einstein Analytics Super badge Data Preparation Specialist Challenge 3
Deleteand i am getting Following Error:
Challenge Not yet complete... here's what's wrong:
We can't find a filter on Account Name.
could you please help me with this
Thanks in Advance
95% of the people of the people I've seen with this problem forgot to add the Account Name filed during the Augument step. If that's not it... I'm happy to peek at your json
DeleteHi TrailHeadBaby ,
DeleteI'm also facing the same issue as mentioned by Aman,Kindly find Json and help me
{
"Filter Agency Records": {
"action": "filter",
"parameters": {
"source": "ID Agency Records",
"saqlFilter": "IsAgency==\"True\""
}
},
"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": "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": [
"Currency",
"Region",
"SubRegion",
"Latitude",
"Acres",
"Longitude",
"AccountNumber"
]
}
},
"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"
}
]
}
}
}
Look in here:
DeleteAdd Agency Fields": {
"action": "augment",
"parameters": {
"left": "Load Account",
"right": "Load Agency Detail",
"relationship": "AgencyDetail",
"operation": "LookupSingleValue",
"left_key": [
"AccountNumber"
],
"right_key": [
"AccountNumber"
],
"right_select": [
"Currency",
"Region",
"SubRegion",
"Latitude",
"Acres",
"Longitude",
"AccountNumber"
Hi, I am still facing issue Please let me know what changes i need to take care,
DeletePFB my Json script
{
"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": "Add Agency Fields"
}
},
"Add Agency Fields": {
"action": "augment",
"parameters": {
"right_key": [
"AccountNumber"
],
"left": "Filter Agency Records",
"left_key": [
"AccountNumber"
],
"right_select": [
"Currency",
"Acres",
"SubRegion",
"Region",
"Latitude",
"Longitude"
],
"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 not null then \"TRUE\" else \"FALSE\" end",
"label": "IsAgency",
"type": "Text"
}
]
}
}
}
he 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
ReplyDeleteStill Can't get this to work, did all the fixes. I tried starting a new org but salesforce einstein keeps dumping me in the same one with different logins.
ReplyDeleteSomething went wrong while executing the ID Agency Records node: invalid field expression for field 'IsAgency': Syntax Error at position [line 1: column 10] after token when :: ;Case when Phone is not ; (02K3i000000h8dfEAA_03C3i000000ZPPlEAO)
Challenge Not yet complete... here's what's wrong:
ReplyDeleteWe can't find Agency records in the Account object.
In the 'Add Agency Fields' node (where you augment), make sure you state in the Relationship field: AgencyDetail
DeleteHi,
ReplyDeleteI'm stuck at the beginning, idk how/where to apply these steps:
"Load the pre-populated Account object.
Load the Agency Detail.txt file to update the Account object with the recently added fields since the initial import.
Create a filter to select records associated with the Seed Bank project from the Account object.
Add the custom fields from the Agency Detail.txt file to the Account object.
Register the Account object as the new Seed Bank Agencies dataset."
Hope you could help :)
I'd go learn a little more about the topic first then....
DeleteLoading data to Einstein isn't tough to do, but you will need some basics first in order to complete the superbadge. Trailhead has some great modules...
I agree, but when I try to load the agency details.txt file via the data import wizard, there is some mapping issue, only the account number field matches and I don't know what to do from here, could you guide me?
DeleteYou do not upload through the data import wizard.... The data set is created from the Analytics Studio.
DeleteOk, then how can I do that? The salesforce guides are applicable to CSV file uploads only, can't find anything on uploading txt type
DeleteYou can upload to a new dataset with the file provided.
DeleteHi, I re-read the trailheads, watched youtube videos on datasets, but the steps I mentioned here are still not clear to me, do you have any tips/guides? I think the instructions are not clear to me, not the concepts themselves.
DeleteI'm not sure how to help.... You click to create a new dataset then select the upload file. It is all done within anlytics. It might be helpful- click on the gear icon in the analytics studio to select a different part of the app.
DeleteHi,
ReplyDeleteI do all the dataflow and the lens, but I can't complete the Challenge, this is the error:
"We can't confirm you found the correct values. Please check your work."
I really don't know what is wrong, can you help me?
Thanks
I am happy to help if you share some details.
DeleteAloha!
ReplyDeleteI have a question regarding your second screenshot (dataset details) for the "Create Seed Bank Agencies" challenge (#3). I was wondering if it was made before or after you made the discovery about the alias for the "Create Seed Bank Agencies" node?
I did the following:
1. Created all of the nodes with the correct names/relationship/alias/etc.
2. Verified that all of the required output fields are selected.
3. Verified that the dataset and app were put into the correct app (and run without error).
4. Created a top 5 lens.
I continue to get an error similar but not verbatim to the one you mentioned above: "We can'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." I've tried a number of different variations on the alias just in case the issue had been corrected but just can't get past this error. The only difference I'm aware of is the API name for your dataset, but if that's the issue it's a rather poorly written error message.
Any insights you might have into where I might have gone wrong would be appreciated!
The alias has to be seed_bank_agencies in order to pass the challenge... Is this what you have?
DeleteYes'm. For the node "Create Seed Bank Agencies" I have:
DeleteAlias: seed_bank_agencies
Name: Seed Bank Agencies
The actual JSON for this part of the flow:
"Create Seed Bank Agencies":
{"action":"sfdcRegister"
,"parameters":{"name":"Seed Bank Agencies"
,"alias":"seed_bank_agencies","source":"Filter Agency Records"}}
It creates a dataset in Mosaic called "Seed Bank Agencies" with an API name of "seed_bank_agencies" (versus the "create_seed_bank_agencies" in your screenshot above).
Looking at the dataset, AgencyDetail.Acres is the only measure and then the remainder are the required dimensions. The only two differences are that I also have the Account ID, IsAgency, and instead of "Shipping Postal Code" I have "Shipping Zip/Postal Code" as the name for the attribute (ShippingPostalCode is API name).
This is an incredibly frustrating "why does it say paper jam when there is no paper jam" scenario.
Agreed 100% with the paper jam analogy! I had the same issue with this challenge. Our JSON is identical for this portion. Want to drop the whole JSON here and I'll take a look at it?
DeleteAlso - I got this error when the name of my dataset didn't match the exact (somewhat non specified!) challenge requriements - IE: "Agency Detail"
DeleteI'll respond twice, once with the JSON separately because in theory someone could take it and just upload it (i.e. cheat) so you don't have to approve this comment. :)
Delete{
"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": "ShippingPostalCode"
},
{
"name": "ShippingState"
},
{
"name": "ShippingStreet"
},
{
"name": "ShippingCountry"
},
{
"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": [
"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": [
{
"defaultValue": "\"FALSE\"",
"name": "IsAgency",
"saqlExpression": "case when 'Phone' is not null then \"TRUE\" else \"FALSE\" end",
"label": "IsAgency",
"type": "Text"
}
]
}
}
}
I passed! Another undocumented challenge requirement. 48 revisions in of trying any possible combination of casing, underscores, order of dataflow transforms, etc. it occurred to me that I altered the Agency Detail dataset to make lat/long dimensions because they aren't measures and as a data geek it aggravates me. :)
DeleteI tried creating a new "Agency Detail" (but API name of Agency_Detail1) with the file left as is, but that didn't work either and your latest response explained why.
I nuked the modified Agency_Detail and uploaded it again, and lo, I passed.
On a general note, it throws the error I mentioned even for a blank dataflow so it is about as generic as it gets.
Huzzah for Trailhead Baby!
So glad to hear that you passed!! (And I was hit by the latitute/longitude thing as well! They should be dimensions---- I had to delete/redo it a few times)
DeleteCongrats!!!
Had the same issue with latitude/longitude, change them back to measures so you can pass the challenge.
DeleteThank you thank you thank you! I was going crazy here until I saw your comments... just re-uploaded the file without 'fixing' the latitude/longitude and it passed!
Delete*happy dance*
I've been going at it (Challenge#3) and I still have not cleared it. I was following Rebecca and Justin's posts/comment and I realized I haven't even altered the Agency Detail file.
DeleteI'll just have to spin another org tomorrow.
If anyone here has other ideas, please do share.
Thanks in advance. =)
Now here's something crazy...
DeleteInstead of NOT doing anything to the "Agency Detail" file, I actually DID changed Lat & Long to dimension instead of measure. Arnie's suggestion (https://developer.salesforce.com/forums?id=9062I000000QyHpQAK) seem to contradict everything I've read prior but I thought I'd give it a try before going to bed.
(I think that's what Trailhead Baby was saying in Sept 26, 2019, but I just got so confused with all the post & comments I've read through for this.)
All good now. Good night. =)
Glad you solved it!!!!
DeleteI confirmed that the latitute/longitude must be dimensions. I deleted and re-created the Agency Details data using latitute/longitude as dimensions and was able to pass the Challenge!
DeleteI am getting we can't find agency records in the account object
ReplyDeleteDid you add it in the data flow?
DeleteI would appreciate a 2nd set of eyes.
ReplyDeleteI'm getting a similar error: We can'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.
I think my JSON is the same. I even started with a new EA Dev org. The Seed Bank Agencies dataset is in the Mosaic App with 383 rows.
The only thing I can think of is that the output fields for the 'Create Seed Bank Agencies' includes the IsAgency and the challenge field count is off. Any feedback would be awesome.
{
"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",
"SubRegion",
"Region",
"Latitude",
"Longitude"
],
"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"
}
]
}
}
}
Create Seed Bank Agencies": {
Delete"action": "sfdcRegister",
"parameters": {
"name": "Seed Bank Agencies",
"alias": "seed_bank_agencies", - Change this alias.
"source": "Filter Agency Records"
"right_select": [
"Acres",
"Currency",
"SubRegion",
"Region",
"Latitude",
"Longitude"
You are missing one field.
got the same issue
ReplyDelete{
"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": "ShippingPostalCode"
},
{
"name": "ShippingState"
},
{
"name": "ShippingStreet"
},
{
"name": "ShippingCountry"
},
{
"name": "ShippingCity"
}
],
"object": "Account"
}
},
"Create Seed Bank Agencies": {
"action": "sfdcRegister",
"parameters": {
"name": "seedbankagencies",
"alias": "seedbankagencies",
"source": "Filter Agency Records"
}
},
"Add Agency Fields": {
"action": "augment",
"parameters": {
"right_key": [
"AccountNumber"
],
"left": "Load Account",
"left_key": [
"AccountNumber"
],
"right_select": [
"Currency",
"Region",
"Latitude",
"Longitude",
"SubRegion",
"Acres"
],
"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": [
{
"defaultValue": "\"FALSE\"",
"name": "IsAgency",
"saqlExpression": "case when 'Phone' is not null then \"TRUE\" else \"FALSE\" end",
"label": "IsAgency",
"type": "Text"
}
]
}
}
}
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, alias, and required fields.
"Create Seed Bank Agencies": {
Delete"action": "sfdcRegister",
"parameters": {
"name": "seedbankagencies",
"alias": "seedbankagencies",
"source": "Filter Agency Records"
- This has incorrect syntax.
Hi . I am also doing 3rd step but getting the following error
ReplyDelete""Challenge Not yet complete... here's what's wrong:
We can't find a filter on Account Name. ""
Please help me.
What filter do you have in place right now?
DeleteI'm encountering the same error "Challenge Not yet complete... here's what's wrong:
DeleteWe can't find a filter on Account Name." and cannot figure out what I am doing wrong. Below is my 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": "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",
"SubRegion",
"Longitude",
"Latitude",
"Region"
],
"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"
}
]
}
}
}
Create Seed Bank Agencies": {
Delete"action": "sfdcRegister",
"parameters": {
"name": "Seed Bank Agencies",
"alias": "seed_bank_agencies",
"source": "Filter Agency Records"
* wrong alias *
"left": "Load Account",
"left_key": [
"AccountNumber"
],
"right_select": [
"Acres",
"Currency",
"SubRegion",
"Longitude",
"Latitude",
"Region"
* You are missing something in "right select" *
I am getting this error
ReplyDelete"Challenge Not yet complete... here's what's wrong:
We can't confirm you found the correct values. Please check your work. "
Please help me, here is my JSON
{
"Filter Agency Records": {
"action": "filter",
"parameters": {
"filter": "IsAgency:EQ:TRUE",
"source": "ID Agency Records"
}
},
"Load Agent Detail": {
"action": "edgemart",
"parameters": {
"alias": "Agency_Detail"
}
},
"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": [
"AccountNumber",
"Acres",
"Currency",
"Latitude",
"Longitude",
"Region",
"SubRegion"
],
"right": "Load Agent Detail",
"relationship": "AgencyDetail",
"operation": "LookupSingleValue"
}
},
"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"
}
]
}
}
}
"Create Seed Bank Agencies": {
Delete"action": "sfdcRegister",
"parameters": {
"name": "Seed Bank Agencies",
"alias": "seed_bank_agencies",
"source": "Filter Agency Records"
Wrong Alias Name.
Hi,
DeleteActually i am confused, your reply - " Wrong Alias Name " . Then what is the correct Alias Name??
It's should be - " seed_bank_agencies" right?
No. The alias name should be something else
DeleteHi, I keep getting the error message: "Challenge Not yet complete... here's what's wrong:
DeleteWe can't find the 'Load Seed Bank Agencies' dataflow. Confirm the dataflow matches the name as described in the challenge."
Can you please help? I loaded Agency Detail dataset, then created dataflow "Load Seed Bank Agencies" but I keep getting it... Can you advise what do I do wrong? Below is my 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": [
"Currency",
"Region",
"SubRegion",
"Latitude",
"Acres",
"Longitude",
"AccountNumber"
],
"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"
}
]
}
}
}
If you go to the data manager, can you confirm that the API name for this is Load_Seed_Bank_Agencies ? Look at the left next to the dataflow under "Not Scheduled"
DeleteThe think is that this name is "Load_Seed_Bank_Agencies2422". I thought it might be a problem but I don't know how to change this name. I tried to remove this Dataflow and do it all over again from the scratch but it didn't work.
DeleteIs there a way to change this name?
You should be able to change the Alias directly on the dataflow- It's an editable field
DeleteWhich place exactly? When I click edit I cannot see the possibility to change alias name...
DeleteIf you can't find it from googling- I'd just save the JSON, delete the old one, empty the recycle bin.... give it 24 hours then recreate it.
DeleteChallenge Not yet complete... here's what's wrong:
DeleteWe can't find the 'Load Seed Bank Agencies' dataflow. Confirm the dataflow matches the name as described in the challenge.
Im also having the same issue, please help me with this!!
API name : Load_Seed_Bank_Agencies
The API name of the data flow is correct. I suspect that the final node's alias is not correct... is it seed_bank_agencies ?
DeleteHello Trailhead Baby,
DeleteI've got the same issue as Sandy there and I've checked all api_name. Is there any issue with my Json I did'nt seen ?
{
"Filter Agency Records": {
"action": "filter",
"parameters": {
"source": "ID Agency Records",
"saqlFilter": "IsAgency==\"TRUE\""
}
},
"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": [
"AccountNumber",
"Acres",
"Currency",
"Latitude",
"Longitude",
"Region",
"SubRegion"
],
"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 \nwhen Phone is not null then \"TRUE\" \nelse \"FALSE\" \nend",
"label": "IsAgency",
"type": "Text"
}
]
}
},
"Load Agency Detail": {
"action": "edgemart",
"parameters": {
"alias": "Load_Agency_Detail"
}
}
}
Thanks a lot in advance for your help !
"Load Agency Detail": {
Delete"action": "edgemart",
"parameters": {
"alias": "Load_Agency_Detail"
}
I have a different Alisa here
Hi Trailhead baby,
ReplyDeleteI am stuck in Challenge 3.
I am having issues with the populating records in Seed Bank Agencies dataset. Please find below screenshot:
If you notice the Filter Agency Records is not able to populate the result
The JSON is
{
"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"
}
]
}
}
}
"right_select": [
Delete"Acres",
"Currency",
"Latitude",
"Longitude",
"Region",
"SubRegion"
I'd bet that this is the issue. Add "Account Number"
Thank you for looking into this. I created a new org and the same json worked.
DeleteHello,
ReplyDeleteI have tried all the steps mentioned in your blog. Am still getting this "We can't find Agency records in the Account object." error. please help
I'm getting the following error. Please let me know if im missing anything -
ReplyDeleteChallenge 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, alias, and required fields.
{
"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": [
{
"saqlExpression": "case when Phone is not null then \"TRUE\" else \"FALSE\" end",
"name": "IsAgency",
"label": "IsAgency",
"type": "Text"
}
]
}
}
}
"right_select": [
Delete"Acres",
"Currency",
"Latitude",
"Longitude",
"Region",
"SubRegion"
Something is missing.
I am going crazy trying to figure out what I am doing wrong. I am Step #3 Create Seed Bank Agencies and receiving the message:
ReplyDeleteChallenge Not yet complete... here's what's wrong:
We can't find a filter on Account Name.
I checked the json and it appears to be correct and also deleted and recreated the dataflow. The dataflow saved without any issues and therefore ran the dataflow and received the message:
"Something went wrong while executing the ID Agency Records node: invalid field expression for field 'IsAgency': Syntax Error at position [line 1: column 10] after token when :: ;Case when Phone is not ; (02K6g000000dZ3dEAE_03C6g0000019TNvEAM).
I verified I do have AgencyDetail listed for the Relationship in the augment portion of the dataflow.
If there is anything obvious that I am missing, please let me know.
Thanks!
What "type" is your SAQL expression? If it is not "text", I'd bet that this is the problem.
DeleteIt is set to text.
Deleteand the SAQL Expression is:
Case when Phone is not null then "TRUE" else "FALSE" end
Thanks!
I figured it out...I had the word "Case" capitalized. Made it lower case and the dataflow did run but with warnings on Add Agency Fields:
DeleteThe 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 still receiving the following message when checking Challenge 3:
Challenge Not yet complete... here's what's wrong:
We can't find a filter on Account Name.
Thanks!
Karen
hmmmmm Did you make sure that Account Number is included on the right fields? An error that I've seen a few times is doing the join based off of the Account Number but not including it in the fields.
DeleteI believe so, but here is my JSON:
Delete{
"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": "AgencyDetails",
"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"
}
]
}
}
}
Also, I did make sure that Use SAQL is unchecked. It is a puzzler to me.
Thanks,
Karen
I also did update the Add Agency Fields to include Account Number and did update the dataflow. I then ran the dataflow and still received the same message:
DeleteThe 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 thought adding Account Number to the right fields in that dataflow step would make a difference, but oh well.
I am happy to report I finally passed Challenge 3!
DeleteI created a new developer org and just started over from scratch and it worked.
I figured after 2 days and nothing seemed out of place, just to start over and see if that works and it did.
Thank you so much for assisting!
Karen
Awesome!!!
DeleteHi, I am doing 3rd step but getting the following error
ReplyDelete""Challenge Not yet complete... here's what's wrong:
We can't find a filter on Account Name. ""
Below 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"
}
}
}
Thanks in Advance.
],
Delete"right_select": [
"Acres",
"Currency",
"Latitude",
"Longitude",
"Region",
"SubRegion"
This is going to cause issues as you are missing something crucial... You can't match accounts based on a field that isn't included. And the Alias on one of your steps is not correct.
I ran into similar issues like most addressed above, and after hours of digging and losing my mind, the issue seemed to be the 'Case' word in the SOQL expression, the C needs to be lower case...i.e. 'case'....that solved my issue!
ReplyDeleteThanks!! I was losing my mind too.
DeleteHi
ReplyDeleteOn challenge 3, i am receing error as
Challenge Not yet complete... here's what's wrong:
We can't find a filter on Account Name.
PFB the JSON:
{
"Load Account":{
"action":"sfdcDigest",
"parameters":{
"fields":[
{
"name":"AccountNumber"
},
{
"name":"Name"
},
{
"name":"ShippingCity"
},
{
"name":"ShippingCountry"
},
{
"name":"ShippingState"
},
{
"name":"ShippingStreet"
},
{
"name":"ShippingPostalCode"
},
{
"name":"Phone"
}
],
"object":"Account"
}
},
"Filter Agency Record":{
"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":"Filter Agency Record"
}
},
"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":[
{
"defaultValue":"FALSE",
"name":"isAgency",
"saqlExpression":"case when Phone is not null then \"TRUE\" else \"FALSE\" end",
"label":"isAgency",
"type":"Text"
}
]
}
}
}
I am even tried to create a new Org and re perform the steps but same error is being shown up again.
My dataflow ran succesfully. I created a New lens and added Account Name as Bar and descending oder of Count of Rows. Am i missing something here in the lens, because of which i am receing this error?
Kindly help!
"right_select":[
Delete"Acres",
"Currency",
"Latitude",
"Longitude",
"Region",
"SubRegion"
A problem is seen in the above- You can't match on a field that doesn't exist in the data set
Hi Trailhead Baby! I have combed through all of this thread and still can't get Challenge 3 to work. Been working on this all day and struggling!!! Below is my error. Can I send you my JSON for you to take a quick look?
ReplyDeleteChallenge 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, alias, and required fields.
Thanks!
AJ
Hi Trailhead Baby! I have combed through all of this thread and still can't get Challenge 3 to work. Been working on this all day and struggling!!! Below is my error. Can I send you my JSON for you to take a quick look?
ReplyDeleteChallenge 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, alias, and required fields.
Thanks!
AJ
Drop the JSON in a comment or drop it to rebecca@capstorm.com and I'll take a peek.
DeleteThis challenge is SUPER finiky with names.
Hi Rebecca,
DeleteI am also facing the below error. can u please help me ASAP. Is this anything related to the previous step?
We can't validate the 'Create Seed Bank Agencies' node was created correctly. Check the required fields, field types, node name, and alias are correct.
Below 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": "ShippingPostalCode"
},
{
"name": "ShippingState"
},
{
"name": "ShippingStreet"
},
{
"name": "ShippingCountry"
},
{
"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": [
"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": [
{
"defaultValue": "\"FALSE\"",
"name": "IsAgency",
"saqlExpression": "case when 'Phone' is not null then \"TRUE\" else \"FALSE\" end",
"label": "IsAgency",
"type": "Text"
}
]
}
}
}
This is CRAZY!!! I am getting the right data in the right format and still not passing. Wasted an entire day on this.
ReplyDeleteAnyone have an idea how to combat banging head off the wall 500 times in a day for this stuff?
Still not passing Step 3!!!
Let's see that Json :)
DeleteHi Trailhead Baby,
ReplyDeleteI am stucked also in this error when checking the step 3:
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, alias, and required fields.
I have already checked the syntax everywhere and confirm that the datasets are saved in the correct app.
I am posting my JSON from the dataflow below. If someone can spot the error I will be very grateful. I am stucked on this for 2 days -.-
Thank you!
{
"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",
"Latitude",
"Currency",
"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": [
{
"defaultValue": "1",
"precision": 10,
"name": "IsAgency",
"saqlExpression": "case when Phone is not null then \"TRUE\" else \"FALSE\" end",
"label": "IsAgency",
"type": "Text"
}
]
}
}
}
Look at the Add Agency fields step. You can't match on a field if the field is not selected in both data sets.
DeleteHi Trailhead Baby,
DeleteI tried to add the AccountNumber as I read above in this thread but it still gives me the same error :(
Try leaving these as blank:
DeletedefaultValue": "1",
"precision": 10,
Hi Trailhead Baby,
ReplyDeleteI have tried all possible way to fix the error, but no luck. Your hep would be really appreciated!
Thanks in advance!
The error is, "Challenge Not yet complete... here's what's wrong:
We can't find a filter on Account Name." .
Please find my json file,
{
"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": "CreateSeedBankAgencies",
"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"
}
]
}
}
}
Look at where you "add agency fields." You can not match on a field that is not selected / included in both data sets.
DeleteHi @trailhead Baby, its evident from the above json that I am trying to match account number and account number is available in both data sets. Could you kindly explain the above comment, please?
DeleteAccount number is not in both data sets per the Json you provided.
DeleteHelp please! I keep getting the error "Challenge Not yet complete... here's what's wrong:
ReplyDeleteWe can't find a filter on Account Name."
{
"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": "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"
}
]
}
}
}
you are missing a field- You can't augument without both matching fields in both data sets.
DeleteGetting error
ReplyDeleteWe can't find a filter on Account Name.
{
"Load Account": {
"action": "sfdcDigest",
"parameters": {
"fields": [
{
"name": "AccountNumber"
},
{
"name": "Name"
},
{
"name": "Phone"
},
{
"name": "ShippingCity"
},
{
"name": "ShippingCountry"
},
{
"name": "ShippingState"
},
{
"name": "ShippingStreet"
},
{
"name": "ShippingPostalCode"
}
],
"object": "Account"
}
},
"Load Agency Detail": {
"action": "edgemart",
"parameters": {
"alias": "Agency_Detail"
}
},
"Add Agency Fields": {
"action": "augment",
"parameters": {
"operation": "LookupSingleValue",
"left": "Load Account",
"relationship": "AgencyDetail",
"right": "Load Agency Detail",
"left_key": [
"AccountNumber"
],
"right_key": [
"AccountNumber"
],
"right_select": [
"Acres",
"Currency",
"Latitude",
"SubRegion",
"Region",
"Longitude"
]
}
},
"ID Agency Records": {
"action": "computeExpression",
"parameters": {
"mergeWithSource": true,
"source": "Add Agency Fields",
"computedFields": [
{
"type": "Text",
"name": "IsAgency",
"label": "IsAgency",
"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"
}
},
"Seed Bank Agencies": {
"action": "sfdcRegister",
"parameters": {
"source": "Filter Agency Records",
"alias": "seed_bank_agencies",
"name": "CreateSeedBankAgencies"
}
}
}
Look at your Augument step. You are missing a key field.
DeleteHi,
ReplyDeleteGetting Following error in challenge 3:
"We can't find a filter on Account Name."
{
"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": "CreateSeedBankAgencies",
"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",
"Region",
"SubRegion",
"Latitude",
"Acres",
"Longitude"
],
"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"
}
]
}
}
}
Already tried multiple things to make changes in augment section.
Can you please help me with this?
Thank you in advance.
Add Agency Fields": {
Delete"action": "augment",
"parameters": {
"right_key": [
"AccountNumber"
],
"left": "Load Account",
"left_key": [
"AccountNumber"
],
"right_select": [
"Currency",
"Region",
"SubRegion",
"Latitude",
"Acres",
"Longitude"
- You can not match on a field that does not exist in both data sets. (A field that you need was not selected)
Dhamendra Mishra
ReplyDeleteI am facing issue in challenge#3. Followed all the step mentioned in the challenge ; but still not able to pass the challenge . Below is the JSON can I have a second eye on the JSON.
{
"Load Account": {
"action": "sfdcDigest",
"parameters": {
"fields": [
{
"name": "Name"
},
{
"name": "AccountNumber"
},
{
"name": "Phone"
},
{
"name": "ShippingCity"
},
{
"name": "ShippingCountry"
},
{
"name": "ShippingState"
},
{
"name": "ShippingStreet"
},
{
"name": "ShippingPostalCode"
}
],
"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": [
"AccountNumber",
"Acres",
"Currency",
"Latitude",
"Longitude",
"Region",
"SubRegion"
]
}
},
"ID Agency Records": {
"action": "computeExpression",
"parameters": {
"mergeWithSource": true,
"source": "Add Agency Fields",
"computedFields": [
{
"type": "Text",
"name": "IsAgency",
"label": "IsAgency",
"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"
}
}
}
It's showing
Challenge Not yet complete... here's what's wrong:
We can't confirm you found the correct values. Please check your work.
Close errors
Any help.
My saql for "Is agency" is slightly different.
DeleteHi ,
ReplyDeletei am getting below error on challenge #3
Challenge Not yet complete... here's what's wrong:
We can't find a filter on Account Name.
PFB 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": "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": [
"AccountNumber",
"Acres",
"Currency",
"Latitude",
"Longitude",
"Region",
"SubRegion"
],
"right": "Load Agency Detail",
"relationship": "AgencyDetails",
"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"
}
]
}
}
}
"saqlExpression": "case when Phone is not null then \"TRUE\" else \"FALSE\" end",
DeleteI have something a tiny bit different.
I am getting error like " Challenge Not yet complete... here's what's wrong:
ReplyDeleteWe can't find Agency records in the Account object" when i check challenge #3 .
i rechecked my relation ship name in add agency fields which is "AgencyDetail" but i still get the same error any pointers? really struck on this from quote some time now!
This comment has been removed by the author.
Deletejust went through the blog, made couple of changes to create seed band agencies node, tried alternative for relatives filed node but the same old error again, tried adding the same process with another new org no luck, there one post which says delete whole agency data and re create it again i will try that once and come back if the same issue persist. posting updated json
Delete{
"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": {
"name": "Create 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": [
"Acres",
"Currency",
"Latitude",
"Longitude",
"SubRegion",
"Region"
]
}
},
"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"
}
]
}
}
}
The issue on "Add Agency Fields" stands out on first glance
Deletethank you so much , i got that extra filed which we need to add at add agency fields, i was banging my head for what went wrong from one of your comments for agency fileds i got to know to add extra filed and it passed ! :D
DeleteTried very hard to crack the Challenge#3. Created so many revisions and didn't find any issue in data flow.
ReplyDeleteFinally found the issue after going through this thread.
I am getting this Error :
Couldn’t find 'Create Seed Bank Agencies' node. Please check the name and alias spelling.
Problem is:
"When I am creating the Agency Details dataset from external file, Changed the field attributes for the fields Longitude and Latitude from Measure to Dimension."
I re created this step without changing the filed attributes. Then I cleared the challenge #3 and #4 and #5.
Thank you guys.
I have been trying this challenge for so long not able to understand where is the issue..
ReplyDelete"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": {
"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"
}
]
}
}
}
Could anybody please help out. I have been trying for last 3 days without any luck.
Thanks in advance.
"Load Agency Detail": {
Delete"action": "edgemart",
"parameters": {
"alias": "agency_detail"
Capitalization.
Thanks for your reply..I corrected that but no luck,
Delete{
"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"
}
},
"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"
}
]
}
}
}
I am still not able to understand where is the issue in the Data Flow.
Delete"saqlExpression": "case when Phone is not null then \"TRUE\" else \"FALSE\" end",
Delete* something is missing at the end of this saql*
Thanks for your reply. I was doing a silly mistake. Now I have cleared the challenge and the Superbadge also.
DeleteAfter many attempts still encountering same issue.
DeleteChallenge Not yet complete... here's what's wrong:
We can't find a filter on Account Name.
Below 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": "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": {
"left": "Load Account",
"right": "Load Agency Detail",
"relationship": "AgencyDetail",
"operation": "LookupSingleValue",
"left_key": [
"AccountNumber"
],
"right_key": [
"AccountNumber"
],
"right_select": [
"Acres",
"Latitude",
"Currency",
"Longitude",
"Region",
"SubRegion"
]
}
},
"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"
}
]
}
}
}
"Add Agency Fields": {
Delete"action": "augment",
"parameters": {
"left": "Load Account",
"right": "Load Agency Detail",
"relationship": "AgencyDetail",
"operation": "LookupSingleValue",
"left_key": [
"AccountNumber"
],
"right_key": [
"AccountNumber"
],
"right_select": [
"Acres",
"Latitude",
"Currency",
"Longitude",
"Region",
"SubRegion"
The problem is in here.
May I know what is the problem you mean here
DeleteHello,
ReplyDeleteFor me, at step 3, dataflow is running fine but when I am going to create a lens for that dataset, no results are showing up there.
Chart is empty there.
My 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": {
"left": "Load Account",
"right": "Load Agency Detail",
"relationship": "AgencyDetail",
"operation": "LookupSingleValue",
"left_key": [
"AccountNumber"
],
"right_key": [
"AccountNumber"
],
"right_select": [
"Currency",
"Region",
"SubRegion",
"Latitude",
"Acres",
"Longitude",
"AccountNumber"
]
}
},
"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 help.
There is a mistake in this expression:
DeletesaqlExpression": "\"case when Phone is not null then \\\"TRUE\\\" else \\\"FALSE\\\" end\"",
This comment has been removed by the author.
ReplyDeleteI am getting below error:
ReplyDeleteChallenge Not yet complete... here's what's wrong:
We can't find a filter on Account Name.
Please let me know as soon as you can.
Help is much appriciated.
I have Account Number mapped both the sides as well taken in right_select:
{
"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"
}
},
"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": [
"Currency",
"Region",
"SubRegion",
"Latitude",
"Acres",
"Longitude",
"AccountNumber"
]
}
},
"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 found the issue its solved.
DeletePlease ignore above JSON.
Good to hear!
Delete@VIPUL Can you please share your solution. I am also facing the same issue.
DeleteLook in this:
Delete"name": "IsAgency",
"saqlExpression": "case when Phone is not null then \"TRUE\" else \"FALSE\" end",
"label": "IsAgency",
"type": "Text"
}
Challenge Not yet complete... here's what's wrong:
ReplyDeleteWe can't find a filter on Account Name.
I am using this json :
{
"Filter Agency Records": {
"action": "filter",
"parameters": {
"source": "ID Agency Records",
"filter": "IsAgency:EQ:TRUE"
}
},
"Load Account": {
"action": "sfdcDigest",
"parameters": {
"fields": [
{
"name": "AccountNumber"
},
{
"name": "Name"
},
{
"name": "Phone"
},
{
"name": "ShippingCity"
},
{
"name": "ShippingCountry"
},
{
"name": "ShippingPostalCode"
},
{
"name": "ShippingStreet"
},
{
"name": "ShippingState"
}
],
"object": "Account"
}
},
"Create Seed Bank Agencies": {
"action": "sfdcRegister",
"parameters": {
"name": "SeedBankAgencies",
"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": [
"Currency",
"Region",
"SubRegion",
"Latitude",
"Acres",
"Longitude",
"AccountNumber"
]
}
},
"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"
}
]
}
}
}
Incorrect SAQL:
Delete{
"name": "IsAgency",
"saqlExpression": "case when Phone is not null then \"TRUE\" else \"FALSE\" end",
"label": "IsAgency",
"type": "Text"
Challenge Not yet complete... here's what's wrong:
ReplyDeleteWe can't find a filter on Account Name.
Your Help is much appriciated.
I am using this json :
{
"Filter Agency Records": {
"action": "filter",
"parameters": {
"source": "ID Agency Records",
"filter": "IsAgency:EQ:TRUE"
}
},
"Load Account": {
"action": "sfdcDigest",
"parameters": {
"fields": [
{
"name": "AccountNumber"
},
{
"name": "Name"
},
{
"name": "Phone"
},
{
"name": "ShippingCity"
},
{
"name": "ShippingCountry"
},
{
"name": "ShippingPostalCode"
},
{
"name": "ShippingStreet"
},
{
"name": "ShippingState"
}
],
"object": "Account"
}
},
"Create Seed Bank Agencies": {
"action": "sfdcRegister",
"parameters": {
"name": "SeedBankAgencies",
"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": [
"Currency",
"Region",
"SubRegion",
"Latitude",
"Acres",
"Longitude",
"AccountNumber"
]
}
},
"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"
}
]
}
}
}
Sorry, I could not understand your answer.
ReplyDeleteCan you please hint about correct SAQL:
here I am using
"saqlExpression": "case when Phone is not null then \"TRUE\" else \"FALSE\" end",
https://developer.salesforce.com/docs/atlas.en-us.bi_dev_guide_saql.meta/bi_dev_guide_saql/bi_saql_quotedstringescapes.htm
DeleteHi,
ReplyDeleteI Have read almost each and every comment on this blog regarding the error
"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, alias, and required fields.
3"
And in spite of correcting everything, i am still hitting this error. Pasting my Json below, request you to please help out.
i tried keeping Alias name for Register node as - "create_seed_bank_agencies" As well as tried with "seed_bank_agencies" still no luck, Final Json pasted below.
{
"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": "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"
}
]
}
}
}
"Add Agency Fields": {
Delete"action": "augment",
"parameters": {
"right_key": [
"AccountNumber"
],
"left": "Load Account",
"left_key": [
"AccountNumber"
],
"right_select": [
"Acres",
"Currency",
"Latitude",
"Longitude",
"Region",
"SubRegion"
],
Double check this node.
My Dataflow is running successfully but no records are coming in "Seed Bank Agencies" Dataset and am not able to create lens due to empty dataset. Here is my JSON. Please help.
Delete{
"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": {
"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",
"SubRegion",
"Region",
"Latitude",
"Longitude",
"Currency",
"Acres"
],
"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"
}
]
}
}
}
check saql:
Delete"name": "IsAgency",
"saqlExpression":
"case when Phone is not null then \"TRUE\" else \"FALSE\" end",
"label": "IsAgency",
"type": "Text"
Hi,
ReplyDeleteMay you please help me figure out what the issue is. I have tried re-doing the dataflow multiple times and in different orgs but keep getting this error:
We can't validate the 'Create Seed Bank Agencies' node was created correctly. Check the required fields, field types, node name, and alias are correct.
Please see below for my JSON. Thank you for your help!
{
"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": {
"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": "AgencyDetails",
"operation": "LookupSingleValue",
"left_key": [
"AccountNumber"
],
"right_key": [
"AccountNumber"
],
"right_select": [
"Acres",
"Currency",
"Latitude",
"Longitude",
"Region",
"SubRegion"
]
}
},
"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
I am also facing this issue, tried everything mentioned here. Nothing worked.
DeletePlease help.
Hi - I was finally able to clear this step! Please make sure that when you upload your Agency Detail dataset that the Longitude and Latitude are dimensions NOT measures.
Delete},
Delete"Add Agency Fields": {
"action": "augment",
"parameters": {
"left": "Load Account",
"right": "Load Agency Detail",
"relationship": "AgencyDetails",
"operation": "LookupSingleValue",
"left_key": [
"AccountNumber"
],
"right_key": [
"AccountNumber"
],
"right_select": [
"Acres",
"Currency",
"Latitude",
"Longitude",
"Region",
"SubRegion"
]
This is also an issue. You can't match off a field that isn't specified in both data sets .
Thanks for your blog. I checked for the node names and also checked whether the rows are getting populated or not in both Seed Bank Agencies & Seed Bank datasets. They seem to be alright.
DeleteEven after repeated attempts - I am not able to clear the error in Step 6.
Challenge Not yet complete... here's what's wrong:
We can't validate the 'Create Seed Bank Agencies' node was created correctly. Check the required fields, field types, node name, and alias are correct.
Please refer to the screens of datasets & dataflows for your reference on the following link: https://success.salesforce.com/answers?id=9064V000000aK5gQAE
Kindly check and let me know - where I am possibly going wrong? Thanks for your help.
I don't see the node name in the success community post. Please post the json for the "create seed bank agencies" node here and I'll take a look
DeletePlease check below:
Delete"Create Seed Bank Agencies": {
"action": "sfdcRegister",
"parameters": {
"name": "Seed Bank Agencies",
"alias": "seed_bank_agencies",
"source": "Augment TempClass"
}
},
Check node name. I suggest "Create Seed Bank Agencies" with the same alias that you have now....
DeleteI am still getting the same error. I also tried deleted the data flows, lenses and created them afresh.
DeleteThis comment has been removed by the author.
ReplyDeleteHi Author,
ReplyDeleteI tried doing all the changes mentioned but unable to complete the challenge below is the Error
Challenge Not yet complete... here's what's wrong:
We can't validate the 'Create Seed Bank Agencies' node was created correctly. Check the required fields, field types, node name, and alias are correct.
{
"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": {
"left": "Load Account",
"right": "Load Agency Detail",
"relationship": "AgencyDetail",
"operation": "LookupSingleValue",
"left_key": [
"AccountNumber"
],
"right_key": [
"AccountNumber"
],
"right_select": [
"Currency",
"Region",
"SubRegion",
"Latitude",
"Acres",
"Longitude",
"AccountNumber"
]
}
},
"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,
ReplyDeleteI am also getting the same error, tried all above things but didnt work-
"We can't validate the 'Create Seed Bank Agencies' node was created correctly. Check the required fields, field types, node name, and alias are correct."
I tried account number in right select, still it didnt work.
Following is the 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": "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": {
"left": "Load Account",
"right": "Load Agency Detail",
"relationship": "AgencyDetail",
"operation": "LookupSingleValue",
"left_key": [
"AccountNumber"
],
"right_key": [
"AccountNumber"
],
"right_select": [
"Currency",
"Region",
"SubRegion",
"Latitude",
"Acres",
"Longitude"
]
}
},
"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"
}
]
}
}
}
Check this:
DeletesaqlExpression": "case when Phone is not null then \"TRUE\" else \"FALSE\" end",
Hey, I am facing Challenge Not yet complete... here's what's wrong:
ReplyDeleteWe can't validate the 'Create Seed Bank Agencies' node was created correctly. Check the required fields, field types, node name, and alias are correct. issue
Share some details, and I'm happy to take a look!
DeleteHi Trailhead Baby,
ReplyDeleteI am also facing the same error.
Challenge Not yet complete... here's what's wrong:
We can't validate the 'Create Seed Bank Agencies' node was created correctly. Check the required fields, field types, node name, and alias are correct.
Below is the json from my org.
{
"Load Account": {
"action": "sfdcDigest",
"parameters": {
"fields": [
{
"name": "AccountNumber"
},
{
"name": "Name"
},
{
"name": "ShippingCity"
},
{
"name": "ShippingCountry"
},
{
"name": "ShippingPostalCode"
},
{
"name": "ShippingState"
},
{
"name": "Phone"
},
{
"name": "ShippingStreet"
}
],
"object": "Account"
}
},
"Load Agency Detail": {
"action": "edgemart",
"parameters": {
"alias": "Agency_Detail"
}
},
"Add Agency Fields": {
"action": "augment",
"parameters": {
"operation": "LookupSingleValue",
"left": "Load Account",
"relationship": "AgencyDetail",
"right": "Load Agency Detail",
"left_key": [
"AccountNumber"
],
"right_key": [
"AccountNumber"
],
"right_select": [
"Currency",
"Region",
"SubRegion",
"Latitude",
"Acres",
"Longitude",
"AccountNumber"
]
}
},
"ID Agency Records": {
"action": "computeExpression",
"parameters": {
"mergeWithSource": true,
"source": "Add Agency Fields",
"computedFields": [
{
"type": "Text",
"name": "IsAgency",
"label": "IsAgency",
"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": {
"source": "Filter Agency Records",
"alias": "seed_bank_agencies",
"name": "Seed Bank Agencies"
}
}
}
Check your json:
Delete"type": "Text",
"name": "IsAgency",
"label": "IsAgency",
"saqlExpression": "case when Phone is not null then \"TRUE\" else \"FALSE\" end"
SAQL- not Json :)
DeleteI have made the changes as below.
Delete"ID Agency Records": {
"action": "computeExpression",
"parameters": {
"source": "Add Agency Fields",
"mergeWithSource": true,
"computedFields": [
{
"name": "IsAgency",
"saqlExpression": "case when Phone is null then \"FALSE\" else \"TRUE\" end",
"label": "IsAgency",
"type": "Text"
}
]
}
}
does it sill have error then please let me know what is the error and what should be the correct one.
SAQL is wrong: "name": "IsAgency",
Delete"saqlExpression": "case when Phone is null then \"FALSE\" else \"TRUE\" end",
"label": "IsAgency",
"type": "Text"
This comment has been removed by the author.
ReplyDeleteHi Trailhead Baby,
ReplyDeleteI am also facing the same error.
Challenge Not yet complete... here's what's wrong:
We can't validate the 'Create Seed Bank Agencies' node was created correctly. Check the required fields, field types, node name, and alias are correct. i have tried in multiple orgs still same error. please find below my json. please suggest .
{
"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": [
"Currency",
"Region",
"SubRegion",
"Latitude",
"Acres",
"Longitude",
"AccountNumber"
],
"right": "Load Agency Detail",
"relationship": "AgencyDetail",
"operation": "LookupSingleValue"
}
},
"Load Agency Detail": {
"action": "edgemart",
"parameters": {
"alias": "Agency_Detail1"
}
},
"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"
}
]
}
}
}
Hello Trailhead Baby,
ReplyDeleteI am stuck since 2 days on this step 3.
Error : We can't validate the 'Create Seed Bank Agencies' node was created correctly. Check the required fields, field types, node name, and alias are correct.
I've read all the comment, check that everything is in the right app and still can't find where is the issue.
Can you help me please ? Thank you !
{
"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"
}
},
"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": [
"Currency",
"Region",
"SubRegion",
"Latitude",
"Acres",
"Longitude",
"AccountNumber"
]
}
},
"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"
}
]
}
},
"Create Seed Bank Agencies": {
"action": "sfdcRegister",
"parameters": {
"source": "Filter Agency Records",
"alias": "seed_bank_agencies",
"name": "Seed Bank Agencies"
}
}
}
I've deleted to first node with Agency Detail, changed the longitude and latitude from measure to dimension in the dataset, created the node again and passed the challenge.
DeleteGood to hear!
DeleteHello,
ReplyDeleteI have read the coments, and yet cannot see what is wrong with my JSON.
would you please point out what you believe to be an anomalie : (I am losing my mind over this! )
the error I get is this :
Challenge Not yet complete... here's what's wrong:
We can't validate the 'Create Seed Bank Agencies' node was created correctly. Check the required fields, field types, node name, and alias are correct.
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": "ShippingPostalCode"
},
{
"name": "ShippingState"
},
{
"name": "ShippingStreet"
}
],
"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",
"SubRegion",
"Region",
"Latitude",
"Longitude"
],
"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": [
{
"saqlExpression": "case \nwhen Phone is not null then \"True\"\nelse \"False\" \nend",
"name": "IsAgency",
"label": "IsAgency",
"type": "Text"
}
]
}
}
}
In advance, thank you for your time.
},
Delete"Add Agency Fields": {
"action": "augment",
"parameters": {
"right_key": [
"AccountNumber"
],
"left": "Filter Agency Records",
"left_key": [
"AccountNumber"
],
"right_select": [
"Currency",
"Acres",
"SubRegion",
"Region",
"Latitude",
"Longitude"
Add in another field... It's hard to match if the field does not exist in both data sets.
{
"saqlExpression": "case \nwhen Phone is not null then \"True\"\nelse \"False\" \nend",
My SAQL is slightly different.
hello, Trailhead Baby,
Deletethank you for your quick reply.
I changed lat and long from measures to dimensions in agency detail and it worked.
thank you again for your time,
Interesting! I am glad that it worked!
DeleteHi Trailhead Baby,
ReplyDeleteFor step #6 : I am getting below error trying from more than week but no luck.
Challenge Not yet complete... here's what's wrong:
We can't find the 'Create Seed Bank Agencies' node or required fields, such as 'TempClass', are missing. Check the challenge and confirm the node name and required fields.
{
"Add Temp Class": {
"action": "computeExpression",
"parameters": {
"computedFields": [
{
"label": "TempClass",
"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",
"type": "Text"
}
],
"mergeWithSource": true,
"source": "Define Temp Range"
}
},
"Augment TempClass": {
"action": "augment",
"parameters": {
"left": "Add Temp Class",
"left_key": [
"TempClass"
],
"operation": "LookupMultiValue",
"relationship": "Climate",
"right": "Load TempClass Mapping",
"right_key": [
"TempKey"
],
"right_select": [
"TempClass",
"TempKey"
]
}
},
"Calculate Acreage": {
"action": "computeExpression",
"parameters": {
"computedFields": [
{
"label": "Acreage",
"name": "Acreage",
"precision": 18,
"saqlExpression": "(Seeds_Pound*Spacing)/6272640",
"scale": 6,
"type": "Numeric"
}
],
"mergeWithSource": true,
"source": "Load Seed Chart"
}
},
"CleanUp": {
"action": "sliceDataset",
"parameters": {
"fields": [
{
"name": "highTemp"
},
{
"name": "lowTemp"
},
{
"name": "Climate.TempKey"
},
{
"name": "TempClass"
}
],
"mode": "drop",
"source": "Augment TempClass"
}
},
"Create Seed Bank": {
Delete"action": "sfdcRegister",
"parameters": {
"alias": "seed_bank",
"name": "Seed Bank",
"source": "CleanUp"
}
},
"Define Temp Range": {
"action": "computeExpression",
"parameters": {
"computedFields": [
{
"defaultValue": "0",
"label": "lowTemp",
"name": "lowTemp",
"precision": 18,
"saqlExpression": "string_to_number(substr(Temperature,1,2))",
"scale": 2,
"type": "Numeric"
},
{
"defaultValue": "0",
"label": "highTemp",
"name": "highTemp",
"precision": 18,
"saqlExpression": "string_to_number(substr(Temperature,-2,2))",
"scale": 2,
"type": "Numeric"
}
],
"mergeWithSource": true,
"source": "Calculate Acreage"
}
},
"Load Seed Chart": {
"action": "edgemart",
"parameters": {
"alias": "Seed_Chart"
}
},
"Load TempClass Mapping": {
"action": "edgemart",
"parameters": {
"alias": "Temperature_Classes_Mapping"
}
}
}
Hi,
ReplyDeleteCan someone please help me, my validation keeps giving the following erorr;
"Challenge Not yet complete... here's what's wrong:
We can't validate the 'Create Seed Bank Agencies' node was created correctly. Check the required fields, field types, node name, and alias are correct."
I've done everything correctly I guess and have incorporated everything discussed here still getting the same error.
JSON;
{
"Load Account": {
"action": "sfdcDigest",
"parameters": {
"fields": [
{
"name": "Name"
},
{
"name": "AccountNumber"
},
{
"name": "Phone"
},
{
"name": "ShippingCity"
},
{
"name": "ShippingCountry"
},
{
"name": "ShippingState"
},
{
"name": "ShippingStreet"
},
{
"name": "ShippingPostalCode"
}
],
"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": [
{
"type": "Text",
"name": "IsAgency",
"label": "IsAgency",
"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"
}
}
}
Nevermind, solved it. Latitude/Long was the problem. Thanks
ReplyDeleteI've been thru this whole post (multiple times). I suspect my issue is my SAQL expression in the ID Agency Records node based on responses above but the dataflow runs fine and I'm able to create the Lens correctly. However, I'm still getting the: We can't validate the 'Create Seed Bank Agencies' node was created correctly. Check the required fields, field types, node name, and alias are correct. error on Challenge 3. Attaching my JSON below. I've spent way too many hours looking at this and would appreciate your review/response. Thanks in advance.
ReplyDelete{
"Load Account": {
"action": "sfdcDigest",
"parameters": {
"object": "Account",
"fields": [
{
"name": "Name"
},
{
"name": "AccountNumber"
},
{
"name": "Phone"
},
{
"name": "ShippingCity"
},
{
"name": "ShippingCountry"
},
{
"name": "ShippingState"
},
{
"name": "ShippingStreet"
},
{
"name": "ShippingPostalCode"
}
]
}
},
"ID Agency Records": {
"action": "computeExpression",
"parameters": {
"mergeWithSource": true,
"source": "Add Agency Fields",
"computedFields": [
{
"type": "Text",
"saqlExpression": "case when Phone is not null then \"True\" else \"False\" end",
"name": "IsAgency",
"label": "IsAgency"
}
]
}
},
"Filter Agency Records": {
"action": "filter",
"parameters": {
"source": "ID Agency Records",
"saqlFilter": "IsAgency==\"True\""
}
},
"Load Agency Detail": {
"action": "edgemart",
"parameters": {
"alias": "Agency_Detail"
}
},
"Add Agency Fields": {
"action": "augment",
"parameters": {
"operation": "LookupSingleValue",
"relationship": "AgencyDetail",
"left": "Load Account",
"right": "Load Agency Detail",
"left_key": [
"AccountNumber"
],
"right_key": [
"AccountNumber"
],
"right_select": [
"AccountNumber",
"Currency",
"Region",
"SubRegion",
"Latitude",
"Acres",
"Longitude"
]
}
},
"Create Seed Bank Agencies": {
"action": "sfdcRegister",
"parameters": {
"alias": "seed_bank_agencies",
"source": "Filter Agency Records",
"name": "Seed Bank Agencies"
}
}
}
Never mind on the item from yesterday. Somewhere along the way, the latitude/longitude data type requirement changed from the earlier posts noted above. Now, Salesforce requires changing these fields to dimension from metric. That solved it.
ReplyDeleteI'm facing the same issue:
ReplyDeleteChallenge Not yet complete... here's what's wrong:
We can't validate the 'Create Seed Bank Agencies' node was created correctly. Check the required fields, field types, node name, and alias are correct.
The names alias are corret. I've made the 5 Top Agencies Lens :(
The problem is not lat/lon (they already are measures)
My json:
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": "Phone"
},
{
"name": "Name"
},
{
"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"
}
},
"Create Load Account": {
"action": "sfdcRegister",
"parameters": {
"name": "Load Account",
"alias": "load_account",
"source": "Load Account"
}
},
"Add Agency Fields": {
"action": "augment",
"parameters": {
"right_key": [
"AccountNumber"
],
"left": "Load Account",
"left_key": [
"AccountNumber"
],
"right_select": [
"Currency",
"Region",
"SubRegion",
"Latitude",
"Acres",
"Longitude",
"AccountNumber"
],
"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"
}
]
}
}
}
Wait I will try this possible solution: "I changed lat and long from measures to dimensions in agency detail and it worked."
DeleteI was thinking that lat/lon must be Measures. But Ok, I've reeplaced the Dataset Agency Detail and the same issue is occuring :'(
OMG I Was checking the wrong org (Yes, I've created another playgroud) So: The solution is, change Lat/Lon to measure l and it worked. Solveddd
DeleteGlad you solved it!!!!
DeleteHello,
ReplyDeleteI'm currently stuck at step #3 of the superbadge with error: "We can't validate the 'Create Seed Bank Agencies' node was created correctly. Check the required fields, field types, node name, and alias are correct."
To be on the safe side, I checked that I have all required fields, the good alias and good name. However, I find myself unable to "debug" my code. Could you please save my forehead from a 100th headbutt? Thanks ;-)
My JSON is:
{
"Load Account": {
"action": "sfdcDigest",
"parameters": {
"fields": [
{
"name": "Name"
},
{
"name": "AccountNumber"
},
{
"name": "Phone"
},
{
"name": "ShippingCity"
},
{
"name": "ShippingCountry"
},
{
"name": "ShippingState"
},
{
"name": "ShippingStreet"
},
{
"name": "ShippingPostalCode"
}
],
"object": "Account"
}
},
"Load Agency Detail": {
"action": "edgemart",
"parameters": {
"alias": "Agency_Detail"
}
},
"ID Agency Records": {
"action": "computeExpression",
"parameters": {
"mergeWithSource": true,
"source": "Load Account",
"computedFields": [
{
"type": "Text",
"saqlExpression": "case when Phone is not null then \"true\" else \"false\" end",
"name": "IsAgency",
"label": "IsAgency"
}
]
}
},
"Filter Agency Records": {
"action": "filter",
"parameters": {
"source": "ID Agency Records",
"filter": "IsAgency:EQ:true"
}
},
"Add Agency Fields": {
"action": "augment",
"parameters": {
"operation": "LookupSingleValue",
"left": "Filter Agency Records",
"relationship": "AgencyDetail",
"right": "Load Agency Detail",
"left_key": [
"AccountNumber"
],
"right_key": [
"AccountNumber"
],
"right_select": [
"Currency",
"Acres",
"SubRegion",
"Latitude",
"Region",
"Longitude"
]
}
},
"Create Seed Bank Agencies": {
"action": "sfdcRegister",
"parameters": {
"alias": "seed_bank_agencies",
"source": "Slice isAgency",
"name": "Seed Bank Agencies",
"rowLevelSecurityFilter": ""
}
},
"Slice isAgency": {
"action": "sliceDataset",
"parameters": {
"mode": "drop",
"fields": [
{
"name": "IsAgency"
}
],
"source": "Add Agency Fields"
}
}
}
I am getting the dreaded "Functionality Not Enabled" error when attempting to clear Step #3. My user has access to Analytics Studio and the Admin permission set. All of the datasets and lenses are in the Mosaic app so I am not sure what functionality is left and which user it's missing from. Anyone hit this issue and find out that it is some silly, simple checkbox that they missed?
ReplyDeleteCreate a story in Einstein Discovery
ReplyDeleteCreate an “Insights & Predictions” story in Manual mode using the Beattie Subs dataset to generate a goal to maximize subscriber tenure.
Review all the fields used in the story and create a new story version by removing any fields which might be contributing to data leakage. Hint there is one field that should not be used in the predictive model because it is only populated when the record reaches the terminal state.
Review any date field(s) used in the model. Should you be including the year? Consider any new records that will be scored with this model. Will the predictive model know how to handle the year? Consider focusing on “day of week” or “month of year”.
Explore model metrics and make sure this model is good enough to be deployed.
This is a challenge in Tableau CRM and Einstein Discovery Insights Specialist.Can you please help me on this?
Can you please help me out? What did I do wrong?
ReplyDelete{
"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": {
"left": "Load Account",
"right": "Load Agency Detail",
"relationship": "AgencyDetail",
"operation": "LookupSingleValue",
"left_key": [
"AccountNumber"
],
"right_key": [
"AccountNumber"
],
"right_select": [
"Acres",
"Currency",
"Latitude",
"Longitude",
"Region",
"SubRegion"
]
}
},
"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"
}
]
}
}
}
Close
Hi,
ReplyDeleteWould you mind helping me with this error message Step 3 :
Challenge Not yet complete... here's what's wrong:
We can't find a filter on Account Name on your 'Top 5 Agencies' lens.
I've been trying for hours and can't find what's wrong. My Top 5 Agencies Lens is having a filter on "Account name" so I don't understand the problem.
Thanks for your help because I can't move forward.
@Trailhead Baby,
ReplyDeleteHi, I'm getting the below error. Can someone please help to solve this issue?
"Challenge Not yet complete... here's what's wrong:
We can't find the 'Load Seed Bank Agencies' dataflow. Confirm the dataflow matches the name as described in the challenge."
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": "ShippingPostalCode"
},
{
"name": "ShippingState"
},
{
"name": "ShippingStreet"
},
{
"name": "ShippingCountry"
},
{
"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": {
"left": "Load Account",
"right": "Load Agency Detail",
"relationship": "AgencyDetail",
"operation": "LookupSingleValue",
"left_key": [
"AccountNumber"
],
"right_key": [
"AccountNumber"
],
"right_select": [
"Currency",
"Region",
"SubRegion",
"Latitude",
"Acres",
"Longitude",
"AccountNumber"
]
}
},
"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
Hello @prasanth and others who solved the challenge 3. I am facing difficulty with Challenge 3.
ReplyDeleteI am getting this below error. Can anyone please help.
Challenge Not yet complete... here's what's wrong:
We can't validate the 'Create Seed Bank Agencies' node was created correctly. Check the required fields, field types, node name, and alias are correct.
In the datflow I am getting below Error.
Something went wrong while executing the ID Agency Records node: invalid field expression for field 'IsAgency': Syntax Error at position [line 1: column 10] after token Unexpected character ':' :: ;IsAgency:EQ:TRUE; (02K5g000000SgrUEAS_03C5g000002MgvnEAC)
Hi, I'm still not able to resolve this challenge: I keep getting the error
ReplyDelete"We can't validate the 'Create Seed Bank Agencies' node was created correctly."
Already checked all comments here, recreated a new org, but still same error...
Here's my JSON:
{
"Load Account": {
"action": "sfdcDigest",
"parameters": {
"fields": [
{
"name": "Name"
},
{
"name": "AccountNumber"
},
{
"name": "Phone"
},
{
"name": "ShippingCity"
},
{
"name": "ShippingCountry"
},
{
"name": "ShippingState"
},
{
"name": "ShippingStreet"
},
{
"name": "ShippingPostalCode"
}
],
"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": [
"AccountNumber",
"Acres",
"Currency",
"Latitude",
"Longitude",
"Region",
"SubRegion"
]
}
},
"ID Agency Records": {
"action": "computeExpression",
"parameters": {
"mergeWithSource": true,
"source": "Add Agency Fields",
"computedFields": [
{
"type": "Text",
"saqlExpression": "case when Phone is not null then \"True\" else \"False\" end",
"name": "IsAgency",
"label": "IsAgency"
}
]
}
},
"Filter Agency Records": {
"action": "filter",
"parameters": {
"source": "ID Agency Records",
"saqlFilter": "IsAgency == \"True\""
}
},
"Create Seed Bank Agencies": {
"action": "sfdcRegister",
"parameters": {
"alias": "seed_bank_agencies",
"source": "Filter Agency Records",
"name": "Seed Bank Agencies"
}
}
}
POST 1/2
ReplyDeleteHey Trailhead Baby, thanks for everything you do!
I am attempting to complete the Tableau CRM Data Prep Specialist Badge and getting stuck on challenge 4 (previously challenge 3 based on all of the troubleshooting threads I've read).
When attempting to validate this challenge I'm getting the following error message: "Challenge Not yet complete... here's what's wrong:
We can't validate the 'Create Seed Bank Agencies' node was created correctly. Check the required fields, field types, node name, and alias are correct."
I have been racking my brain looking over naming conventions, spelling, and casing for the past several hours with no success. This is especially frustrating because my Dataflow is running, the data looks right, and I'm able to create my Top 5 Agencies Lens!
Any tips or troubleshooting guidance would be greatly appreciated! Attached is my Dataflow JSON (posted in 2 parts).
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"
}
},
POST 2/2
DeleteJSON (continued)
"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": {
"left": "Filter Agency Records",
"relationship": "AgencyDetail",
"operation": "LookupSingleValue",
"left_key": [
"AccountNumber"
],
"right": "Load Agency Detail",
"right_key": [
"AccountNumber"
],
"right_select": [
"Acres",
"Currency",
"Latitude",
"Longitude",
"Region",
"SubRegion"
]
}
},
"ID Agency Records": {
"action": "computeExpression",
"parameters": {
"source": "Load Account",
"mergeWithSource": true,
"computedFields": [
{
"defaultValue": "FALSE",
"name": "IsAgency",
"saqlExpression": "case when Phone is not null then \"TRUE\" else \"FALSE\" end",
"label": "IsAgency",
"type": "Text"
}
]
}
},
"Load Agency Detail": {
"action": "edgemart",
"parameters": {
"alias": "Agency_Detail1"
}
}
}
hello
ReplyDeletehttps://trailhead.salesforce.com/en/content/learn/superbadges/superbadge_analytics_integration_specialist
DeleteDear Trailhead baby, I've managed to run the dataflow by going through all the suggestions above however the dataset is not yielding any results to make the lens .
ReplyDeleteJSON as follows, HELP!!!: {
"Filter Agency Records": {
"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": "Filter 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"
}
},
"Add Agency Fields": {
"action": "augment",
"parameters": {
"right_key": [
"AccountNumber"
],
"left": "Load Account",
"left_key": [
"AccountNumber"
],
"right_select": [
"Acres",
"Currency",
"Latitude",
"Longitude",
"Region",
"SubRegion",
"AccountNumber"
],
"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
Hi, I am getting these errors:
ReplyDeleteCheck Challenge Error:
Challenge Not yet complete... here's what's wrong:
We can't validate the 'Create Seed Bank Agencies' node was created correctly. Check the required fields, field types, node name, and alias are correct.
Run Dataflow Error:
Something went wrong while executing the ID Agency Records node: invalid field expression for field 'IsAgency' [error category: USER]: Syntax Error at position [line 1: column 10] after token Unexpected character ':' :: ;IsAgency:EQ:True; (02KDn000000CFhnMAG_03CDn000001BiRdMAK)
I tried:
Checking Connections and made sure Account and User were synced.
Use SAQL is unchecked in Filter Agency Records.
What else should I try? Thanks!
Full 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": [
"Currency",
"Region",
"SubRegion",
"Latitude",
"Acres",
"Longitude"
],
"right": "Load Agency Detail",
"relationship": "AgencyDetail",
"operation": "LookupSingleValue"
}
},
"ID Agency Records": {
"action": "computeExpression",
"parameters": {
i Hello,
ReplyDeleteI have an issue with the dataflow Load Seed Bank Agencies. It was successfully run but there are no records when I create a Lens. Do you have any guess of what might be the issue?