function readOnly(count){ }
Sign Up ›
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
Learn More

Browse by Topic
ShowAll Questionssorted byDate Posted
+ Start a Discussion
sangam vvsangam vv 

Data Loader Question?

Guys how to control this scenario,
Eg;I have one picklist Lead source:
                                                 Phone,Email,Web
now when i am insering new record using data loader lead source values is different(Paper,Tv) i want to avoid these thing i want to insert only what are the records have lead source values how to do this?
How to avoid Unnecessary picklist values?
Vivek DVivek D
In custom picklist fields you can select strictly enforce picklist values. Which will not allow any other value in the picklist. In data loader it will start throwing error if the picklist values don’t match to the actual values
Maharajan CMaharajan C
Hi Sangam,

To avoid those values  you can easily done by using the Filter in Excel.

1) Select the Lead Source rows in the Excel->Sort and Filter ICON In HOME->Filter.
2) After that click the Drop Down button in that Top Row Value Which is in the Lead Source.
3)Choose the Phone,Email,Web in the Checkboxes->OK.
4) Copy the Filtered Values and paste it in another Excel Sheet->save as CSV file
5) Then insert that file using dataloader

Because we can't use the Filter Condition in Dataloader during the insert opertaion.But we can using filter in Export Opertaion in Dataloader.

Thanks,
Raj.