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
HiteshPHiteshP 

Einstein Analytics Data Preparation Specialist #7

Hello Experts,

I'm getting below error on setup # 7. 

Challenge Not yet complete... here's what's wrong:
Couldn’t find the correct values. Please check your work.

User-added image

Json:
{
  "Add Temp Class": {
    "action": "computeExpression",
    "parameters": {
      "source": "Filter 2015",
      "mergeWithSource": true,
      "computedFields": [
        {
          "name": "TempClass",
          "label": "TempClass",
          "type": "Text",
          "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",
          "defaultValue": "\"Continental\""
        }
      ]
    }
  },
  "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": {
      "left": "Add Temp Class",
      "right": "Load Account",
      "relationship": "AugmentTempClass",
      "operation": "LookupSingleValue",
      "left_key": [
        "Country"
      ],
      "right_key": [
        "ShippingCountry"
      ],
      "right_select": [
        "AccountNumber",
        "Name",
        "Phone",
        "ShippingCity",
        "ShippingCountry",
        "ShippingPostalCode",
        "ShippingState",
        "ShippingStreet"
      ]
    }
  },
  "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": {
      "left": "Load Account",
      "right": "Load Agency",
      "relationship": "AgencyDetail",
      "operation": "LookupSingleValue",
      "left_key": [
        "AccountNumber"
      ],
      "right_key": [
        "AccountNumber"
      ],
      "right_select": [
        "AccountNumber",
        "Acres",
        "Currency",
        "Latitude",
        "Longitude",
        "Region",
        "SubRegion"
      ]
    }
  },
  "ID Agency Records": {
    "action": "computeExpression",
    "parameters": {
      "source": "Add Agency Detail Fields",
      "mergeWithSource": true,
      "computedFields": [
        {
          "name": "IsAgency",
          "label": "IsAgency",
          "type": "Text",
          "saqlExpression": "case when Phone is not null then \"TRUE\" else \"FALSE\" end"
        }
      ]
    }
  },
  "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": {
      "left": "Augment Temp Class",
      "right": "ID Agency Records",
      "relationship": "Climate",
      "operation": "LookupSingleValue",
      "left_key": [
        "AugmentTempClass.AccountNumber"
      ],
      "right_key": [
        "AccountNumber"
      ],
      "right_select": [
        "AccountNumber",
        "IsAgency",
        "Name",
        "Phone",
        "ShippingCity",
        "ShippingCountry",
        "ShippingPostalCode",
        "ShippingState",
        "ShippingStreet"
      ]
    }
  }
}
 
Best Answer chosen by HiteshP
HiteshPHiteshP
It is resolved now :) 

Changed : Operation form "operation": "LookupSingleValue" to "LookupMultipleValue" in "Add Agency Detail Fields" stage. 

All Answers

HiteshPHiteshP
It is resolved now :) 

Changed : Operation form "operation": "LookupSingleValue" to "LookupMultipleValue" in "Add Agency Detail Fields" stage. 
This was selected as the best answer
GithagGithag
Hi Hitesh,
I am still getting the below error even after chagned to "LookupMultipleValue" in "Add Agency Detail Fields" . My Lense is exactly same as yours. 

User-added image
Thank you,
Githa
HiteshPHiteshP
Hi Githa,

below was my final working JASON. Pleasae check

{
  "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"
    }
  }
}
Satabhisa RoySatabhisa Roy

Hi

Can anyone please help in challenge 7. from where to uplaod the broken dataflow?

SoumyaRanjan SahooSoumyaRanjan Sahoo

Hi Satabhisa,

The JSON file is on the Step1 zip file.

Download ea-data-preparation-specialist-data.zip and save it to your desktop.

