concat issue

times29 · Post by **times29** » Mon Mar 10, 2014 3:14 pm

Hi,

FISCAL_YEAR_NUMBER is decimal 4
JE_PERIOD_NUMBER is decimal 2

i want to get SORT which is decimal 8 as 20141 20142

i am doing as below its just giving me 2014 no period number
FISCAL_YEAR_NUMBER : JE_PERIOD_NUMBER

Any idea what is wrong

ray.wurlod · Post by **ray.wurlod** » Mon Mar 10, 2014 4:18 pm

JE_PERIOD_NUMBER does not actually have a value?

Show us your actual derivation.

Use the debugger to watch the values on the links.

chulett · Post by **chulett** » Mon Mar 10, 2014 5:20 pm

You can only concatenate together string fields.

ray.wurlod · Post by **ray.wurlod** » Mon Mar 10, 2014 6:06 pm

chulett wrote:You can only concatenate together string fields.

True, but the concatenation operator will automatically cause implicit conversion of its operands to string data type if necessary.

IBM Analytics Champion 2009 - 2020 · Post by **asorrell** » Tue Mar 11, 2014 2:07 pm

Will it automatically convert decimals to string? I thought only integer could have intrinsic conversion...

I would still try using DecimalToString functions to see if that resolves it...

chulett · Post by **chulett** » Tue Mar 11, 2014 2:18 pm

Me, I would never trust anything like this to an implicit conversion... explicit all the way, please. That or look to see if you can use math to effect a solution so no conversion is needed.