+ Start a Discussion
Rahul Sangwan7341Rahul Sangwan7341 

Wave Analytics (Edgemart) Error: Field [Payment_Amount] is missing in 1 out of 2 inputs Field.

{
  "Extract_PricebookEntry": {
    "action": "sfdcDigest",
    "parameters": {
      "SFDCtoken": "SFDCtoken",
      "maxAllowedOffset": 1500,
      "fields": [
        {
          "name": "Id"
        },
        {
          "name": "Product2Id"
        }
      ],
      "concurrentBatches": 12,
      "object": "PricebookEntry"
    }
  },
  "augment_Payment__c_Opportunity_2": {
    "action": "augment",
    "parameters": {
      "right_key": [
        "Id"
      ],
      "left": "sfdcDigest_Payment__c_2",
      "left_key": [
        "Opportunity__c"
      ],
      "right_select": [
        "Name",
        "Id",
        "AccountId",
        "OwnerId"
      ],
      "right": "sfdcDigest_Opportunity_2",
      "relationship": "Opportunity__c"
    }
  },
  "augment_Payment__c_Opportunity_0": {
    "action": "augment",
    "parameters": {
      "right_key": [
        "Id"
      ],
      "left": "sfdcDigest_Payment__c_0",
      "left_key": [
        "Opportunity__c"
      ],
      "right_select": [
        "Amount",
        "IsClosed",
        "Name",
        "Id",
        "AccountId",
        "OwnerId"
      ],
      "right": "sfdcDigest_Opportunity_0",
      "relationship": "Opportunity__c"
    }
  },
  "sfdcDigest_Payment__c_0": {
    "action": "sfdcDigest",
    "parameters": {
      "fields": [
        {
          "name": "Donor_Code__c"
        },
        {
          "name": "Name"
        },
        {
          "name": "Payment_Amount__c"
        },
        {
          "name": "Id"
        },
        {
          "name": "Opportunity__c"
        }
      ],
      "object": "Payment__c"
    }
  },
  "sfdcDigest_User": {
    "action": "sfdcDigest",
    "parameters": {
      "fields": [
        {
          "name": "IsActive"
        },
        {
          "name": "Name"
        },
        {
          "name": "Id"
        }
      ],
      "object": "User"
    }
  },
  "Join_OpportunityLineItemPricebookEntry": {
    "action": "augment",
    "parameters": {
      "right_key": [
        "Id"
      ],
      "left_key": [
        "PricebookEntryId"
      ],
      "left": "Extract_OpportunityLineItem",
      "right_select": [
        "Product2Id"
      ],
      "right": "Extract_PricebookEntry",
      "relationship": "Pricebook"
    }
  },
  "Extract_Opportunity": {
    "action": "sfdcDigest",
    "parameters": {
      "SFDCtoken": "SFDCtoken",
      "maxAllowedOffset": 1500,
      "fields": [
        {
          "name": "Id"
        },
        {
          "name": "AccountId"
        },
        {
          "name": "OwnerId"
        },
        {
          "name": "Name"
        },
        {
          "name": "StageName"
        },
        {
          "name": "LeadSource"
        },
        {
          "name": "IsWon"
        },
        {
          "name": "Type"
        },
        {
          "name": "IsClosed"
        },
        {
          "name": "ForecastCategory"
        },
        {
          "name": "ForecastCategoryName"
        },
        {
          "name": "CreatedDate"
        },
        {
          "name": "CloseDate"
        },
        {
          "name": "Amount"
        },
        {
          "name": "CreatedById"
        }
      ],
      "concurrentBatches": 12,
      "object": "Opportunity"
    }
  },
  "Join_AccountOwner": {
    "action": "augment",
    "parameters": {
      "right_key": [
        "Id"
      ],
      "left_key": [
        "OwnerId"
      ],
      "left": "Extract_Account",
      "right_select": [
        "Name",
        "Username"
      ],
      "right": "Extract_User",
      "relationship": "Owner",
      "operation": "LookupMultiValue"
    }
  },
  "sfdcDigest_Account": {
    "action": "sfdcDigest",
    "parameters": {
      "fields": [
        {
          "name": "Name"
        },
        {
          "name": "AccountSource"
        },
        {
          "name": "Type"
        },
        {
          "name": "Id"
        }
      ],
      "object": "Account"
    }
  },
  "augment_User": {
    "action": "augment",
    "parameters": {
      "right_key": [
        "Id"
      ],
      "left": "augment_Case_Account",
      "left_key": [
        "OwnerId"
      ],
      "right_select": [
        "IsActive",
        "Name"
      ],
      "right": "sfdcDigest_User",
      "relationship": "OwnerId"
    }
  },
  "Extract_Product": {
    "action": "sfdcDigest",
    "parameters": {
      "SFDCtoken": "SFDCtoken",
      "maxAllowedOffset": 1500,
      "fields": [
        {
          "name": "Id"
        },
        {
          "name": "ProductCode"
        },
        {
          "name": "Name"
        },
        {
          "name": "Family"
        }
      ],
      "concurrentBatches": 12,
      "object": "Product2"
    }
  },
  "sfdcDigest_Payment__c_2": {
    "action": "sfdcDigest",
    "parameters": {
      "fields": [
        {
          "name": "Donor_Code__c"
        },
        {
          "name": "Payment_Amount__c"
        },
        {
          "name": "Id"
        },
        {
          "name": "Opportunity__c"
        }
      ],
      "object": "Payment__c"
    }
  },
  "Extract_User": {
    "action": "sfdcDigest",
    "parameters": {
      "SFDCtoken": "SFDCtoken",
      "chunkSize": 1500,
      "maxAllowedOffset": 1500,
      "fields": [
        {
          "name": "Id"
        },
        {
          "name": "Username"
        },
        {
          "name": "Name"
        },
        {
          "name": "UserRoleId"
        },
        {
          "name": "ManagerId"
        }
      ],
      "concurrentBatches": 12,
      "object": "User"
    }
  },
  "sfdcDigest_User_1": {
    "action": "sfdcDigest",
    "parameters": {
      "fields": [
        {
          "name": "Name"
        },
        {
          "name": "Id"
        }
      ],
      "object": "User"
    }
  },
  "register_Payment with Donor_0": {
    "action": "sfdcRegister",
    "parameters": {
      "name": "Payment with Donor",
      "alias": "Payment_with_Donor",
      "source": "augment_User_0"
    }
  },
  "sfdcDigest_User_2": {
    "action": "sfdcDigest",
    "parameters": {
      "fields": [
        {
          "name": "Id"
        },
        {
          "name": "Name"
        }
      ],
      "object": "User"
    }
  },
  "Join_OpportunityOwner": {
    "action": "augment",
    "parameters": {
      "right_key": [
        "Id"
      ],
      "left_key": [
        "OwnerId"
      ],
      "left": "Join_OpportunityAccount",
      "right_select": [
        "Name",
        "Username"
      ],
      "right": "Extract_User",
      "relationship": "Owner",
      "operation": "LookupMultiValue"
    }
  },
  "sfdcDigest_User_0": {
    "action": "sfdcDigest",
    "parameters": {
      "fields": [
        {
          "name": "Name"
        },
        {
          "name": "Id"
        }
      ],
      "object": "User"
    }
  },
  "Join_OpportunityLineItemPricebookEntryProduct": {
    "action": "augment",
    "parameters": {
      "right_key": [
        "Id"
      ],
      "left_key": [
        "Pricebook.Product2Id"
      ],
      "left": "Join_OpportunityLineItemPricebookEntry",
      "right_select": [
        "ProductCode",
        "Name",
        "Family"
      ],
      "right": "Extract_Product",
      "relationship": "Product"
    }
  },
  "Register_OpportunityProducts": {
    "action": "sfdcRegister",
    "parameters": {
      "SFDCtoken": "SFDCtoken",
      "rowLevelSecurityFilter": "",
      "name": "Products Opportunities",
      "alias": "products_opportunities",
      "source": "Join_OpportunityOpportunityLineItemPricebookEntryProduct"
    }
  },
  "augment_Account_User_1": {
    "action": "augment",
    "parameters": {
      "right_key": [
        "Id"
      ],
      "left": "sfdcDigest_Account_1",
      "left_key": [
        "OwnerId"
      ],
      "right_select": [
        "Name",
        "Id"
      ],
      "right": "sfdcDigest_User_1",
      "relationship": "OwnerId"
    }
  },
  "sfdcDigest_Account_0": {
    "action": "sfdcDigest",
    "parameters": {
      "fields": [
        {
          "name": "Unique_Id__c"
        },
        {
          "name": "Name"
        },
        {
          "name": "Id"
        }
      ],
      "object": "Account"
    }
  },
  "Join_OpportunityAccount": {
    "action": "augment",
    "parameters": {
      "right_key": [
        "Id"
      ],
      "left_key": [
        "AccountId"
      ],
      "left": "Extract_Opportunity",
      "right_select": [
        "Name",
        "Type",
        "Industry",
        "BillingCountry",
        "BillingState",
        "AccountSource",
        "OwnerId",
        "Owner.Name"
      ],
      "right": "Join_AccountOwner",
      "relationship": "Account",
      "operation": "LookupMultiValue"
    }
  },
  "sfdcDigest_Account_2": {
    "action": "sfdcDigest",
    "parameters": {
      "fields": [
        {
          "name": "Name"
        },
        {
          "name": "Unique_Id__c"
        },
        {
          "name": "Id"
        }
      ],
      "object": "Account"
    }
  },
  "sfdcDigest_Account_1": {
    "action": "sfdcDigest",
    "parameters": {
      "fields": [
        {
          "name": "Name"
        },
        {
          "name": "Unique_Id__c"
        },
        {
          "name": "OwnerId"
        }
      ],
      "object": "Account"
    }
  },
  "register_Donor Data_1": {
    "action": "sfdcRegister",
    "parameters": {
      "name": "Donor Data",
      "alias": "Donor_Data",
      "source": "augment_Account_User_1"
    }
  },
  "augment_Account_2": {
    "action": "augment",
    "parameters": {
      "right_key": [
        "Id"
      ],
      "left": "augment_Payment__c_Opportunity_2",
      "left_key": [
        "Opportunity__c.AccountId"
      ],
      "right_select": [
        "Name",
        "Unique_Id__c",
        "Id"
      ],
      "right": "sfdcDigest_Account_2",
      "relationship": "Opportunity__c.AccountId"
    }
  },
  "augment_Account_0": {
    "action": "augment",
    "parameters": {
      "right_key": [
        "Id"
      ],
      "left": "augment_Payment__c_Opportunity_0",
      "left_key": [
        "Opportunity__c.AccountId"
      ],
      "right_select": [
        "Unique_Id__c",
        "Name"
      ],
      "right": "sfdcDigest_Account_0",
      "relationship": "Opportunity__c.AccountId"
    }
  },
  "augment_User_2": {
    "action": "augment",
    "parameters": {
      "right_key": [
        "Id"
      ],
      "left": "augment_Account_2",
      "left_key": [
        "Opportunity__c.OwnerId"
      ],
      "right_select": [
        "Id",
        "Name"
      ],
      "right": "sfdcDigest_User_2",
      "relationship": "Opportunity__c.OwnerId"
    }
  },
  "augment_Case_Account": {
    "action": "augment",
    "parameters": {
      "right_key": [
        "Id"
      ],
      "left": "sfdcDigest_Case",
      "left_key": [
        "AccountId"
      ],
      "right_select": [
        "Name",
        "AccountSource",
        "Type"
      ],
      "right": "sfdcDigest_Account",
      "relationship": "AccountId"
    }
  },
  "augment_User_0": {
    "action": "augment",
    "parameters": {
      "right_key": [
        "Id"
      ],
      "left": "augment_Account_0",
      "left_key": [
        "Opportunity__c.OwnerId"
      ],
      "right_select": [
        "Name",
        "Id"
      ],
      "right": "sfdcDigest_User_0",
      "relationship": "Opportunity__c.OwnerId"
    }
  },
  "Extract_Account": {
    "action": "sfdcDigest",
    "parameters": {
      "SFDCtoken": "SFDCtoken",
      "fields": [
        {
          "name": "Id"
        },
        {
          "name": "Name"
        },
        {
          "name": "OwnerId"
        },
        {
          "name": "AccountSource"
        },
        {
          "name": "Type"
        },
        {
          "name": "Industry"
        },
        {
          "name": "BillingCountry"
        },
        {
          "name": "BillingState"
        },
        {
          "name": "CreatedDate"
        },
        {
          "name": "LastModifiedDate"
        }
      ],
      "object": "Account"
    }
  },
  "Extract_OpportunityLineItem": {
    "action": "sfdcDigest",
    "parameters": {
      "SFDCtoken": "SFDCtoken",
      "maxAllowedOffset": 1500,
      "fields": [
        {
          "name": "OpportunityId"
        },
        {
          "name": "ProductCode"
        },
        {
          "name": "ListPrice"
        },
        {
          "name": "Quantity"
        },
        {
          "name": "TotalPrice"
        },
        {
          "name": "PricebookEntryId"
        }
      ],
      "concurrentBatches": 12,
      "object": "OpportunityLineItem"
    }
  },
  "Join_OpportunityOpportunityLineItemPricebookEntryProduct": {
    "action": "augment",
    "parameters": {
      "right_key": [
        "Id"
      ],
      "left_key": [
        "OpportunityId"
      ],
      "left": "Join_OpportunityLineItemPricebookEntryProduct",
      "right_select": [
        "Name",
        "StageName",
        "CloseDate",
        "IsWon",
        "Type",
        "IsClosed",
        "LeadSource",
        "ForecastCategory",
        "ForecastCategoryName",
        "CreatedDate",
        "AccountId",
        "Account.Name",
        "Account.OwnerId",
        "Account.Type",
        "Account.Industry",
        "Account.BillingCountry",
        "Account.BillingState",
        "Account.AccountSource",
        "Account.Owner.Name",
        "OwnerId",
        "Owner.Name"
      ],
      "right": "Join_OpportunityOwner",
      "relationship": "Opportunity"
    }
  },
  "sfdcDigest_Case": {
    "action": "sfdcDigest",
    "parameters": {
      "fields": [
        {
          "name": "Id"
        },
        {
          "name": "CaseNumber"
        },
        {
          "name": "Origin"
        },
        {
          "name": "Reason"
        },
        {
          "name": "Type"
        },
        {
          "name": "AccountId"
        },
        {
          "name": "OwnerId"
        }
      ],
      "object": "Case"
    }
  },
  "sfdcDigest_Opportunity_2": {
    "action": "sfdcDigest",
    "parameters": {
      "fields": [
        {
          "name": "Name"
        },
        {
          "name": "Id"
        },
        {
          "name": "AccountId"
        },
        {
          "name": "OwnerId"
        }
      ],
      "object": "Opportunity"
    }
  },
  "register_Salesforce Payments_2": {
    "action": "sfdcRegister",
    "parameters": {
      "name": "Salesforce Payments",
      "alias": "Salesforce_Payments",
      "source": "augment_User_2"
    }
  },
  "register_Cases with Accounts": {
    "action": "sfdcRegister",
    "parameters": {
      "name": "Cases with Accounts",
      "alias": "Cases_with_Accounts",
      "source": "augment_User"
    }
  },
  "sfdcDigest_Opportunity_0": {
    "action": "sfdcDigest",
    "parameters": {
      "fields": [
        {
          "name": "Amount"
        },
        {
          "name": "IsClosed"
        },
        {
          "name": "Name"
        },
        {
          "name": "Id"
        },
        {
          "name": "AccountId"
        },
        {
          "name": "OwnerId"
        }
      ],
      "object": "Opportunity"
    }
  },
  "Register_Opportunity": {
    "action": "sfdcRegister",
    "parameters": {
      "SFDCtoken": "SFDCtoken",
      "rowLevelSecurityFilter": "",
      "name": "Opportunities",
      "alias": "opportunities",
      "source": "Join_OpportunityOwner"
    }
  },
  "New_Payment_Ext": {
    "action": "edgemart",
    "parameters": {
      "alias": "New_Payment_CSV"
    }
  },
  "New_Payment_SF": {
    "action": "edgemart",
    "parameters": {
      "alias": "Salesforce_Payments"
    }
  },
  "Append_Payments_All": {
    "action": "append",
    "parameters": {
      "sources": [
        "New_Payment_Ext",
        "New_Payment_SF"
      ]
    }
  }
}
 
