You need to sign in to do that
Don't have an account?
Rahul 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. |