You need to sign in to do that
Don't have an account?
sangam 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?
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?
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.