+ Start a Discussion
Akhil SattirajuAkhil 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"
        }
      ]
    }
  }
}

Load Seed Bank Agencies DataFlow diagram
Error -
Error at the challenge

I have tried creating a differnt Developers Org also .But the error still remains the same.




 
Uttpal_ChandraUttpal_Chandra
Hi Akhil,

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