Append several XLS files into a table

KNIME Analytics Platform
1

Hi everybody, I am reading several Excel files stored into a folder and then append such files into a table, but I am having problems with the RowID columns as I cannot make it a unique value or in other words I am unable to change and identify which is the Excel RowID variable.

I am using an Knime example “Example for Reading a List of Files”, but in this case is different due to the Excel file.

File
File962×452 65.6 KB

Basically I want to change the ID to make it unique.

Rowid

I am uploading the knime workflow and the excel files.

Best Regards

Mau01 Append several XLS to a Table.knwf (16.6 KB)
Files.zip (17.8 KB)

2

Hey @mauuuuu5 ,

is it that, what you’re looking for:
image

If so, this would be the solution:

image
image1492×677 121 KB

3

Yeah, thank you that was in front of me

Best Regards

4

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