DSXchange

This worked perfectly fine.
Thanks a million for all the help

Sai

Ray:

Below is the O/P

DR
DR DR
DR DR DR
DR DR DR DR
DR DR DR DR DR
DR DR DR DR DR DR
DR DR DR DR DR DR DR
DR DR DR DR DR DR DR DR
DR DR DR DR DR DR DR DR MH
DR DR DR DR DR DR DR DR MH MH

REQUIRED O/P
DR DR DR DR DR DR DR DR MH MH

Thanks
Sai

Chulett, This is order svCurrentValue = input.field svPreviousValue = svCurrentValue svValueHasChanged = If svCurrentValue = svPreviousValue Then 0 Else 1 If svValueHasChanged = 1 Then inlink.col2value Else If IsNull(inlink.col2value) Then svOutputRow Else If Len(svOutputRow) >= 20 Then svOutputRow ...

Chulett,

I implemented in the followin oder ,I just mistyped it
(
svCurrentValue = input.field
svPreviousValue = svCurrentValue
)

Still I am not geeting the o/p which I need.

Thanks
Sai

Ray, Thanks for your responce I implemeted the Change key using svValueHasChanged stage variable as below.Please correct me if I am wrong. svPreviousValue = svCurrentValue svCurrentValue = input.field svValueHasChanged = If svCurrentValue = svPreviousValue Then 0 Else 1 svCounter = If svValueHasChan...

Sainath, Thanks for the response Let me reiterate my qestion I have to concatinate rider types for every unique rider option. And only 10 such values have to be concatinated and if null is encountered in between it has to be droped. Like this X13 DRDRDRDRDRDRDRDRMHMH M10 VSVSVSBIBIBIBIVSVSVS Please ...

Hello there, Dataset o/p RIDER RIDER_TYPE x13 DR x13 DR x13 DR x13 NULL x13 DR x13 DR x13 DR x13 DR x13 DR x13 MH x13 MH x13 MH M10 VS M10 VS M10 VS M10 BI M10 NULL M10 BI M10 BI M10 BI M10 VS M10 VS M10 VS M10 VS M10 VS M10 VS M10 VS OUTPUT X13 DR:DR:DR:DR:DR:DR:DR:DR:MH:MH M10 VS:VS:VS:BI:BI:BI:BI...

It's not necessary to have multiple threads open for the same question. Please delete your other post. The easy choice is to add a date to the front of your time, then convert the whole to a timestamp. StringToTimestamp(DateToString(CurrentDate, "%yyyy-%mm-%dd") : " " : InLink.M...

Hello DSgurus,

I need to convert the source column which is in format hh:nn:ss to timestamp.Souce is sequential file and the target is oracle table.Can anyone crack this

Thank you

Hi there,

I need to convert a field in the following pattern

MULTIPLY BY 100 TO SHIFT DECIMAL
CONVERT THE ABOVE RESULT TO STRING THEN
PAD LEFT WITH ZEROS

Please can someone explain in detail situation.

Thank you
Sai

Hi there,
What is the concactination operator used to in transformer stage.
can any one please highligh it with an example.
Thank you

Please can any one suggest how to convert a time stamp to string with CCYYMMDD and MMDDCCYY formats.Can any one highlight with examples.

Thank you

Please can any one suggest how to convert a time stamp to CCYYMMDD and MMDDCCYY formats

Hi there, How to concatinate different columns in transformer stage. The datatypes of the columns varies from varchar ,timestamp,bigint. How to concatinate 70 odd colums which have the above mentioned datatypes. Let me know the operator for this concatination. Also please provide me with a example. ...

Hello there,

I have a sequential file with 76 coloums with the following datatypes

varchar,decimal,Integer,timestamp

How can I combine all these fields to one column and what should be the datatype of the resulting column.

Thank you
Sai