Forum Discussion
Count, Where and Join
I am bringing in Objects from Salesforce, for example one object is contacts. I have over 8 mllion contacts in Salesforce and would like to only bring in the contacts that have a ICL Code. I tried...
Hi doliver29,
One you load the data into the query window, you can set a filter on a desired column prior to Close & Load.
Is this what you are looking for?
Dave
Hi Dave
No when I apply the filter and then do the dataload it still cycles thru the 8 million records before it displays in the filtered columns query so the refresh takes my users 30 minutes before they can access the report. I want the filter to occur before so when it refreshes it will take only a few minutes.
Thanks
Debbie