topic Re: [resolved] Question about tHTMLInput in Talend Studio

[resolved] Question about tHTMLInput

Anonymous — Fri, 17 Feb 2017 14:11:38 GMT

Hi,
I have a table having two columns, which are Date and Links to a webpage.
I would like to use tHTMLInput to extract the header and body from each webpage, and the extraction works well, I export the extraction results into a excel file, but how can I keep the Date column in the final excel file?
my workflow is
tFileInputExcel---> tFlowToIterate---->tHTMLInput
I tried add the Date column in the schema of tHTMLInput component, but seems it failed to give me the Date column in the final results.
Thanks!

Re: [resolved] Question about tHTMLInput

Anonymous — Mon, 20 Feb 2017 01:38:32 GMT

Hi
If I understand your quesiton well, the date column comes from the source excel file and you want to keep it in the target file.
You can add the date column on a tMap, eg:
tFileInputExcel---> tFlowToIterate---->tHTMLInput--main--tMap--tfileoutputExcel

on tMap, add a new column in the output table and set its value as:
(java.util.Date)globalMap.get("row1.dateColumnName")

Regards
Shong

Re: [resolved] Question about tHTMLInput

Anonymous — Mon, 20 Feb 2017 18:03:06 GMT

Great thanks!!