You can use the incremental query to exclude the list of recepients who
are already targeted based on the schedule interval of time and also
purge it according to your requirements. which actually excludes the
targeted or delivered customers. Regards,Keerti J
hi, no I still haven't. I am wondering if it's the sftp file because I
have confirmed all the sftp data columns are the same as the ACS fields.
Here is the latest error code: WDB-200001 SQL statement 'INSERT INTO
wkf50169430_244_1 (iRecTrnState, iPKey1, sPKey_1, fFld1952776435,
sFld1952841972, sFld1952841973, sFld1952841974, sFld1952841975,
sFld1952841976, sFld1952841977, sFld1952841978, sFld1952841979,
sFld1952841980, sFld1952841981, sFld1952841982, sFld1952841983,
hey @SatheeskannaK, So the issue with this solution is that some of the
data is scattered among the duplicate profiles. So I want to be able to
transfer all data from all dups to just one profile & delete the others.
But will this work?
I created a workflow that consolidate all subscriptions on to 1 profile.
It doesn't move history or other profile attributes. After a period a
time the merged profile will have no history, and I will them run a
delete workflow. The workflow is pretty complicated and it use many file
up and downloads to complete the process.