DSXchange

Thanks for your responses

The length is 250 and the max data in the column is 25 characters.

With the assistance of a colleague, I have done the triming in functions in a stage variable, then the concatenation in the column derivation and this has resolved my problem :D

Yes I only want to remove the leading characters.

I have tried putting in quotes for the 20 and it still does not help.

Your response in appreciated

Hi I'm using a triming function to trim a lot of unwanted characters in my data and after triming all these characters I also need to concatenate the column data with a number 20, but the concatenation does not happen. Is there a better way of achieving the result? Trim(Trim(Trim(Trim(Trim(Trim(Trim...

Thanks Cris Yes, we can remove duplicates using sort stage and also every output link..but make sure that your partition type is other that auto and select perform sort and unique.. that will give you unique records.. hope this makes sense.. krishna Thanks for the info , but do you trap those dupli...

CLEAR.FILE RT_LOGnnn where 'nnn' is the internal job number of the job in question. You'll then need to re-establish your auto-purge settings as they will be gone as well. ... I guess the issue at hand is how do you get internal number (nnn) for the job in administrator so you can clear the log usi...

Hi Everyone I'm rewriting a job on the Enterprise Edition which was originally written on the Standard Edition. The job uses the @OUTROWNUM function on one column to count each row and give each row a unique number which doesn't work as well on the Enterprise Edition because numbers are being repeat...