Nitin verma 22Nitin verma 22
Hello 
i am stuck in challenge 7. 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.
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"
        }
      ]
    }
  },
  "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"
    }
  }
}
Naga VarshiniNaga Varshini
If you are facing the challenge completion error inspite of successfull run of dataflow and creation of lens, delete all the components and start fresh. This worked for me. Seems like a salesforce glitch.
Vipul Somanna P NVipul Somanna P N
Thanks @Naga Varshini, it worked for me!
Zia Ansari 19Zia Ansari 19
Here is my working JSON... 

{
  "Load Agency": {
    "action": "edgemart",
    "parameters": {
      "alias": "Agency_Detail"
    }
  },
  "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"
        }
      ]
    }
  },
  "Filter Agency Records": {
    "action": "filter",
    "parameters": {
      "filter": "Agency:EQ:false",
      "source": "ID Agency Record"
    }
  },
  "Load Account": {
    "action": "sfdcDigest",
    "parameters": {
      "fields": [
        {
          "name": "AccountNumber"
        },
        {
          "name": "Name"
        },
        {
          "name": "Phone"
        },
        {
          "name": "ShippingCity"
        },
        {
          "name": "ShippingCountry"
        },
        {
          "name": "ShippingPostalCode"
        },
        {
          "name": "ShippingState"
        },
        {
          "name": "ShippingStreet"
        }
      ],
      "object": "Account"
    }
  },
  "Load Seed Orders": {
    "action": "edgemart",
    "parameters": {
      "alias": "Seed_Bank_Orders"
    }
  },
  "Create Order Historyz": {
    "action": "sfdcRegister",
    "parameters": {
      "name": "Order History",
      "alias": "order_history",
      "source": "Add Seed Orders"
    }
  },
  "Augment Temp Class": {
    "action": "augment",
    "parameters": {
      "left": "Load Account",
      "right": "Add Temp Class",
      "relationship": "Climate",
      "operation": "LookupSingleValue",
      "left_key": [
        "ShippingCountry"
      ],
      "right_key": [
        "Country"
      ],
      "right_select": [
        "TempClass"
      ]
    }
  },
  "Load Climate": {
    "action": "edgemart",
    "parameters": {
      "alias": "Global_Climates"
    }
  },
  "Filter 2015": {
    "action": "filter",
    "parameters": {
      "filter": "Date_Year:EQ:2015",
      "source": "Load Climate"
    }
  },
  "Add Agency Fields": {
    "action": "augment",
    "parameters": {
      "operation": "LookupSingleValue",
      "left": "Augment Temp Class",
      "right": "Load Agency",
      "relationship": "NA",
      "left_key": [
        "AccountNumber"
      ],
      "right_key": [
        "AccountNumber"
      ],
      "right_select": [
        "Acres",
        "Currency",
        "Latitude",
        "Longitude",
        "Region",
        "SubRegion"
      ]
    }
  },
  "ID Agency Record": {
    "action": "computeExpression",
    "parameters": {
      "mergeWithSource": true,
      "source": "Add Agency Fields",
      "computedFields": [
        {
          "type": "Text",
          "name": "Agency",
          "label": "Agency",
          "saqlExpression": "case when Phone is not null then \"TRUE\" else \"FALSE\" end"
        }
      ]
    }
  },
  "Add Seed Orders": {
    "action": "augment",
    "parameters": {
      "operation": "LookupSingleValue",
      "left": "Load Seed Orders",
      "relationship": "SeedOrders",
      "right": "Filter Agency Records",
      "left_key": [
        "Agency_ID"
      ],
      "right_key": [
        "AccountNumber"
      ],
      "right_select": [
        "Agency",
        "Climate.TempClass",
        "NA.Acres",
        "NA.Currency",
        "NA.Latitude",
        "NA.Longitude",
        "NA.Region",
        "NA.SubRegion",
        "Name",
        "Phone",
        "ShippingCity",
        "ShippingCountry",
        "ShippingPostalCode",
        "ShippingState",
        "ShippingStreet"
      ]
    }
  }
}
Helman ReyesHelman Reyes
I did the @Naga Varshini solution and it worked for me:
1. Delete lense
2. Delete Data set
3. Backup dataflow Json
4. Delete dataflow
5 Create dataflow again and upload saved json
6 create data set and lense
7 Celebrate!!!
thank you Naga I was stucked
Prasanna CherlopallePrasanna Cherlopalle
Hi @Nitin verma 22
Challenge Not yet complete... here's what's wrong:
We can't confirm the correct values were found. Please check your work.

