Hello, I am new to Knime and I ran into an issue. I try to extract a table from this website: Audi Europe Sales Figures Unfortunately the whole table is put into one single cell. I want to scrape other tables too ( number of rows can deviate). I would appreciate your ideas! Thank you in advance!

Hey Max, [image] Max98: Where can I put the loop end? If I put it directly behind the navigate node, it only lists the URLs (as it should). I want to create one excel file per loop, but the excel writer has no output for the loop end. So where do I end my loop? Then you’ll need to put it after the Excel writer. As you notice, this one doesn’t have a port, so here’s what to do: Add a Variable Loop End node to the workflow Drag a connection from the upper right corner of the Excel Writer node (there’s an invisible port at that point) to the red circle input of the loop end node. If previous step sounds like black magic, you can right click the Excel Writer and select the menu item “Show flow variable ports”. This is the same as before, but makes things more obvious: [image] Hope this helps! –Philipp

Read table from website

Community Extensions

qqilihq April 28, 2021, 8:36pm 3

Hi Max98,

I Suggest to have a look here about how to extract tables with the Selenium Nodes:

–Philipp

1 Like