Hi @Linthaw,

I read all the comments on this post https://developer.salesforce.com/forums/?id=9060G0000005d3yQAA#!/feedtype=SINGLE_QUESTION_SEARCH_RESULT&id=9060G0000005d3yQAA
and I'm still stuck on the challenge 3 "We can't validate the 'Create Seed Bank Agencies' node was created correctly."

I created this new question, because I cannot add a new comment on the last post.

I tried at least 5 differents JSON, so I'm pretty sure the problem is not on that side, but I've put the json at the end of this comment just in case.

The problem is maybe here, when I compared ROWS IN and ROWS OUT, I don't have the same total of you.

• So first, I think it was because I did the bulk data load jobs too many time at the beginning with the Agency Data.txt file.
  • So I came back and I did a mass delete records for all the Contact and Account. I filtered with my Created By Alias and after that with the Created Date of the day.
  • I'm still not able to remove some Account who are probably link to other Salesforce object when I did other badges. Ok for me at first glance, but ...

Is the ROWS IN and ROWS OUT have and impact on the validation of the Challenge 3? Because the dataflow run great and I see the lens accordingly to all the screenshot I see on the web.

And don't wander,

• I removed the lens each time a rerun the dataflow, just to be sure.
• Each time a did a bulk data load jobs or a mass delete record I rerun the SFDC_LOCAL to be sure the Account of SalesForce are refreshed into Analystics Studio. 
• My dataset Seed Bank Agencies and Agency Detail are located in the Mozaic App. So my lens Top 5 Agencies.

So please help me, I can provide to you any other useful information, here below some screenshot.







{
  "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"
        }
      ]
    }
  }
}

Thanks