How to we implement Pivot

Anonymous — Mon, 14 Dec 2015 07:56:11 GMT

Hi team,
I have 7 columns in my input .. I need to map card ,port and rote under name
i.e as shown below tables Input 7 column output 5 column
Card ,port, rote data I need to map it under name ( I mean all the values should come under name In row format )

requirement is I nede to map 3 input column data in single column ( all the data from 3 input column reflex like 1 column data in output)
I did it in datastage using pivot enterprise but here I m not sure how do I do it . Please help me with logic

Input
=======
[table]
Service_Name

Customer_Name

Customer_Id

band

Card

Port

Rote

[tr]
3C000001

[td][font=Calibri]KS [/font][/td]

2527

20000

PBA G

Port 2/2/2

nnm
[/tr]

[tr]
3C000002

[td][font=Calibri]KS [/font][/td]

2527

20000

LX SF

Port 2/2/3

mjk
[/tr]

[tr]
3C000003

[td][font=Calibri]KS [/font][/td]

2527

3204

P OP

Port 2/2/4

unu
[/tr]

[tr]
3C000004

[td][font=Calibri]KS [/font][/td]

2527

256

BA G

Port 2/2/5

GE-L
[/tr]

[tr]
3C000005

[td][font=Calibri]KS [/font][/td]

2527

512

`

Port 2/2/6

P-GE-L
[/tr]

[tr]
3C000006

[td][font=Calibri]KS [/font][/td]

2527

3968

KIT

Port 2/2/7

C-1S
[/tr]
[/table]

Out Put
=============
[table]
Service Name

CusomerName

Customer_Id

Band

Name

[tr]
3C000001

[td][font=Calibri]KS [/font][/td]

2527

20000

PBA G
[/tr]

[tr]
3C000001

[td][font=Calibri]KS [/font][/td]

2527

20000

Port 2/2/2
[/tr]

[tr]
3C000001

[td][font=Calibri]KS [/font][/td]

2527

20000

nnm
[/tr]

[tr]
3C000002

[td][font=Calibri]KS [/font][/td]

2527

20000

LX SF
[/tr]

[tr]
3C000002

[td][font=Calibri]KS [/font][/td]

2527

20000

Port 2/2/3
[/tr]

[tr]
3C000002

[td][font=Calibri]KS [/font][/td]

2527

20000

mjk
[/tr]
[/table]

Re: How to we implement Pivot

Anonymous — Mon, 14 Dec 2015 08:01:14 GMT

My table structure is missing above so attached the screen shot .

Re: How to we implement Pivot

Anonymous — Mon, 14 Dec 2015 08:03:02 GMT

uploaded the pic

Re: How to we implement Pivot

Anonymous — Tue, 15 Dec 2015 09:44:51 GMT

Hi,

Can you upload again the screenshots you wanted to show, please? For some reason it didn't make it to your post.
Let us know if there is any issue for uploading screenshot on your end.

Best regards
Sabrina

topic How to we implement Pivot in Talend Studio

How to we implement Pivot

Re: How to we implement Pivot

Re: How to we implement Pivot

Re: How to we implement Pivot