Create file in the middle of loop

KNIME Analytics Platform
#1

Hi,

I have a folder with the following files
Payments 1
Payments 2
Payments 3
Invoices 1
Invoices 2
Invoices 3
Purchases 1
Purchases 2

I need to create a loop that goes into the folder, concatenates Payments, creates a file, then moves to Invoices, same thing, and then Purchases.

I have created a loop but it concatenates all of them in one file and I need one file per category.

Any ideas?

Thanks!

#2

Hi @andrelois

  1. Use List Files node
    https://hub.knime.com/knime/extensions/org.knime.features.base/latest/org.knime.base.node.io.listfiles2.ListFilesNodeFactory

2-3. extract file name from path and calculate your category from the file name

4-5. use the grouploop followed by a chuck loop to read in and process the files in the group


3 Likes
#3

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