merge different files in different workflows

KNIME Analytics Platform
1

hello everyone,
i am new to the platform, i would like to ask for some help. i am taking several excel files from different sites on the internet and manipulating them on KNIME, one in each workflow.
Afterwards I would like to merge them into one, can anyone suggest me the easiest way to do this?

2

Hello @BackupArian,

there are couple of possibilities:

  • write down final data from each workflow and read it all in a new one where you’ll merge it (you can use proprietary KNIME format for this - Table Writer/Reader nodes)
  • create master workflow to call all other workflows and retrieve data once finished (see example on KNIME Hub here or search forum/Hub on workflow orchestration)
  • move all data fetching and manipulating into one workflow and use Metanodes to keep it clean

Hope this helps and welcome to KNIME Community!

Br,
Ivan

3 Likes
3

I uploaded an empty excel file and used the excel writer node with it. now it created a new file in my workspace but won’t let me drag and drop into a new workspace
am i doing something wrong?

thank you

4

@BackupArian there are plenty of examples out there how you can combine Excel and KNIME operations. If you have several Excel files you can import them and concatenate the tables and then export them into one single (new) excel file.

If you want (have to) do it in different workflows you can execute them from one central workflow although in most cases it will be OK just to do the processes in a single one I think.

Maybe best to create a small example with dummy data that represents your challenge then it is easier to help. Also: more often than not the key is planning on what you actually want to do before putting together the necessary KNIME nodes. Examples from the Hub can help.

1 Like