A couple of things that I missed and encountered the 'Can't confirm' error are
1. Dataset alias name - make sure it is all lower case and with an underscore. 
2. I also missed adding focus to the lens.
Fixing those two issues helped me clear the super badge.
Hope it helps!

 
ANUJ GOYAL 8ANUJ GOYAL 8
My dataflow is showing error. Can someone  help?
Here is my Json
{
  "Load Agency": {
    "action": "edgemart",
    "parameters": {
      "alias": "Agency_Detail"
    }
  },
  "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"
        }
      ]
    }
  },
  "Filter Agency Records": {
    "action": "filter",
    "parameters": {
      "filter": "Agency:equals:false",
      "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"
    }
  },
  "Load Seed Orders": {
    "action": "edgemart",
    "parameters": {
      "alias": "seed_bank_agencies"
    }
  },
  "Create Order History": {
    "action": "sfdcRegister",
    "parameters": {
      "name": "Order History",
      "alias": "order_history",
      "source": "Add Seed Orders"
    }
  },
  "Augment Temp Class": {
    "action": "augment",
    "parameters": {
      "left": "Load Account",
      "right": "Add Temp Class",
      "relationship": "Climate",
      "operation": "LookupSingleValue",
      "left_key": [
        "ShippingCountry"
      ],
      "right_key": [
        "ShippingCountry"
      ],
      "right_select": [
        "TempClass",
        "Climate.TempClass1",
        "Climate.TempClass2",
        "AgencyDetail.Region",
        "IsAgency",
        "Climate.TempClass",
        "AccountNumber",
        "Name",
        "ShippingStreet",
        "AgencyDetail.Longitude",
        "AgencyDetail.Latitude",
        "Phone",
        "AgencyDetail.SubRegion",
        "ShippingPostalCode",
        "AgencyDetail.Currency",
        "ShippingCountry",
        "ShippingCity",
        "ShippingState",
        "Id",
        "AgencyDetail.Acres"
      ]
    }
  },
  "Load Climate": {
    "action": "edgemart",
    "parameters": {
      "alias": "seed_bank_agencies"
    }
  },
  "Filter 2015": {
"action": "computeExpression",
"parameters": {
"source": "Load Climate",
"mergeWithSource": true,
"computedFields": [
{
"saqlExpression": "Date_Year:EQ:2015",
"name": "Date_Year",
"label": "Date_Year",
"type": "Text"
}
]
}
},
  "Add Agency Fields": {
    "action": "append",
    "parameters": {
      "sources": [
        "Augment Temp Class",
        "Load Agency"
      ],
      "enableDisjointedSchemaMerge": false
    }
  },
  "Add Seed Orders": {
    "action": "append",
    "parameters": {
      "sources": [
        "Filter Agency Records",
        "Load Seed Orders"
      ]
    }
  }
}
Ruy AguilarRuy Aguilar
Can someone help? I have tried this for hours with no luck. I have rebuilt this Dataflows from scratch probably 10 times. Running them and fixing the problems one by one. I have also tried uploading the JSON found on this thread and used that instead and I still do not get the challenge completed. 

Here is my JSON: 

