You need to sign in to do that
Don't have an account?
Akhil Sattiraju
Einstein Analytics Data Preparation Specialist challenge #3
Hi Folks ,
I have tryingg to move with this challenge from a long time but not able to complete it .Due to which my other challenges are not done .Please help me out.
Data Flow-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": "Name"
},
{
"name": "AccountNumber"
},
{
"name": "Phone"
},
{
"name": "ShippingCity"
},
{
"name": "ShippingCountry"
},
{
"name": "ShippingState"
},
{
"name": "ShippingStreet"
},
{
"name": "ShippingPostalCode"
}
],
"object": "Account"
}
},
"Remove Agency": {
"action": "sliceDataset",
"parameters": {
"mode": "drop",
"source": "Filter Agency Records",
"fields": [
{
"name": "IsAgency"
}
]
}
},
"Create Seed Bank Agencies": {
"action": "sfdcRegister",
"parameters": {
"name": "Seed Bank Agencies",
"alias": "seed_bank_agencies",
"source": "Remove Agency"
}
},
"Add Agency Fields": {
"action": "augment",
"parameters": {
"right_key": [
"AccountNumber"
],
"left": "Load Account",
"left_key": [
"AccountNumber"
],
"right_select": [
"Acres",
"Currency",
"Longitude",
"Latitude",
"Region",
"SubRegion"
],
"right": "Load Agency Detail",
"relationship": "AgencyDetail",
"operation": "LookupSingleValue"
}
},
"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"
}
]
}
}
}
Error -
I have tried creating a differnt Developers Org also .But the error still remains the same.
I have tryingg to move with this challenge from a long time but not able to complete it .Due to which my other challenges are not done .Please help me out.
Data Flow-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": "Name"
},
{
"name": "AccountNumber"
},
{
"name": "Phone"
},
{
"name": "ShippingCity"
},
{
"name": "ShippingCountry"
},
{
"name": "ShippingState"
},
{
"name": "ShippingStreet"
},
{
"name": "ShippingPostalCode"
}
],
"object": "Account"
}
},
"Remove Agency": {
"action": "sliceDataset",
"parameters": {
"mode": "drop",
"source": "Filter Agency Records",
"fields": [
{
"name": "IsAgency"
}
]
}
},
"Create Seed Bank Agencies": {
"action": "sfdcRegister",
"parameters": {
"name": "Seed Bank Agencies",
"alias": "seed_bank_agencies",
"source": "Remove Agency"
}
},
"Add Agency Fields": {
"action": "augment",
"parameters": {
"right_key": [
"AccountNumber"
],
"left": "Load Account",
"left_key": [
"AccountNumber"
],
"right_select": [
"Acres",
"Currency",
"Longitude",
"Latitude",
"Region",
"SubRegion"
],
"right": "Load Agency Detail",
"relationship": "AgencyDetail",
"operation": "LookupSingleValue"
}
},
"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"
}
]
}
}
}
Error -
I have tried creating a differnt Developers Org also .But the error still remains the same.
Go to the below link it will be useful for you.
First link is very good as it one of oldest and best thread.
https://developer.salesforce.com/forums/?id=9060G0000005d3yQAA
https://developer.salesforce.com/forums/?id=9060G0000005dSyQAI (https://developer.salesforce.com/forums/?id=9062I000000IGYwQAO)
https://developer.salesforce.com/forums/?id=9062I000000IGYwQAO