Results 1 to 6 of 6

Thread: How can I convert colums into rows

  1. #1
    Geek_Guest
    Guest

    How can I convert colums into rows

    question asked by visitor altay

    in datastage how can i convert colums into rows?

    in table i have:
    -----------------------------------------
    id name tel
    -----------------------------------------
    1 xxxx 222 22 22
    2 xxxx 333 33 33
    3 xxxx 444 44 44
    4 yyyy 555 55 55
    5 yyyy 666 66 66
    6 zzzzz 777 77 77

    in result table i want to see: -----------------------------------------------------
    name tel1 tel2 tel3
    -----------------------------------------------------
    xxxxx 222 22 22 333 33 33 444 44 44
    yyyyy 555 55 55 666 66 66
    zzzzzz 777 77 77

    Last edited by Geek_Guest; 02-27-2007 at 01:59 PM.

  2. #2
    Junior Member
    Join Date
    Jan 2007
    Answers
    7

    Re: How can I convert colums into rows

    Hi Friend. In Data Integrator ETL Tool, there is one transformation to change col to rows named as pivot. In Oracle there is one concept called Project to change columns to rows.
    In DI u will get the desired output by using this transformation


  3. #3
    Junior Member
    Join Date
    Mar 2007
    Answers
    2

    Re: How can I convert colums into rows

    you use normalizer transformation


  4. #4
    Junior Member
    Join Date
    Nov 2008
    Answers
    1

    Re: How can I convert colums into rows

    From mukul_07

    Here is my code

    ALTER PROCEDURE [dbo].[PR_RETAILER_SELECTE_W_RETAILERINVOICE]

    -- Add the parameters for the stored procedure here

    --(
    --
    -- @sRTL_ID int,
    -- @iErrorCode int OUTPUT
    --)
    --
    --AS
    --
    --declare @current varchar(250)
    --
    --set @current = ''


    --SELECT
    --@current = ltrim(rtrim(@current)) + + ltrim(rtrim(INV_ID)+',')

    --FROM
    --[dbo].[RETAILERINVOICE]

    --where

    --[RTL_ID] = @sRTL_ID

    --select @current

    --END


  5. #5
    Junior Member
    Join Date
    Dec 2008
    Answers
    3

    Wink Re: How can I convert colums into rows

    Quote Originally Posted by Geek_Guest View Post
    question asked by visitor altay

    in datastage how can i convert colums into rows?

    in table i have:
    -----------------------------------------
    id name tel
    -----------------------------------------
    1 xxxx 222 22 22
    2 xxxx 333 33 33
    3 xxxx 444 44 44
    4 yyyy 555 55 55
    5 yyyy 666 66 66
    6 zzzzz 777 77 77

    in result table i want to see: -----------------------------------------------------
    name tel1 tel2 tel3
    -----------------------------------------------------
    xxxxx 222 22 22 333 33 33 444 44 44
    yyyyy 555 55 55 666 66 66
    zzzzzz 777 77 77


    U can get this one using the Normaliser transformation In informatica


  6. #6
    Junior Member
    Join Date
    Dec 2008
    Answers
    3

    Re: How can I convert colums into rows

    u can get this one using normaliser transformation in informatica.


Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
About us
Applying for a job can be a stressful and frustrating experience, especially for someone who has never done it before. Considering that you are competing for the position with a at least a dozen other applicants, it is imperative that you thoroughly prepare for the job interview, in order to stand a good chance of getting hired. That's where GeekInterview can help.
Interact