{
  "Load Agency": {
    "action": "edgemart",
    "parameters": {
      "alias": "Agency_Detail"
    }
  },
  "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"
        }
      ]
    }
  },
  "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"
    }
  },
  "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": [
        "Country"
      ],
      "left": "Load Account",
      "left_key": [
        "ShippingCountry"
      ],
      "right_select": [
        "TempClass"
      ],
      "right": "Add Temp Class",
      "relationship": "Climate",
      "operation": "LookupSingleValue"
    }
  },
  "Load Climate": {
    "action": "edgemart",
    "parameters": {
      "alias": "Global_Climates"
    }
  },
  "Add Seed Orders": {
    "action": "augment",
    "parameters": {
      "right_key": [
        "AccountNumber"
      ],
      "left": "Load Seed Orders",
      "left_key": [
        "Agency_ID"
      ],
      "right_select": [
        "AccountNumber",
        "Climate.AccountNumber",
        "Climate.Acres",
        "Climate.Currency",
        "Climate.Latitude",
        "Climate.Longitude",
        "Climate.Region",
        "Climate.SubRegion",
        "Climate.TempClass",
        "IsAgency",
        "Name",
        "Phone",
        "ShippingCity",
        "ShippingCountry",
        "ShippingPostalCode",
        "ShippingState",
        "ShippingStreet"
      ],
      "right": "Filter Agency Records",
      "relationship": "SeedOrders",
      "operation": "LookupSingleValue"
    }
  },
  "Add Agency Fields": {
    "action": "augment",
    "parameters": {
      "right_key": [
        "AccountNumber"
      ],
      "left": "Augment Temp Class",
      "left_key": [
        "AccountNumber"
      ],
      "right_select": [
        "AccountNumber",
        "Acres",
        "Currency",
        "Latitude",
        "Longitude",
        "Region",
        "SubRegion"
      ],
      "right": "Load Agency",
      "relationship": "Climate",
      "operation": "LookupSingleValue"
    }
  },
  "Filter 2015": {
    "action": "filter",
    "parameters": {
      "filter": "Date_Year:EQ:2015",
      "source": "Load Climate"
    }
  },
  "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"
        }
      ]
    }
  }
}
 
Senzo XabaSenzo Xaba
Also facing the same problem; tried every suggestion I could find online. Even created a new developer org, still getting the same error. Here's my JSON 

{ "Load Agency": { "action": "edgemart", "parameters": { "alias": "Agency_Detail" } },

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

"Filter Agency Records": { "action": "filter", "parameters": { "filter": "Agency:EQ:false", "source": "ID Agency Record" } }, "Load Account": { "action": "sfdcDigest", "parameters": { "fields": [ { "name": "AccountNumber" }, { "name": "Name" }, { "name": "Phone" }, { "name": "ShippingCity" }, { "name": "ShippingCountry" }, { "name": "ShippingPostalCode" }, { "name": "ShippingState" }, { "name": "ShippingStreet" } ], "object": "Account" } }, "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": [ "Country" ], "left": "Load Account", "left_key": [ "ShippingCountry" ], "right_select": [ "TempClass" ], "right": "Add Temp Class", "relationship": "Climate", "operation": "LookupSingleValue" } },

"Load Climate": { "action": "edgemart", "parameters": { "alias": "Global_Climates" } }, "Add Seed Orders": { "action": "augment", "parameters": { "right_key": [ "AccountNumber" ], "left": "Load Seed Orders", "left_key": [ "Agency_ID" ], "right_select": [ "Agency", "Climate.TempClass", "Name", "Phone", "ShippingCity", "ShippingCountry", "ShippingPostalCode", "ShippingState", "ShippingStreet", "AgencyTemp.Currency", "AgencyTemp.Region", "AgencyTemp.SubRegion", "AgencyTemp.Latitude", "AgencyTemp.Acres", "AgencyTemp.Longitude" ], "right": "Filter Agency Records", "relationship": "SeedOrders", "operation": "LookupSingleValue" } },

"Add Agency Fields": { "action": "augment", "parameters": { "left": "Augment Temp Class", "right": "Load Agency", "relationship": "AgencyTemp", "operation": "LookupSingleValue", "left_key": [ "AccountNumber" ], "right_key": [ "AccountNumber" ], "right_select": [ "Acres", "Currency", "Latitude", "Longitude", "Region", "SubRegion" ] } }, "Filter 2015": { "action": "filter", "parameters": { "filter": "Date_Year:EQ:2015", "source": "Load Climate" } },

