[resolved] Question about tHTMLInput

[Anonymous]

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!

[Anonymous · Accepted solution]

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

[Anonymous]

Great thanks!!