DSXchange

Data gets updated if the key matches and the value varies. And get inserted if Key get differed.
Is there a chance where both key as well as data value are same as the records present in the table.

As suggested, sort based on the both the fields. (Decending).
User RemioveDulicate stage to Retain First.

If anyone hasn't noticed, kumar_s is a prolific and skilled non-Premium Poster. Those answers are still FREE folks. Occassionally we (Premium Posters) may correct or augment existing non-Premium answers. Everyone should be extremely happy. But the fact is prolifacy and the skill was gained from the...

Another option. User transformer to Split the second column into three. In.Column[1,INDEX(In.Column,'|',1)-1] for the first link In.Column[INDEX(In.Column,'|',2),(INDEX(In.Column,'|',2)-INDEX(In.Column,'|',1)-)] for the second link In.Column[INDEX(In.Colum...

DS.REINDEX ALL has been executed while two clients for that project are connected.

This may force the index to get broken.
Building back the Index may be painfull and its not of full garuntee.
Try to restart the server. Once it worked fine for me.

Congratz Arnd!!!
4000 post @ 8.16 post per day - Almost equivelent to Ray.
High speed - Quick reply - Wide exposure - Touched almost all topics.
Keep it up and Keep going!!!

If you paid $49 for your first year, you'll have the option of renewing at that amount for your second year as well.

Oh is it.... sounds great for all 500 people:!:

If the issue is only for the subsequent run, then the rejected records can be funneled with the current data which populates the lookup fileset and can be made to populate the lookup file set in the subsequent job.

Are you sure that the same data does not exist in the table already?
Any refrential Integrity violation?

Since you have joined the site you may not have the full chance to know the value of this site. You can atleast expect/request to retain the membership fee as 50$ for 2nd year as well. But again its all depends up on the number of participants. The more the joinee, the lesseser the fee. It has alrea...

But I guess you can make use of before job subroutine. 'head -1 filenames/filepatters' > NewFileName.txt If list of files are used, head -1 filename1 filename2 .. | grep -v = > NewFileName.txt to avoid the name of the file in the content. Read the NewFileName.txt with proper metadata. Skip the inter...

Create a new dummy account and copy the contents into that path. Later on delete the dummy acount. Do not copy a live account. Yes... Buy creating a dummy project, and creating a dummy directory with the project2 name, and copying all the content of the dummy project directory to the proejct2 direc...

You can append one after other.
date /t > filename.dat
time /t >> filename.date

But it seems the value in the warning message is not for the value given initially.