Skip to main content
Topics#Data ManagementKelly Allison's Question
Kelly Allison asked in #Data Management
Mar 9, 2012, 6:14 PM

How can you select multiple picklist (ex. countries) in DataLoader for an export

In Data I chose all the fields that I want to export and am having problems with adding multiple conditions.  Here is an example of my query -

 

Select Id, Name, ParentId, OwnerId, Region__c, Country__c, SA__c, Operator__c, Rig_Type__c, Shaker_Quantity__c, Shaker_Manufacturer__c, Shaker_Type__c, Derrick_Screen_Type__c, Screen_Manufacturer__c, Project_Type__c FROM Account WHERE RecordTypeId = '012C0000000GD6J' AND Country__c = 'Australia'

 

In the "Country_c='Australia'" I want to add multiple countries to this condition but wasn't sure how to do this via DataLoader.
1 answer
  1. Matthew Lamb (10K Advisors)
    Mar 10, 2012, 3:36 AM
    You can edit the query manually in Data Loader, something like:

     

    AND ( Country__c = 'Australia' OR Country__c = 'Germany' OR ... )
Write an answer...
0/9000