How do I concatenate an excel file Tabs, using loop flow variable

KNIME Analytics Platform
1

Dears,
I have a file an Excel on one SharePoint contains many tabs, and each tab have the same Column.
I need to concatenate all tabs in another SharePoint List different site & it is List not excel.
How can i use Loop for this thing? would you please share screenshot about flow?

2

@RamyHussein

Here’s a quick first idea how to solve your requirement:

  1. Read in all tabs (one by one)
  2. Use the Concatenate Node Concatenate – KNIME Community Hub to bring all tables into one
3

Hi.
Some ideas.

Look at this examples to read your excel file from sharepoint

Read all sheets

And write as list

Br

2 Likes
4

Thanks, i found the solution here
https://forum.knime.com/t/knime-4-5-1-how-to-read-all-sheet-in-excel/40135?u=ramyhussein

5

Yes i did that before,
but i finally find that loop here
https://forum.knime.com/t/knime-4-5-1-how-to-read-all-sheet-in-excel/40135?u=ramyhussein

6

This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.