You need to sign in to do that
Don't have an account?
Olivier Grisez
Einstein Analytics Data Preparation Specialist_step 3
I follow LinThaw instructions for step 3 but I can complete challenge.
Error message : "Challenge Not yet complete... here's what's wrong:
Couldn’t find the 'Load Agency Detail' node in the dataflow. Confirm the node name matches the name as described in the challenge."
Dataflow JSON :
{
"Filter Agency Records": {
"action": "filter",
"parameters": {
"filter": "IsAgency:EQ:TRUE",
"source": "ID Agency Records"
}
},
"Load Account": {
"action": "sfdcDigest",
"parameters": {
"fields": [
{
"name": "Name"
},
{
"name": "AccountNumber"
},
{
"name": "Phone"
},
{
"name": "ShippingCity"
},
{
"name": "ShippingCountry"
},
{
"name": "ShippingState"
},
{
"name": "ShippingStreet"
},
{
"name": "ShippingPostalCode"
}
],
"object": "Account"
}
},
"Create Seed Bank Agencies": {
"action": "sfdcRegister",
"parameters": {
"name": "Seed Bank Agencies",
"alias": "seed_bank_agencies",
"source": "Filter Agency Records"
}
},
"Add Agency Fields": {
"action": "augment",
"parameters": {
"right_key": [
"AccountNumber"
],
"left": "Load Account",
"left_key": [
"AccountNumber"
],
"right_select": [
"Acres",
"Currency",
"Latitude",
"Longitude",
"Region",
"SubRegion"
],
"right": "Load Agency Detail",
"relationship": "AgencyDetail",
"operation": "LookupSingleValue"
}
},
"Load Agency Detail": {
"action": "edgemart",
"parameters": {
"alias": "Dataset_Agency_Detail"
}
},
"ID Agency Records": {
"action": "computeExpression",
"parameters": {
"source": "Add Agency Fields",
"mergeWithSource": true,
"computedFields": [
{
"name": "IsAgency",
"label": "IsAgency",
"type": "Text",
"saqlExpression": "case when Phone != \"\" then \"TRUE\" end",
"defaultValue": "FALSE"
}
]
}
}
}
Please help me =)
Error message : "Challenge Not yet complete... here's what's wrong:
Couldn’t find the 'Load Agency Detail' node in the dataflow. Confirm the node name matches the name as described in the challenge."
Dataflow JSON :
{
"Filter Agency Records": {
"action": "filter",
"parameters": {
"filter": "IsAgency:EQ:TRUE",
"source": "ID Agency Records"
}
},
"Load Account": {
"action": "sfdcDigest",
"parameters": {
"fields": [
{
"name": "Name"
},
{
"name": "AccountNumber"
},
{
"name": "Phone"
},
{
"name": "ShippingCity"
},
{
"name": "ShippingCountry"
},
{
"name": "ShippingState"
},
{
"name": "ShippingStreet"
},
{
"name": "ShippingPostalCode"
}
],
"object": "Account"
}
},
"Create Seed Bank Agencies": {
"action": "sfdcRegister",
"parameters": {
"name": "Seed Bank Agencies",
"alias": "seed_bank_agencies",
"source": "Filter Agency Records"
}
},
"Add Agency Fields": {
"action": "augment",
"parameters": {
"right_key": [
"AccountNumber"
],
"left": "Load Account",
"left_key": [
"AccountNumber"
],
"right_select": [
"Acres",
"Currency",
"Latitude",
"Longitude",
"Region",
"SubRegion"
],
"right": "Load Agency Detail",
"relationship": "AgencyDetail",
"operation": "LookupSingleValue"
}
},
"Load Agency Detail": {
"action": "edgemart",
"parameters": {
"alias": "Dataset_Agency_Detail"
}
},
"ID Agency Records": {
"action": "computeExpression",
"parameters": {
"source": "Add Agency Fields",
"mergeWithSource": true,
"computedFields": [
{
"name": "IsAgency",
"label": "IsAgency",
"type": "Text",
"saqlExpression": "case when Phone != \"\" then \"TRUE\" end",
"defaultValue": "FALSE"
}
]
}
}
}
Please help me =)