Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I'm connected to SalesForce.com via the Custom Connect API and I'm running the script below. I see rows being pulled for both SQL statements when executing the script. However, no data is stored in the output file, and no data appears in a TableBox object. Where the heck did the data go? Thanks, Dan
Test1:
Load Account__c as AccountId,
BAN__c,
Id,
Name,
Tax_ID__c;
SQL SELECT Account__c,
BAN__c,
Id,
Name,
Tax_ID__c
FROM Account_BAN_Tax_ID__c;
Test2:
Inner Join
Load *,
Id as AccountId;
SQL SELECT BANs__c,
Id,
LastActivityDate,
Total_Sims__c
FROM Account
WHERE Id In (Select Account__c From Account_BAN_Tax_ID__c);
Store Test1 into L:\SalesServiceFinancialAnalytics\FinanceAnalytics\Sales_Analytics\DMagnus\Qlikview\Test1.csv(txt);
Hi Dan,
I mimicked your script and had success getting Case and Account data. I'm using QV 11.2 SR6 and connector version 12 with url to force API version 30.0. I only limited my data to the last 30 days though. I would say that its possible your Id field 'Account__c' in 'Account_BAN_Tax_ID__c' isn't? Make sure they are. Check to see if they're 15 or 18 characters.
HTH,
John
Here's my code;
Test1:
LOAD AccountId,
CaseNumber,
Description,
Subject,
Category__c,
Type_Level_2__c,
Area_Level_3__c;
SELECT AccountId,
CaseNumber,
Description,
Subject,
Category__c,
Type_Level_2__c,
Area_Level_3__c
FROM Case
Where CreatedDate = LAST_N_DAYS:30;
Test2:
Inner Join
LOAD
Id as AccountId,
Name,
District__c;
SELECT Id,
Name,
District__c
FROM Account
Where Id In (Select AccountId From Case);