Which type or t/s is used to convert rows into column & column into rows

Categories >> Software >> Data Warehouse >> ETL
Suggest New Category

Which type or t/s is used to convert rows into column &
column into rows

Question Posted / guest

9 Answers
30022 Views
Infosys, I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

Which type or t/s is used to convert rows into column & column into rows..

Answer / prakash chandran

Row To columns
--------------

Use Normalizer Transformation

Column To Rows
--------------

SOURCE
------
ENO COL_HDR COL_VAL
------------------------
1 ENAME PRAKASH
1 ESAL 35000
2 ENAME SREE
2 ESAL 25000

OUTPUT
------
ENO ENAME ESAL
1 PRAKASH 35000
2 SREE 25000

MAPPING LOGIC
--------------

SRC -----> AGG -----> TGT

Use First Function in Aggegrator to convert the Column to
rows

In Aggegrator, Create two output columns and write the
following expression

Port Name Expression
--------- ----------
O_ENAME FIRST(COL_VAL,COL_HDR='ENAME')
O_ESAL FIRST(COL_VAL,COL_HDR='ESAL')

Please get back to me in case of queries.

Thx & Regards,
Prakash Chandran

Is This Answer Correct ?

14 Yes

2 No

Which type or t/s is used to convert rows into column & column into rows..

Answer / krishna

You can achieve through Normalizer t/f

Is This Answer Correct ?

17 Yes

12 No

Which type or t/s is used to convert rows into column & column into rows..

Answer / vijay

by using normaliser ransformation only you can convert the
rows to columns and vice versa

Is This Answer Correct ?

15 Yes

12 No

Which type or t/s is used to convert rows into column & column into rows..

Answer / ramarao

Hi Friends,

I think this possible by using source Qualifier ALSO.

The Senario is

Issue_id,Question,Answer
100,1,y
100,2,n
100,3,y
100,4,n

Target is issue_id,Answer1,Answer2,Answer3,Answer4
100, y,n,y,n

This can be Achived by using source Qualifier And joiners.
There is no need to use Normaliser.

Is This Answer Correct ?

4 Yes

3 No

Which type or t/s is used to convert rows into column & column into rows..

Answer / sowjanya

Using BODS 3.2 or higher versions

To convert columns to Rows : PIVOT transform

To convert rows to coulums : REVERSE PIVOT transform

Is This Answer Correct ?

1 Yes

0 No

Which type or t/s is used to convert rows into column & column into rows..

Answer / murugan

By using normalizer transformation we can use the conditions
only applied for row by columns..

by using the normalizer output we can use the function (first)
and then applied for conditions ..and then output will be
seen in column by rows....

Is This Answer Correct ?

1 Yes

1 No

Which type or t/s is used to convert rows into column & column into rows..

Answer / mural

hi ramarao plz explain step by step
i am gettikng confusion

Is This Answer Correct ?

0 Yes

0 No

Which type or t/s is used to convert rows into column & column into rows..

Answer / pradeep sharma

this is easily achievable in talend also using the normalize and textract delimited field

Is This Answer Correct ?

0 Yes

0 No

Which type or t/s is used to convert rows into column & column into rows..

Answer / kumar

i think we have to use macro function in build stage so we
have to write logic in macros but m not sure

Is This Answer Correct ?

1 Yes

5 No

Post New Answer