How can I convert colums into rows
[b]question asked by visitor altay[/b]
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
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
Re: How can I convert colums into rows
you use normalizer transformation
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
Re: How can I convert colums into rows
[QUOTE=Geek_Guest;8359][b]question asked by visitor altay[/b]
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[/QUOTE]
U can get this one using the Normaliser transformation In informatica
Re: How can I convert colums into rows
u can get this one using normaliser transformation in informatica.