topic Re: [resolved] Returning Row Count and Dynamic Filename to WebService in Talend Studio

[resolved] Returning Row Count and Dynamic Filename to WebService

Anonymous — Sat, 16 Nov 2024 13:04:58 GMT

Hi,
I have all the data I needed in tFileOutputDelimited that might contains thousand of rows. The tFileOutputDelimited has a dynamic filename and the final output file will be compressed as zip file. The schema for tFileOutputDelimited has 5 columns.
My next step is to send the row count and the filename into a WebService (tBufferOutput), but I can't figure it out. For the tBufferOutput, I only need ROW_COUNT and FILENAME in the schema, and 1 row.
This is what I have now,
tFileOutputDelimited ----> tMap -----> tBufferOutput
My problems with what I have now are:
1. tBufferOutput will have multiple rows instead of a single row
2. I cannot get the final row count from tFileOutputDelimited. I am trying to use the tFileOutputDelimited.NB_LINE.
Can anybody help?
Thanks,
Donny

Re: [resolved] Returning Row Count and Dynamic Filename to WebService

_AnonymousUser — Tue, 22 Feb 2011 07:52:26 GMT

Hi Donny
Sore the row count and dynamic file name in context variable and with the help of tFixedFlowInput --> tBufferOutput with the context variable
to find & sore the row cont in context variable after each insert of row in tFileOutputDelimited increase the context variable by 1 (context variable to be integer) tFileOutputDelimited --> tJavaRow (Main row) tJavaRow should contain context.<NAME> = context.<NAME>+1;
to sore the file name in context variable. it depends how u have given the file name in tFileOutputDelimited.
please feel to ask any clarification on this

Re: [resolved] Returning Row Count and Dynamic Filename to WebService

Anonymous — Thu, 24 Feb 2011 05:03:32 GMT

Hi mailforvijaym,
Thank you for your help. Storing those parameters in context and using tFixedFlowInput works.
Regards,
Donny