[resolved] How to get the rows in tFileOutputDelimited?

[resolved] How to get the rows in tFileOutputDelimited?

Hi,
Im working on a job which required the output to be in a flat file in this format:
Employee_ID=101
Department= Datawarehousing
Employee_Name= Pavan

The output should be in the format specified above in a vertical way.

When im using split rows "\n" im getting output like this:
Employee_Id
Department
Employee_Name
101
Datawarehousing
Pavan

So how to concatenate column name+ "=" + row1.employee_Id..

Kindly help..
Thanks & Regards
M.pavan Kumar 
One Star

Re: [resolved] How to get the rows in tFileOutputDelimited?

Use tmap instead of split 
input-->tmap--->tfileoutputdelimited
In tmap on rightside/Out schema take only one column and write your expression like this
input.Column1 + "=" + input.column2

Re: [resolved] How to get the rows in tFileOutputDelimited?

Hi Manish,

Thank you for your prompt reply.

Actually i tried it like:
"Employee_Id" + "=' +row1.Employee_id   in the Tmap but its showing an error.

And what do you exactly mean by inputcol1+"="+inputcol2  y is that we have to concatenate col1 and col2 when we want a hard coded column name and col1 data itself??

Thanks & regards.
M.Pavan Kumar
One Star

Re: [resolved] How to get the rows in tFileOutputDelimited?

Please show your tmap screenshot will tell you exact syntax 
Seventeen Stars

Re: [resolved] How to get the rows in tFileOutputDelimited?

hi,

here you can find example about concatenation
https://help.talend.com/search/all?query=tMap+Job+example

regards
laurent
One Star

Re: [resolved] How to get the rows in tFileOutputDelimited?

I understood what exactly you want. Use tSplitrow only and just make syntax as "Employee_ID = " + row1.employee_Id

 please find attached screenshot

2019 GARNER MAGIC QUADRANT FOR DATA INTEGRATION TOOL

Talend named a Leader.

Get your copy

OPEN STUDIO FOR DATA INTEGRATION

Kickstart your first data integration and ETL projects.

Download now

What’s New for Talend Summer ’19

Watch the recorded webinar!

Watch Now

Have you checked out Talend’s 2019 Summer release yet?

Find out about Talend's 2019 Summer release

Blog

Talend Summer 2019 – What’s New?

Talend continues to revolutionize how businesses leverage speed and manage scale

Watch Now

6 Ways to Start Utilizing Machine Learning with Amazon We Services and Talend

Look at6 ways to start utilizing Machine Learning with Amazon We Services and Talend

Blog