DSXchange

Ray

Can i get any sample routine that sorts the values in the column?

Here are distinct values that are in the field. I dont think we have combination of letters and numbers. 0 010160 1 1 2 1 2 3 1 2 3 5 1 2 3 7 1 2 5 1 2 5 6 1 2 5 7 1 2 7 1 3 1 3 5 1 3 5 6 1 3 5 7 1 3 6 7 1 3 7 1 5 1 5 6 1 5 7 1 6 1 7 12 123 12357 125 1257 127 13 135 13567 15 157 17 2 2 3 2 3 5 2 3 5...

Update : the column also contains characters as well

yes.It contains only inter values.

its varchar(7)

Guys

I have a scenario where a column contains values like '1 5 2 6', '2 4 1 5 7', etc. The length of the column varies.
I want the output to be '1256', 12457' for the above values which means to trim the data and sort it.

Any suggestions how to implement it?

You convert using a in bulit function called StringToTimestamp() in the Transformer.

Use Execute Command Sequence afte the reading the file you can execute the command tail -1 'filename' in it.

Hi Folks,
I want to know whether we can grab the stage name???

hi,
help in the below query
How do we use surrogate keys? Is it possible to use two surrogate keys in same server job? if possible will it be correct or give errors?
thank you
jonam