DSXchange

Hi,
I want to concatenate '01' to a decimal value in a transformer stage. I tried it using stage variables but I didn't get exact result. Can you suggest me a way to achieve this?

Source data is like 201001, 201103, 200905 (6 digits, Integer/Decimal format)

Target should be like 20100101, 20110301, 20090501 (8 digits, Integer/Decimal format).

Thanks,

How did you try

Stage Variable:

Dslink2.key:'01'-------DATE


Output link:

DATE_OUTPUT ----DATE

I am getting output as 201105.01 and that too if and only if I declare DATE_OUTPUT as varchar. If I convert it to decimal using stringtodecimal function then I am getting result as input (6 digits)

You either need to convert to string, concat and then convert back or multiply the decimal by 100 then add 1.

Second method worked for me. I tried to convert to string and then to Decimal but didn't worked.

Thanks,

If you want to pursue the first method, show us the syntax you used and we'll go from there.

Concatenate is a string operator.

If applied to a Date data type then an implicit conversion to String is performed.

There is no implicit conversion for going the other way (string to date) so you have to specify an explicit data type conversion function such as StringToDate().

Thanks Ray,
But I am not converting it in to Date type. I just want to concatenate 01 to a column type decimal. I wasn't able to get the required output. Later I multiplied decimal type value by 100 and added +1 to that to get required output as Chulett suggested.

Thank you for your input.

chulett wrote:If you want to pursue the first method, show us the syntax you used and we'll go from there. ...

Stage:
DSLink2.KEY:'01' --- DATE (varchar)
StringToDecimal(DATE) --- Output (decimal)

Output:

Output --- Date_output (decimal)

But I am getting output same as input.

So, I modified logic like this

Stage:
DSLink2.KEY:CONC --- DATE (varchar)
StringToDecimal(DATE) --- Output (decimal)
01 ---- CONC (varchar)

Output:

Output --- Date_output (decimal)


Even I am getting output same as input I didn't understand really why it is happening like that.

As noted, you need to use DecimalToString on the incoming decimal first then concatenate and lastly use StringToDecimal to convert the end result back to a decimal.