Failed
Something went wrong while executing the Append_Payments_All node: Field [Payment_Amount] is missing in 1 out of 2 inputs Field [Opportunity__c.AccountId.Name] is missing in 1 out of 2 inputs Field [Opportunity__c.OwnerId.Name] is missing in 1 out of 2 inputs Field [Donor_Code__c] is missing in 1 out of 2 inputs Field [Opportunity_c_AccountId_Name] is missing in 1 out of 2 inputs Field [Opportunity_c_OwnerId] is missing in 1 out of 2 inputs Field [Opportunity__c.OwnerId] is missing in 1 out of 2 inputs Field [Opportunity_c_IsClosed] is missing in 1 out of 2 inputs Field [Opportunity_c_OwnerId_Name] is missing in 1 out of 2 inputs Field [Opportunity__c] is missing in 1 out of 2 inputs Field [Name] is missing in 1 out of 2 inputs Field [Opportunity__c.Id] is missing in 1 out of 2 inputs Field [Opportunity_c_Name] is missing in 1 out of 2 inputs Field [Opportunity_c_OwnerId_Id] is missing in 1 out of 2 inputs Field [Donor_Code] is missing in 1 out of 2 inputs Field [Opportunity__c.AccountId.Unique_Id__c] is missing in 1 out of 2 inputs Field [Opportunity_c_Amount] is missing in 1 out of 2 inputs Field [Opportunity_c_AccountId] is missing in 1 out of 2 inputs Field [Payment_Amount__c] is missing in 1 out of 2 inputs Field [Id] is missing in 1 out of 2 inputs Field [Opportunity] is missing in 1 out of 2 inputs Field [Payment_Name] is missing in 1 out of 2 inputs Field [Opportunity__c.Name] is missing in 1 out of 2 inputs Field [Opportunity__c.Amount] is missing in 1 out of 2 inputs Field [Opportunity__c.OwnerId.Id] is missing in 1 out of 2 inputs Field [Opportunity__c.IsClosed] is missing in 1 out of 2 inputs Field [Opportunity_c_AccountId_Unique_Id__c] is missing in 1 out of 2 inputs Field [Record_ID] is missing in 1 out of 2 inputs Field [Opportunity_c_Id] is missing in 1 out of 2 inputs Field [Opportunity__c.AccountId] is missing in 1 out of 2 inputs (02K7F000000l59MUAQ_03C7F000000nK3dUAE)


I checked the fileds of my CSV and Excel they are same, in name and sequence. I am not getting any idea, why i am getting this error.