function readOnly(count){ }
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
+ 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
Avanish KAvanish K
Hi @Angad Gupta 3

I am also facing same issue. I have same JSON and Same LENs. I tried in 2-3 orgs but no luck. 

Could you please help me if your issue resolved.

Thanks
Avanish
Naveen NarravulaNaveen Narravula
Determine Optimal Climates - is the challenge I am working.
Challenge Not yet complete... here's what's wrong:
We can't find the 'Create Seed Bank' node or required fields, such as 'TempClass', are missing. Check the challenge and confirm the node name and required fields.
Close errors
Can anyone help!User-added image
Avanish KAvanish K
@Naveen COuld you please help me with challenge 3
hongtranhongtran
Hello, I re-uploaded Agency Detail dataset with Latitude and Longitude as Dimension, not Measure. Then error on step 3 with "Create Seed Bank Agencies" node was resolved.
 
Almond LIAlmond LI
Hi hongtran,
Thank you so much! Your suggestion helps resolving the problem.
Tommy JungTommy Jung
@Hongtan,

thanks - works! 

 
Mateusz Nitek 5Mateusz Nitek 5
Hey,

Was someone able to solve this mysterious step 3?

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.

I tried everything, also on another org with Agencies Details with geo locations as dimensions, but then I was getting other error.

Here you can find my json
{
  "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": "ShippingCity"
        },
        {
          "name": "ShippingCountry"
        },
        {
          "name": "ShippingPostalCode"
        },
        {
          "name": "ShippingState"
        },
        {
          "name": "Phone"
        },
        {
          "name": "ShippingStreet"
        }
      ],
      "object": "Account"
    }
  },
  "Create Seed Bank Agencies": {
    "action": "sfdcRegister",
    "parameters": {
      "name": "Create Seed Bank Agencies",
      "alias": "seed_bank_agencies",
      "source": "Drop IsAgency"
    }
  },
  "Drop IsAgency": {
    "action": "sliceDataset",
    "parameters": {
      "mode": "drop",
      "source": "Filter Agency Records",
      "fields": [
        {
          "name": "IsAgency"
        }
      ]
    }
  },
  "Add Agency Fields": {
    "action": "augment",
    "parameters": {
      "right_key": [
        "AccountNumber"
      ],
      "left": "Load Account",
      "left_key": [
        "AccountNumber"
      ],
      "right_select": [
        "Currency",
        "Region",
        "SubRegion",
        "Latitude",
        "Acres",
        "Longitude"
      ],
      "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"
        }
      ]
    }
  }
}

and the screenshot
User-added image
I have created the Lens, and everythng seems fine.
Roshani KatreRoshani Katre
Hi,
I am also facing the same error while completing "Create Seed Bank Agencies" challenge in superbadge "Tableau CRM Data Preparation Specialist" . Need help.
User-added image

Here is my Json:
{
  "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": "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": [
        "Currency",
        "Acres",
        "SubRegion",
        "Region",
        "Latitude",
        "Longitude"
      ],
      "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"
        }
      ]
    }
  }
}
Trygve GrundvikTrygve Grundvik
Hi all,

I am getting a mysterious error when attempting to verify #4 Create Seed Bank Agencies that has not been covered yet in this thread. Functionally the generated dataset works perfectly and the lens was created too without any issues after making countless changes as outlined in this thread, but the challenge can still not be verified as attested by the attached screenshot. I have stuck to all outlined naming conventions and as mentioned, the dataflow and dataset actually functionally work perfectly. Please find my JSON below as well. Any help on this would be greatly appreciated.

{
  "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": [
        "Currency",
        "Region",
        "SubRegion",
        "Latitude",
        "Acres",
        "Longitude"
      ],
      "right": "Load Agency Detail",
      "relationship": "AgencyDetail",
      "operation": "LookupSingleValue"
    }
  },
  "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 Agency Detail": {
    "action": "edgemart",
    "parameters": {
      "alias": "Agency_Detail"
    }
  }
}


User-added image
Yousuf ZamanYousuf Zaman
Hi,
I was facing the same issue, and tried in several different ways to resovle.
Finally I was able to fix. While uploading the "Agency Detail.txt" dataset (had to modify and apply different changes while uploading this dataset), convert the Latitude and Longitude to Dimension, and keep the Acre as is.  Recreated the dataflow from the sratch and this time it works fine.

Regards.
Yousuf Zaman.
Arya SwatantraveerArya Swatantraveer

Hi Team, 

I am facing the below issue when I am trying to finish my "Step 4" challenge in "CRM Analytics Data Preparation Specialist".
Can someone help how to solve this? 


I have successfully created
1) Dataflow to create a dataset named "Seed Bank Agencies" (which is in the SharedApp location and not in the 'Mosaic' app location) and
2) Lense inside "Mosaic" app to show  'Top 5 Crop Seeds lens that displays acreage for the top 5 seeds in the Seed Bank'


Below is the error I get (Screenshot attached below after the error text) when I am trying to finish my "Step 4" challenge
"There was an unhandled exception. Please reference ID: EJHONRIJ. Error: Restforce::ResponseError. Message: FUNCTIONALITY_NOT_ENABLED: This feature is not currently enabled for this user."
Step 4 error I get


 

Arya SwatantraveerArya Swatantraveer
I was able to fix this by connecting my Dev Org to my Trailblazer.

Help found from this page: https://trailhead.salesforce.com/trailblazer-community/feed/0D54S00000A8ukeSAB
Thomas Shelby 26Thomas Shelby 26
An online retailer called Wee Seeds Store sells a variety of organic and natural goods for kids and families. https://justcannabisseed.com/weed-seeds-shop/