topic Talend workflow for calculated field in Talend Studio

Talend workflow for calculated field

Anonymous — Fri, 24 Mar 2017 08:34:19 GMT

I want to 1)read multiple gzip files from a path, 2)un-archive and 3)create a calculated field. So far i have been successful in doing 1 and 2. For 3, i thought that tMap will do the needful, however don't know why i am unable to connect the un-archive component with tMap.

Re: Talend workflow for calculated field

TRF — Fri, 24 Mar 2017 09:01:49 GMT

Hi,
tFileUnarchive will unarchive file(s) you have to read (for example with tFileInputDelimited) to push the data into the tMap.
If multiple files in the archive, use a tFileList to iterate over the desired extraced files.

Regards,
TRF

Re: Talend workflow for calculated field

Anonymous — Fri, 24 Mar 2017 09:54:44 GMT

from tfileUnarchieve, for connecting with tFileInputDelimited, 1) should i iterate or do OnComponentOk? 2) what should i use as 'File name/Stream'?

Re: Talend workflow for calculated field

TRF — Fri, 24 Mar 2017 10:23:18 GMT

onSubJobOK - tFileList - tFileInputDelimited((String)globalMap.get("tFileList_1_CURRENT_FILEPATH"))

Re: Talend workflow for calculated field

Anonymous — Fri, 24 Mar 2017 11:12:29 GMT

Can you elaborate entire process? I tried
tFileList ->(iterate) -> tFileUnarchive -> (onComponentOk as onSubjOk) -> tFileInputDelimited
I inserted ((String)globalMap.get("tFileList_1_CURRENT_FILEPATH")) in the file name/stream box. The problem is when i click on edit schema it does not show me anything.