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?

Hi. Some ideas. Look at this examples to read your excel file from sharepoint [image] Microsoft SharePoint Data Access – knime This workflow demonstrates the usage of the Microsoft Authentication and SharePoint Online Connector nodes to connect to your personal SharePoint file system. … Read all sheets [image] Knime 4.5.1 how to read all sheet in excel KNIME Analytics Platform @bruno29a ,yes, You are right, 1,data from office 365 one drive(sharepoint) file. [image] [image] 2,So I don’t know how to set excel read node. no input data. [image] And write as list [image] SharePoint Online List Writer This node writes a KNIME table to a SharePoint list. Notes: Writing tables with more than a few hundred rows can take long time. Overwriting an existing table … Br

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

KNIME Analytics Platform

hmfa February 10, 2024, 10:53pm 3

Hi.
Some ideas.

Look at this examples to read your excel file from sharepoint

Read all sheets

And write as list

2 Likes