"ID Agency Record": { "action": "computeExpression", "parameters": { "source": "Add Agency Fields", "mergeWithSource": true, "computedFields": [ { "name": "Agency", "saqlExpression": "case when Phone is not null then \"TRUE\" else \"FALSE\" end", "label": "Agency", "type": "Text" } ] } } }
Austin GartmanAustin Gartman
Facing the same issue as above. Unable to complete badge due to "Can't confirm your the correct values"
Below is my JSON
{
  "Add Temp Class": {
    "action": "computeExpression",
    "parameters": {
      "source": "Filter 2015",
      "mergeWithSource": true,
      "computedFields": [
        {
          "defaultValue": "Continental",
          "name": "TempClass",
          "saqlExpression": "case\nwhen  Temperature < 25 then \"Polar\"\nwhen Temperature >= 25 and Temperature <= 50 then \"Cool\"\nwhen Temperature >= 51 and Temperature <= 85 then \"Continental\"\nwhen Temperature > 85 then \"Tropical\"\nend",
          "label": "TempClass",
          "type": "Text"
        }
      ]
    }
  },
  "Load Agency": {
    "action": "edgemart",
    "parameters": {
      "alias": "Agency_Detail"
    }
  },
  "Filter Agency Records": {
    "action": "filter",
    "parameters": {
      "source": "Id Agency Records",
      "saqlFilter": "IsAgency == \"True\""
    }
  },
  "Id Agency Records": {
    "action": "computeExpression",
    "parameters": {
      "source": "Add Agency Detail Fields",
      "mergeWithSource": true,
      "computedFields": [
        {
          "name": "IsAgency",
          "saqlExpression": "case\nwhen Phone is not null then \"True\"\nelse \"False\"\nend",
          "label": "IsAgency",
          "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"
    }
  },
  "Load Account": {
    "action": "sfdcDigest",
    "parameters": {
      "fields": [
        {
          "name": "AccountNumber"
        },
        {
          "name": "Name"
        },
        {
          "name": "Phone"
        },
        {
          "name": "ShippingCity"
        },
        {
          "name": "ShippingCountry"
        },
        {
          "name": "ShippingPostalCode"
        },
        {
          "name": "ShippingState"
        },
        {
          "name": "ShippingStreet"
        }
      ],
      "object": "Account"
    }
  },
  "Augment Temp Class": {
    "action": "augment",
    "parameters": {
      "right_key": [
        "Country"
      ],
      "left": "Filter Agency Records",
      "left_key": [
        "ShippingCountry"
      ],
      "right_select": [
        "Date",
        "TempClass",
        "Temperature",
        "Country"
      ],
      "right": "Add Temp Class",
      "relationship": "Climate",
      "operation": "LookupSingleValue"
    }
  },
  "Load Climate": {
    "action": "edgemart",
    "parameters": {
      "alias": "Global_Climates"
    }
  },
  "Add Seed Orders": {
    "action": "augment",
    "parameters": {
      "right_key": [
        "AccountNumber"
      ],
      "left": "Load Seed Orders",
      "left_key": [
        "Agency_ID"
      ],
      "right_select": [
        "Name",
        "Phone",
        "ShippingCity",
        "ShippingCountry",
        "ShippingPostalCode",
        "ShippingState",
        "ShippingStreet",
        "Climate.TempClass",
        "AccountNumber"
      ],
      "right": "Augment Temp Class",
      "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": [
        "Currency",
        "Region",
        "Latitude",
        "Longitude",
        "SubRegion",
        "Acres",
        "AccountNumber"
      ],
      "right": "Load Agency",
      "relationship": "AgencyDetails",
      "operation": "LookupMultiValue"
    }
  }
}