topic Re: Extracting tables from web output in Talend Studio

Extracting tables from web output

Anonymous — Wed, 20 Mar 2019 05:12:12 GMT

Hi, all!

There is a website with tables (tag <table></table>. How to extract table data to rows from tHttpRequest output (string)?

Regards

Re: Extracting tables from web output

fdenis — Wed, 20 Mar 2019 10:18:45 GMT

get back html page then parse it.
but if you site is dynamic!
you have to get the request to directly get the datas.
good luck

Re: Extracting tables from web output

Anonymous — Wed, 20 Mar 2019 10:22:42 GMT

Thank for your solution, i get the data using tHTMLInput component, but it fetch all the values of particular column into row. but i need table format how to get from it.

Re: Extracting tables from web output

fdenis — Thu, 21 Mar 2019 11:16:00 GMT

did you get your html table?
what did you mean by "value of column into row"
what is this format?
can you give us samples?

Re: Extracting tables from web output

Anonymous — Thu, 21 Mar 2019 11:20:58 GMT

hi Francois Denis,
i get html table using tHTTPTableInput Component, it works perfectly, but i this component fetch only one table at a time, i need to get more than 20 tables. any other solution you have to solve this problem

Re: Extracting tables from web output

Anonymous — Thu, 21 Mar 2019 11:37:27 GMT

I've provided a complete solution for you here: https://community.talend.com/t5/Design-and-Development/Extract-Multiple-table-using-tHTTPTableInput-component/m-p/155415/highlight/true#M95040