You need to sign in to do that
Don't have an account?
HiteshP
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.
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"
]
}
}
}
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.
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"
]
}
}
}
Changed : Operation form "operation": "LookupSingleValue" to "LookupMultipleValue" in "Add Agency Detail Fields" stage.
All Answers
Changed : Operation form "operation": "LookupSingleValue" to "LookupMultipleValue" in "Add Agency Detail Fields" stage.
I am still getting the below error even after chagned to "LookupMultipleValue" in "Add Agency Detail Fields" . My Lense is exactly same as yours.
Thank you,
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"
}
}
}
Hi
Can anyone please help in challenge 7. from where to uplaod the broken dataflow?
Hi Satabhisa,
The JSON file is on the Step1 zip file.
Download ea-data-preparation-specialist-data.zip and save it to your desktop.
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"
}
}
}
{
"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"
]
}
}
}
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
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!
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"
]
}
}
}
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"
}
]
}
}
}
{ "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" } ] } } }