multiple column from one thorugh drived column

Question

Hello,

I need help to convert column in to multiple column how can i use in derived column or something..
wanted to use following loging"
hightinfeet: cast(Ieft(heignt,1)*12.00) as decimal (7,3))
hightininch:
(
case isnumeric(replace(right(height, len(height)-2, ' " ', ''))
When 1 then convert (decimal(7,3),replace(right(height,len(height-2), ' " ', ' ' ))
else 0
end
)

eg: height

data
64
511
611
65
Thanks

Answer 1

Hi @pat dev ,

We can use Derived Column and Conditional Split to get the desired output in ssis package.

Please refer to the following expressions and pictures:

hightinfeet
(DT_NUMERIC,7,3)(((DT_I4)LEFT(height,1)) * 12.00)

CheckISNULL
LEN(REPLACE(RIGHT(height,LEN(height) - 2)," '' "," "))

hightininch
(DT_NUMERIC,7,3)(REPLACE(RIGHT(height,LEN(height) - 2)," '' "," "))

Best regards,
Mona

----------

If the answer is helpful, please click "Accept Answer" and upvote it.

Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.