topic Re: dynamic write file name in tFileOutputDelimited in Talend Studio

dynamic write file name in tFileOutputDelimited

Anonymous — Tue, 24 Jul 2012 07:15:05 GMT

Hi,
I am working on dynamically write the file name in tFileOutputDelimited.
My design is as:
tFileInputDelimited-->tMap--row1-->tJava-->tFileOutputDelimited.
I want to write the file name in tFileOutputDelimited with:
"c:/test/test1_"+context.fileName+".csv"
In my tMap, I have the output:
row1.dateTime
row1.ID
row1.value
row1.input
row2.output
all row1.dateTime values are the same
In my tJava, I have the simple code:
context.fileName=row1.dateTime;
I want the output file of tFileOutputDelimited as:
test1_dateTime.csv with the contents of:
dateTime,ID,value,input,output
When using my design, I got the test1_null.csv. The contents of the file is correct.
I am wondering where is wrong.
Thanks,

Re: dynamic write file name in tFileOutputDelimited

Anonymous — Tue, 24 Jul 2012 07:18:42 GMT

Hi
Please use tJavaRow instead of tjava.
Regards,
Pedro

Re: dynamic write file name in tFileOutputDelimited

Anonymous — Tue, 24 Jul 2012 07:25:02 GMT

I tried to use jJavaRow. I still got the test1_null.csv file.

Re: dynamic write file name in tFileOutputDelimited

Anonymous — Tue, 24 Jul 2012 07:26:45 GMT

Hi
The expression should be like this.
context.fileName=input_row.dateTime;
Regards,
Pedro

Re: dynamic write file name in tFileOutputDelimited

Anonymous — Tue, 24 Jul 2012 07:29:23 GMT

I did have the same code. but the file name is still test1_null.csv.

Re: dynamic write file name in tFileOutputDelimited

Anonymous — Tue, 24 Jul 2012 07:33:21 GMT

Hi
Are you sure?
It's not row1. It's input_row.
If it still doesn't work, please send me an email and attach this job.
Regards,
Pedro

Re: dynamic write file name in tFileOutputDelimited

alevy — Wed, 25 Jul 2012 00:46:05 GMT

You cannot use flow values in the file name as the output file is created before the input file starts reading. You need a tFlowToIterate and tFixedFlowInput instead of tJavaRow to achieve this. Search the forum for many many posts on doing this.

Re: dynamic write file name in tFileOutputDelimited

Anonymous — Wed, 25 Jul 2012 00:47:38 GMT

It is still not working. I can get the print out context.fileName in the tJavaRow.
The print out in tJavaRow is looked like:
context.fileName2012-07-16 23:00
context.fileName2012-07-16 23:00
context.fileName2012-07-16 23:00
context.fileName2012-07-16 23:00
context.fileName2012-07-16 23:00
context.fileName2012-07-16 23:00
context.fileName2012-07-16 23:00
context.fileName2012-07-16 23:00
In my tJavaRow, the codes are:
output_row.PSI = input_row.PSI;
output_row.Type = input_row.Type;
output_row.DateTime = input_row.DateTime;
output_row.Value = input_row.Value;
context.fileName=input_row.DateTime;
System.out.println("context.fileName"+context.fileName);
In my tFileOutputDelimited, I have the file name: "d:/test/test1_"+context.fileName+".csv"
From the print out, I can see the contextfileName is assigned in every row, which having 8 rows in this case. Is the contextfileName in the file name will be written 8 times?

Re: dynamic write file name in tFileOutputDelimited

Anonymous — Wed, 25 Jul 2012 00:52:20 GMT

my context.fileName intial value is null. I changed the intial value to be "abc", I then get the test1_abc.csv file. It's looked like the context.fileName that is defined my Context hasn't been over-written my the tJavaRow. I am wondering if I have done something is not correct in the Context definition, or I need to do something else.

Re: dynamic write file name in tFileOutputDelimited

djugal — Wed, 25 Jul 2012 06:58:50 GMT

use a flow to iterate & tfixed flow as shown in the pic, your prob with null is solved

Re: dynamic write file name in tFileOutputDelimited

_AnonymousUser — Tue, 14 Apr 2015 08:46:06 GMT

The same problem is coming for me too. Not able to include a dynamic name for tFileOutputRaw.