topic Re: [resolved] row in the CSV file in Talend Studio

[resolved] row in the CSV file

Anonymous — Sat, 16 Nov 2024 13:06:46 GMT

Hi,
I would like to add to my csv file on the top some extra row to look like below, I am not sure how to do it using talend.
I have use a three different files from where I am doing mapping and look up but on the end when I insert to my csv file and just getting normal column population not sure how to make these empty rows before I get title for my second part.
Any help is welcome.
Thanks
Zeljka
colum1 colum2 column3
text,
text ,
text ,
title1 title2, title3
tesxt text, text,
text, text text
text text text

Re: [resolved] row in the CSV file

Anonymous — Wed, 02 Feb 2011 22:59:36 GMT

Hi,
I put some screenshots for a job that uses a tForeach to write out the header lines (text1, text2, and text3) and follows this up by appending a standard input/tMap/output.
http://bekwam.blogspot.com/2011/02/quick-report-with-talend-open-studio.html
You could also use a block of Java IO in the prejob routine.
-Carl

Re: [resolved] row in the CSV file

Anonymous — Fri, 04 Feb 2011 09:04:15 GMT

Hi Carl,
Thanks for your link but I still do not understand how to make my output to look as I wanted. I actually need on my existing file to add these
text,
text,
text,
text
columns and also in my case I am having 2 different files as input plus I am having lookup file and all these is mapped as one to produce one output file.
I have looked your example and had try but I am not sure when I use tForeach and link with tIterateToFlow I will need some schema but which one I will use .
I have to add I am pretty new Talend user and not really familiar with all these functionalaty.
Could you please try to give me some more explanation .
Thanks
Zeljka

Re: [resolved] row in the CSV file

Anonymous — Fri, 04 Feb 2011 11:41:37 GMT

Hi,
I updated the blog post. I added screenshots showing the two schemas. Both schemas are used to write to the same CSV file.
The first schema describes a single field of type string. This will write out the text values defined in the tForeach component.
The second schema is probably more familiar. It describes the data that will make up most of the report. It can be taken from the repository. My example is writing contact info (first name, last name, etc.) using this second schema.
http://bekwam.blogspot.com/2011/02/quick-report-with-talend-open-studio.html
-Carl

Re: [resolved] row in the CSV file

Anonymous — Fri, 04 Feb 2011 13:44:00 GMT

thanks,
I actually need to add the first 9 rows to my csv file , see my an attached file.
I hope your way is going to work..
Thanks
Z

Re: [resolved] row in the CSV file

Anonymous — Fri, 04 Feb 2011 13:45:35 GMT

An attached file this time

Re: [resolved] row in the CSV file

Anonymous — Fri, 04 Feb 2011 14:28:14 GMT

Hi Carl,
I have tried your way but still I can't make my csv file to look as I wanted.
I had try to creat two different input file one with first part of my test and second with other text below and to map but I can't get layout as I wanted.
Zeljka

Re: [resolved] row in the CSV file

Anonymous — Fri, 04 Feb 2011 14:53:45 GMT

A few things to check
1. Use two tOutputFileDelimited components with the second one set to Append
2. Make sure that the second subjob -- the one writes the data out -- is run after the first with a Subjob OK

Re: [resolved] row in the CSV file

Anonymous — Fri, 04 Feb 2011 15:10:44 GMT

I had try to have two output files as what Is show on the images, I have in my log file what I want but cant get in my csv input to be like that..
see below..

Re: [resolved] row in the CSV file

Anonymous — Fri, 04 Feb 2011 15:13:11 GMT

schema

Re: [resolved] row in the CSV file

Anonymous — Sat, 05 Feb 2011 21:18:04 GMT

I posted a video tutorial on this. See if it helps http://youtu.be/DdTBSguTjzc?a .

Re: [resolved] row in the CSV file

Anonymous — Mon, 07 Feb 2011 11:28:54 GMT

hi,
Thanks for your advice ..
I have done exactly how you did post on youtube but my second title not showing up.. can't figure out why as I am not doing anything different.
Z

Re: [resolved] row in the CSV file

Anonymous — Mon, 07 Feb 2011 14:33:48 GMT

Is it outputting "#BEGIN HEADER", "#SENDER ID", and the remaining fields but not "#CLIENT ID"?

Re: [resolved] row in the CSV file

Anonymous — Mon, 07 Feb 2011 14:42:50 GMT

hi,
I have done everything as you suggested on your video but from my images you can see that I have still not having title in second part of the text even if I folow your instruction.
any an indea what can cause that..

Thanks
Zeljka

Re: [resolved] row in the CSV file

Anonymous — Mon, 07 Feb 2011 14:57:31 GMT

Yes I can see my
#Header,
#SenderID etc
but can't see the title of the second set data

Re: [resolved] row in the CSV file

Anonymous — Mon, 07 Feb 2011 15:02:18 GMT

I am not sure if I am clear,
the first part is coming very good, I am having all my data from the tForeach part,
however my second file having title before every single column
test,
test,
test,
test
.
.
.
Title title title title
text text text text
should loook like this but I am having as I sowed on my image,
the second part is only text but not title at all
Thanks
Zeljka

Re: [resolved] row in the CSV file

Anonymous — Mon, 07 Feb 2011 16:49:20 GMT

Is Trade set to Header=0, Footer=0?

Re: [resolved] row in the CSV file

Anonymous — Mon, 07 Feb 2011 18:03:34 GMT

No ,
My Trade file header is = 1 and footer = 0
but in other file it is set it both to be = 0

Re: [resolved] row in the CSV file

Anonymous — Mon, 07 Feb 2011 18:10:05 GMT

Also is any chance that I can pass any variable ,
I wanted in the first set of the data to put some date to be change in loop like current date where is Date stated, or no of Version or no of the Row.
is this posible as all these row is under one column.
Zeljka
# BEGIN HEADER VERSION 1.1
# SENDERID:
# CLIENTID:
# DATE:
# FILETYPE:
# VERSION:
# ROWS:
# SEPARATOR:
# END HEADER

Re: [resolved] row in the CSV file

Anonymous — Mon, 07 Feb 2011 18:51:40 GMT

Use the Java concatenation operator to join a variable to the header in the tForeach values.
Some examples
"#HEADER: " + context.DATA_DIR
"#DATE: " + TalendDate.getCurrentDate()