Connect to SalesForce

Thu, 16 Dec 2010 08:12:05 GMT

Hi All,

I run into the following scenario:

I have one SF table named Actual: it has 10 records.

Id, name, OppID

And another table named Opportunity: It has 1000 records.

OppID, Amount.

Now I want to connect Acual to Opportunity with OppID that is a primary key in Opportunity table.

The clause like this;

QVTable:

SQL select Id, name, OppID from Actual;

inner join select OppID, Amount from Opportunity;

But when I load the data, the popup window shows 10 records into Actual, 1000 records into Opportunity.

I think the results should 10 after doing inner join, right?

WIll that 1000 records also be saved in local?

In fact, my Actual table has 100 records, but my Opportunity has 500,000, my concern is why just do a little inner join should load that 500,00 records from Opportunity? I will spend much more time on loading that 500,000, I just want to get the inner join results.

Could experts help me out? Or how to do it?

Many many thanks.

Isaac Li

topic Connect to SalesForce in QlikView

Connect to SalesForce