+ Start a Discussion
Deb_GearsCRMDeb_GearsCRM 

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.
NagendraNagendra (Salesforce Developers) 
Hi,

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.
User-added imageUser-added image
and create Top 5 Agencies lenses.

For more information please check with below link. Hope this helps.

Kindly mark this as solved if the reply was helpful.

Thanks,
Nagendra
LinThawLinThaw
hi Deb,

please change alias from [create_seed_bank_agencies] to [seed_bank_agencies]

Regards,
LinThaw
 
Rashmi N 3Rashmi N 3
Hello 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"
    }
  }
}

User-added image

Please help me to clear this.

Thanks,
Rashmi
LinThawLinThaw
Hi 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
 
Xibing Li 6Xibing Li 6
Hi, All,

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,
 
Alex Volokhov 9Alex Volokhov 9
I have retried challenge three with four different developer accounts to. Maybe its an issue with my datasets?

need help
Alex Volokhov 9Alex Volokhov 9
User-added image
User-added image
 
Hrishikesh Upadhye 5Hrishikesh Upadhye 5
Hi Alex,

Uncheck Use SAQL checkbox. Just write IsAgency:EQ:TRUE in filter.
It will solve your problem.

Regards,
Hrishikesh
Tanya CollTanya Coll
Hello! I'm trying to pass challenge 3 and I'm receiving the error message: 
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?

User-added image
User-added imageUser-added image
User-added image
Vijaya Narkar 11Vijaya Narkar 11
Hi, on challenge 3, I am getting same error, Please help on this !

-----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
Sudhir VasamsettiSudhir Vasamsetti
Hi, I got stuck on challenge #6, can someone help me.
 
Mike Siers 15Mike Siers 15
Can someone help? I did the dataflow. From the challenge standpoint, I think I got it right. The only difference between mine and the Nagendra is the Load Agency Detail say's "dataset" in place of where his say's "alias." (Not sure if that was updated by salesforce since 16 or not)...

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?

User-added image

User-added image

 
Nitin verma 22Nitin verma 22
Hi @Linthaw
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"
    }
  }
}
 
Nitin verma 22Nitin verma 22
@Linthaw, JSON is exactly same as yours, lense is also matching but getting error as 
Challenge Not yet complete... here's what's wrong:
We can't confirm the correct values were found. Please check your work.
kesava reddy 62kesava reddy 62
HI,

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
Alfio Dsilva 14Alfio Dsilva 14
Hi,

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
AnandAgrawalAnandAgrawal
This is an issue from Trailhead. So to resolve this issue change "Create Seed Bank Agencies" node name to "Seed Bank Agencies" and alias to "seed_bank_agencies". Then try "Check Challenge". Best of luck.
Alfio Dsilva 14Alfio Dsilva 14
Hi,

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 
Ashley Campisano 3Ashley Campisano 3
Hi,

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

 
Ankur Agarwal 32Ankur Agarwal 32
Hi,

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"
}
}
}
Prashant SHEWALKARPrashant SHEWALKAR

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
Vincenzo BarbaroVincenzo Barbaro
I'm facing a difference issue, it looks like the fiels ShippingPostalCode is not anymore available in the source file. 

User-added image
Archana ChandelArchana Chandel
I am also facing the same issue on Challenge #3 . I have check my dataflow multiple times even macthed it with what @LinThaw suggested and even tried changing the node name to  "Seed Bank Agencies" but it didn't resolve my issue. If it is an error with trailhed then please suggest whom should I reach out to? Below is the Json query ... Please 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": "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
 
Angad Gupta 3Angad Gupta 3
Hello ALl, 
I am getting this error in challenge 3 , I have created multiple time dataflow, dataset, lens etc but still having the same error

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


Lens

Kindly suggest for the corrections please.. 
Many thanks