Apex Code Development You need to sign in to do that
Don't have an account?
Einstein Analytics Data Preparation Specialist Superbadge error
This is on challenge 3. The Register Node Name is "Create Seed Bank Agencies", the alias is "create_seed_bank_agencies", the Name is "Seed Bank Agencies". I read the Pre-work and understand the alias should be with underscores and lower case. I have tried a few combinations but I get this error:
Challenge Not yet complete... here's what's wrong:
Couldn’t find 'Create Seed Bank Agencies' node. Please check the name and alias spelling.
Challenge Not yet complete... here's what's wrong:
Couldn’t find 'Create Seed Bank Agencies' node. Please check the name and alias spelling.
I initially got the error you are getting. Make sure the dataset is saved to the correct app.
Also, please check with below steps if you have done the same.
and create Top 5 Agencies lenses.
For more information please check with below link.
- https://developer.salesforce.com/forums?id=9060G0000005d3yQAA
Hope this helps.Kindly mark this as solved if the reply was helpful.
Thanks,
Nagendra
please change alias from [create_seed_bank_agencies] to [seed_bank_agencies]
Regards,
LinThaw
I am facing problem in Challenge #7, here is my JSON:
{
"Add Temp Class": {
"action": "computeExpression",
"parameters": {
"source": "Filter 2015",
"mergeWithSource": true,
"computedFields": [
{
"defaultValue": "Continental",
"name": "TempClass",
"saqlExpression": "case when Temperature < 25 then \"Polar\" when Temperature >= 25 and Temperature <= 50 then \"Cool\" when Temperature >= 51 and Temperature <= 85 then \"Continental\" when Temperature > 85 then \"Tropical\" end",
"label": "TempClass",
"type": "Text"
}
]
}
},
"Create Order History": {
"action": "sfdcRegister",
"parameters": {
"name": "Order History",
"alias": "Order_History2",
"source": "Add Seed Orders"
}
},
"Load Seed Orders": {
"action": "edgemart",
"parameters": {
"alias": "Order_History2"
}
},
"Augment Temp Class": {
"action": "augment",
"parameters": {
"right_key": [
"ShippingCountry"
],
"left": "Add Temp Class",
"left_key": [
"Country"
],
"right_select": [
"AccountNumber",
"Name",
"Phone",
"ShippingCity",
"ShippingCountry",
"ShippingPostalCode",
"ShippingState",
"ShippingStreet"
],
"right": "Load Account",
"relationship": "AugmentTempClass",
"operation": "LookupSingleValue"
}
},
"Load Climate": {
"action": "edgemart",
"parameters": {
"alias": "Global_Climates"
}
},
"Add Seed Orders": {
"action": "augment",
"parameters": {
"left": "Load Seed Orders",
"right": "Filter Agency Records",
"relationship": "SeedOrders",
"operation": "LookupSingleValue",
"left_key": [
"Agency_ID"
],
"right_key": [
"Climate.AccountNumber"
],
"right_select": [
"AugmentTempClass.AccountNumber",
"AugmentTempClass.Name",
"AugmentTempClass.Phone",
"AugmentTempClass.ShippingCity",
"AugmentTempClass.ShippingCountry",
"AugmentTempClass.ShippingPostalCode",
"AugmentTempClass.ShippingState",
"AugmentTempClass.ShippingStreet"
]
}
},
"Filter 2015": {
"action": "filter",
"parameters": {
"filter": "Date_Year:EQ:2015",
"source": "Load Climate"
}
},
"Add Agency Detail Fields": {
"action": "augment",
"parameters": {
"right_key": [
"AccountNumber"
],
"left": "Load Account",
"left_key": [
"AccountNumber"
],
"right_select": [
"AccountNumber",
"Acres",
"Currency",
"Latitude",
"Longitude",
"Region",
"SubRegion"
],
"right": "Load Agency",
"relationship": "AgencyDetail",
"operation": "LookupSingleValue"
}
},
"ID Agency Records": {
"action": "computeExpression",
"parameters": {
"source": "Add Agency Detail Fields",
"mergeWithSource": true,
"computedFields": [
{
"name": "IsAgency",
"saqlExpression": "case when Phone is not null then \"TRUE\" else \"FALSE\" end",
"label": "IsAgency",
"type": "Text"
}
]
}
},
"Load Agency": {
"action": "edgemart",
"parameters": {
"alias": "Agency_Detail"
}
},
"Filter Agency Records": {
"action": "filter",
"parameters": {
"filter": "Climate.IsAgency:EQ:TRUE",
"source": "Add Agency Fields"
}
},
"Load Account": {
"action": "sfdcDigest",
"parameters": {
"fields": [
{
"name": "AccountNumber"
},
{
"name": "Name"
},
{
"name": "Phone"
},
{
"name": "ShippingCity"
},
{
"name": "ShippingCountry"
},
{
"name": "ShippingPostalCode"
},
{
"name": "ShippingState"
},
{
"name": "ShippingStreet"
}
],
"object": "Account"
}
},
"Add Agency Fields": {
"action": "augment",
"parameters": {
"right_key": [
"AccountNumber"
],
"left": "Augment Temp Class",
"left_key": [
"AugmentTempClass.AccountNumber"
],
"right_select": [
"AccountNumber",
"IsAgency",
"Name",
"Phone",
"ShippingCity",
"ShippingCountry",
"ShippingPostalCode",
"ShippingState",
"ShippingStreet"
],
"right": "ID Agency Records",
"relationship": "Climate",
"operation": "LookupSingleValue"
}
}
}
Please help me to clear this.
Thanks,
Rashmi
Did you create [Seed Bank Order] dataset from [Seed Bank Orders.txt] file?
Please use this [Seed Bank Order] dataset in [Load Seed Orders] node.
And, please change Alias from [Order_History2] to [order_history] in [Create Order History] node.
For more information
please refer following post.
https://developer.salesforce.com/forums?id=9060G0000005d3yQAA
Regards,
LinThaw
I saw your other post and I am following exactly the same steps you outlined. I got the correct data set (383) and create the lens. But when I check, it gave me the error "Challenge Not yet complete... here's what's wrong:
We can't confirm you found the correct values. Please check your work."
I have changed two environments. I got the same result. I am stuck on step 3.
I really appreciate if someone can help. The Jason file is:
{
"Filter Agency Records": {
"action": "filter",
"parameters": {
"filter": "IsAgency:EQ:TRUE",
"source": "ID Agency Records"
}
},
"Load Account": {
"action": "sfdcDigest",
"parameters": {
"incremental": true,
"fields": [
{
"name": "AccountNumber"
},
{
"name": "Name"
},
{
"name": "Phone"
},
{
"name": "ShippingCity"
},
{
"name": "ShippingCountry"
},
{
"name": "ShippingState"
},
{
"name": "ShippingStreet"
},
{
"name": "ShippingPostalCode"
}
],
"object": "Account"
}
},
"Create Seed Bank Agencies": {
"action": "sfdcRegister",
"parameters": {
"rowLevelSecurityFilter": "",
"name": "Seed Bank Agencies",
"alias": "seed_bank_agencies",
"source": "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"
}
]
}
}
}
Thanks,
Uncheck Use SAQL checkbox. Just write IsAgency:EQ:TRUE in filter.
It will solve your problem.
Regards,
Hrishikesh
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 reviewed the setup and I can't find any issues, could you help?
-----Challenge Not yet complete... here's what's wrong:
We can't confirm you found the correct values. Please check your work
@LinThaw , Can you help, TIA
The problem I have is the rows stopped going out at Filter Agency records, so my dataset doesn't contain any information when I create the New Lens. Any insight into what might be going wrong?
stuck up in challenge 7
my JSON
{
"Add Temp Class": {
"action": "computeExpression",
"parameters": {
"source": "Filter 2015",
"mergeWithSource": true,
"computedFields": [
{
"defaultValue": "\"Continental\"",
"name": "TempClass",
"saqlExpression": "case when Temperature < 25 then \"Polar\" when Temperature >= 25 and Temperature <= 50 then \"Cool\" when Temperature >= 51 and Temperature <= 85 then \"Continental\" when Temperature > 85 then \"Tropical\" end",
"label": "TempClass",
"type": "Text"
}
]
}
},
"Load Seed Orders": {
"action": "edgemart",
"parameters": {
"alias": "Seed_Bank_Orders"
}
},
"Create Order History": {
"action": "sfdcRegister",
"parameters": {
"name": "Order History",
"alias": "order_history",
"source": "Add Seed Orders"
}
},
"Augment Temp Class": {
"action": "augment",
"parameters": {
"right_key": [
"ShippingCountry"
],
"left": "Add Temp Class",
"left_key": [
"Country"
],
"right_select": [
"AccountNumber",
"Name",
"Phone",
"ShippingCity",
"ShippingCountry",
"ShippingPostalCode",
"ShippingState",
"ShippingStreet"
],
"right": "Load Account",
"relationship": "AugmentTempClass",
"operation": "LookupSingleValue"
}
},
"Load Climate": {
"action": "edgemart",
"parameters": {
"alias": "Global_Climates"
}
},
"Add Seed Orders": {
"action": "augment",
"parameters": {
"right_key": [
"Climate.AccountNumber"
],
"left": "Load Seed Orders",
"left_key": [
"Agency_ID"
],
"right_select": [
"AugmentTempClass.AccountNumber",
"AugmentTempClass.Name",
"AugmentTempClass.Phone",
"AugmentTempClass.ShippingCity",
"AugmentTempClass.ShippingCountry",
"AugmentTempClass.ShippingPostalCode",
"AugmentTempClass.ShippingState",
"AugmentTempClass.ShippingStreet"
],
"right": "Filter Agency Records",
"relationship": "SeedOrders",
"operation": "LookupSingleValue"
}
},
"Filter 2015": {
"action": "filter",
"parameters": {
"filter": "Date_Year:EQ:2015",
"source": "Load Climate"
}
},
"Add Agency Detail Fields": {
"action": "augment",
"parameters": {
"right_key": [
"AccountNumber"
],
"left": "Load Account",
"left_key": [
"AccountNumber"
],
"right_select": [
"AccountNumber",
"Acres",
"Currency",
"Latitude",
"Longitude",
"Region",
"SubRegion"
],
"right": "Load Agency",
"relationship": "AgencyDetail",
"operation": "LookupSingleValue"
}
},
"ID Agency Records": {
"action": "computeExpression",
"parameters": {
"source": "Add Agency Detail Fields",
"mergeWithSource": true,
"computedFields": [
{
"name": "IsAgency",
"saqlExpression": "case when Phone is not null then \"TRUE\" else \"FALSE\" end",
"label": "IsAgency",
"type": "Text"
}
]
}
},
"Load Agency": {
"action": "edgemart",
"parameters": {
"alias": "Agency_Detail"
}
},
"Filter Agency Records": {
"action": "filter",
"parameters": {
"filter": "Climate.IsAgency:EQ:TRUE",
"source": "Add Agency Fields"
}
},
"Load Account": {
"action": "sfdcDigest",
"parameters": {
"fields": [
{
"name": "AccountNumber"
},
{
"name": "Name"
},
{
"name": "Phone"
},
{
"name": "ShippingCity"
},
{
"name": "ShippingCountry"
},
{
"name": "ShippingPostalCode"
},
{
"name": "ShippingState"
},
{
"name": "ShippingStreet"
}
],
"object": "Account"
}
},
"Add Agency Fields": {
"action": "augment",
"parameters": {
"right_key": [
"AccountNumber"
],
"left": "Augment Temp Class",
"left_key": [
"AugmentTempClass.AccountNumber"
],
"right_select": [
"AccountNumber",
"IsAgency",
"Name",
"Phone",
"ShippingCity",
"ShippingCountry",
"ShippingPostalCode",
"ShippingState",
"ShippingStreet"
],
"right": "ID Agency Records",
"relationship": "Climate",
"operation": "LookupMultiValue"
}
}
}
Challenge Not yet complete... here's what's wrong:
We can't confirm the correct values were found. Please check your work.
While i am performing Einstein Analytics Data Preparation Specialist -Create Seed Bank Agencies Step, eventhough i have created 'Create Seed Bank Agencies' node in flow- Load Seed Bank Agencies-, i got below error . Could you please help me regarding this.
Challenge Not yet complete... here's what's wrong:
We can't find the 'Create Seed Bank Agencies' node. Please check the name and alias spelling.
Node Name
Source Node
["Filter Agency Records"]
Alias Seed_Bank_Agencies
Name Seed Bank Agencies
Sharing Source
[]
Regards,
Kesava Reddy
Even i am stuck on challenge 3. below is my JSON code. Still not sure what i am missing here.
{
"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"
}]
}
}
}
Regards,
Alfio DSilva
I was able to complete the step. The issue was with the Dataset for Agency Detail.txt file which I created.
I had converted the Latitude and Longitude to Dimension which is not required. After converting it back to Measure I was able to complete the Step
Regards,
Alfio Dsilva
May 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": "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", "Region", "SubRegion", "Longitude", "Latitude", "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": "Load Account", "mergeWithSource": true, "computedFields": [ { "name": "IsAgency", "saqlExpression": "case when Phone is not null then \"TRUE\" else \"FALSE\" end", "label": "IsAgency", "type": "Text" } ] } } }I 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"
}
}
}
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.
Close errors
in Einstein Analytics Data Preparation Specialist challenge 3
{
"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",
"Latitude",
"Longitude",
"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"
}
]
}
}
}
Close
I am getting this error in challenge 3 , I have created multiple time dataflow, dataset, lens etc but still having the same error
My JSON follows as:
{
"Filter Agency Records": {
"action": "filter",
"parameters": {
"filter": "IsAgency:EQ:TRUE",
"source": "ID Agency Records"
}
},
"Load Account": {
"action": "sfdcDigest",
"parameters": {
"fields": [
{
"name": "Name"
},
{
"name": "AccountNumber"
},
{
"name": "Phone"
},
{
"name": "ShippingCity"
},
{
"name": "ShippingCountry"
},
{
"name": "ShippingPostalCode"
},
{
"name": "ShippingState"
},
{
"name": "ShippingStreet"
}
],
"object": "Account"
}
},
"Create Seed Bank Agencies": {
"action": "sfdcRegister",
"parameters": {
"name": "Seed Bank Agencies",
"alias": "seed_bank_agencies",
"source": "Filter Agency Records"
}
},
"Add Agency Fields": {
"action": "augment",
"parameters": {
"right_key": [
"AccountNumber"
],
"left": "Load Account",
"left_key": [
"AccountNumber"
],
"right_select": [
"Acres",
"Currency",
"Latitude",
"Longitude",
"Region",
"SubRegion"
],
"right": "Load Agency Detail",
"relationship": "AgencyDetail",
"operation": "LookupSingleValue"
}
},
"Load Agency Detail": {
"action": "edgemart",
"parameters": {
"alias": "Agency_Detail"
}
},
"ID Agency Records": {
"action": "computeExpression",
"parameters": {
"source": "Add Agency Fields",
"mergeWithSource": true,
"computedFields": [
{
"name": "IsAgency",
"saqlExpression": "case when Phone is not null then \"TRUE\" else \"FALSE\" end",
"label": "IsAgency",
"type": "Text"
}
]
}
}
}
Kindly suggest for the corrections please..
Many thanks
I am also facing same issue. I have same JSON and Same LENs. I tried in 2-3 orgs but no luck.
Could you please help me if your issue resolved.
Thanks
Avanish
Challenge Not yet complete... here's what's wrong:
We can't find the 'Create Seed Bank' node or required fields, such as 'TempClass', are missing. Check the challenge and confirm the node name and required fields.
Close errors
Can anyone help!
Thank you so much! Your suggestion helps resolving the problem.
thanks - works!
Was someone able to solve this mysterious step 3?
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 everything, also on another org with Agencies Details with geo locations as dimensions, but then I was getting other error.
Here you can find 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": "ShippingCity" }, { "name": "ShippingCountry" }, { "name": "ShippingPostalCode" }, { "name": "ShippingState" }, { "name": "Phone" }, { "name": "ShippingStreet" } ], "object": "Account" } }, "Create Seed Bank Agencies": { "action": "sfdcRegister", "parameters": { "name": "Create Seed Bank Agencies", "alias": "seed_bank_agencies", "source": "Drop IsAgency" } }, "Drop IsAgency": { "action": "sliceDataset", "parameters": { "mode": "drop", "source": "Filter Agency Records", "fields": [ { "name": "IsAgency" } ] } }, "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" } ] } } }and the screenshot
I have created the Lens, and everythng seems fine.
I am also facing the same error while completing "Create Seed Bank Agencies" challenge in superbadge "Tableau CRM Data Preparation Specialist" . Need help.
Here is my Json:
{
"Filter Agency Records": {
"action": "filter",
"parameters": {
"filter": "IsAgency:EQ:TRUE",
"source": "ID Agency Records"
}
},
"Load Account": {
"action": "sfdcDigest",
"parameters": {
"fields": [
{
"name": "AccountNumber"
},
{
"name": "Name"
},
{
"name": "Phone"
},
{
"name": "ShippingCity"
},
{
"name": "ShippingCountry"
},
{
"name": "ShippingState"
},
{
"name": "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",
"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": "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 getting a mysterious error when attempting to verify #4 Create Seed Bank Agencies that has not been covered yet in this thread. Functionally the generated dataset works perfectly and the lens was created too without any issues after making countless changes as outlined in this thread, but the challenge can still not be verified as attested by the attached screenshot. I have stuck to all outlined naming conventions and as mentioned, the dataflow and dataset actually functionally work perfectly. Please find my JSON below as well. Any help on this would be greatly appreciated.
{
"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": {
"source": "Add Agency Fields",
"mergeWithSource": true,
"computedFields": [
{
"name": "IsAgency",
"saqlExpression": "case when Phone is not null then \"TRUE\" else \"FALSE\" end",
"label": "IsAgency",
"type": "Text"
}
]
}
},
"Load Agency Detail": {
"action": "edgemart",
"parameters": {
"alias": "Agency_Detail"
}
}
}
I was facing the same issue, and tried in several different ways to resovle.
Finally I was able to fix. While uploading the "Agency Detail.txt" dataset (had to modify and apply different changes while uploading this dataset), convert the Latitude and Longitude to Dimension, and keep the Acre as is. Recreated the dataflow from the sratch and this time it works fine.
Regards.
Yousuf Zaman.
Hi Team,
I am facing the below issue when I am trying to finish my "Step 4" challenge in "CRM Analytics Data Preparation Specialist".
Can someone help how to solve this?
I have successfully created
1) Dataflow to create a dataset named "Seed Bank Agencies" (which is in the SharedApp location and not in the 'Mosaic' app location) and
2) Lense inside "Mosaic" app to show 'Top 5 Crop Seeds lens that displays acreage for the top 5 seeds in the Seed Bank'
Below is the error I get (Screenshot attached below after the error text) when I am trying to finish my "Step 4" challenge
"There was an unhandled exception. Please reference ID: EJHONRIJ. Error: Restforce::ResponseError. Message: FUNCTIONALITY_NOT_ENABLED: This feature is not currently enabled for this user."
Help found from this page: https://trailhead.salesforce.com/trailblazer-community/feed/0D54S00000A8ukeSAB