i****i
发帖数: 18 | 1 Sorry to type in English at office.
I need to import several thousand records into Salesforce, and create a new
list of unique accounts, which is the first step in import.
I was wondering how to eliminate the duplicates, and at the same time, to
preserve all valuable information. (For example, I need to keep as much
information, such as Email, Telephone for the account)
AccountName Email Telephone
Alcee Duplessis Household (985) 703-0 | i****a
发帖数: 36252 | 2 SQL 2008?
use MERGE
example:
MERGE INTO dbo.Customers AS TGT
USING dbo.CustomersStage AS SRC
ON TGT.custid = SRC.custid
WHEN MATCHED AND TGT.companyname <> SRC.companyname THEN
UPDATE SET
TGT.companyname = SRC.companyname,
TGT.phone = SRC.phone,
TGT.address = SRC.address
WHEN NOT MATCHED THEN
INSERT (custid, companyname, phone, address)
VALUES (SRC.custid, SRC.companyname, SRC.phone, SRC.address)
WHEN NOT MATCHED BY SOURCE THEN
DELETE
OUTPUT
$action, deleted.custid AS de
【在 i****i 的大作中提到】
: Sorry to type in English at office.
: I need to import several thousand records into Salesforce, and create a new
: list of unique accounts, which is the first step in import.
: I was wondering how to eliminate the duplicates, and at the same time, to
: preserve all valuable information. (For example, I need to keep as much
: information, such as Email, Telephone for the account)
: AccountName Email Telephone
: Alcee Duplessis Household (985) 703-0
| i****i
发帖数: 18 | 3 Thank you so much.... We did not use the MS SQL... that is a problem. | i****a
发帖数: 36252 | 4 don't know salesforce. if you are doing this inside salesforce then have to
look at their documents.
or maybe a big cow here knows salesforce... | y****w
发帖数: 3747 | 5 what happens if your account has two different phone #?
new
(985) 703-0013
0013
【在 i****i 的大作中提到】
: Sorry to type in English at office.
: I need to import several thousand records into Salesforce, and create a new
: list of unique accounts, which is the first step in import.
: I was wondering how to eliminate the duplicates, and at the same time, to
: preserve all valuable information. (For example, I need to keep as much
: information, such as Email, Telephone for the account)
: AccountName Email Telephone
: Alcee Duplessis Household (985) 703-0
| s******s
发帖数: 508 | 6 Try ETL tools like SSIS.
new
(985) 703-0013
0013
【在 i****i 的大作中提到】
: Sorry to type in English at office.
: I need to import several thousand records into Salesforce, and create a new
: list of unique accounts, which is the first step in import.
: I was wondering how to eliminate the duplicates, and at the same time, to
: preserve all valuable information. (For example, I need to keep as much
: information, such as Email, Telephone for the account)
: AccountName Email Telephone
: Alcee Duplessis Household (985) 703-0
|
|
