schema column name in front of each value.

Four Stars

schema column name in front of each value.

hi, I don't know schema column name in front of each value.

please help me

 

↓Current Data

pk | Position | Receiving |Cash| Product_num | Unit_Price | Quantity
1 warehouse1 warehouse1 Y CAP,ELECTROLYTIC, TANTALUM, 80000 20
2 warehouse2 warehouse2 N IC, AD CONVERTER 19000 15

 

 

↓ The Data I want to change

pk: 1

Position: warehouse1

Receiving : warehouse1

Cash : Y

Product_num :CAP,ELECTROLYTIC, TANTALUM

Unit_Price : 80000

Quantity : 20

pk: 2

Position: warehouse2

Receiving : warehouse2

Cash : N

Product_num :IC, AD CONVERTER

Unit_Price : 19000

Quantity : 15

 

 

P.S) I tried to use 'tLogRow'. but I don't know 'tLogRow' output to file

Nine Stars

Re: schema column name in front of each value.

Hi,

 

Are you looking for following output?

 

columnToRows.PNG

Regards,

Veeru Boppudi
Four Stars

Re: schema column name in front of each value.

yes!!

How did you set tmap?

 

p.s Sorry for the delay in getting back to you.

 

 

What’s New for Talend Spring ’19

Watch the recorded webinar!

Watch Now

Definitive Guide to Data Quality

Create systems and workflow to manage clean data ingestion and data transformation.

Download

Tutorial

Introduction to Talend Open Studio for Data Integration.

Watch

Downloads and Trials

Test drive Talend's enterprise products.

Downloads