Hi, I want to use below knime flow to read 2 excels in one folder and combine them into 1 speed sheet in a new excel. the two input excel had same template and header. But when execution, there is always an error showing as below: Execute failed: Input table's structure differs from reference (first iteration) table: Column 7 [Delivery Q (Number (integer))] vs. [Delivery Q (Number (double))]Column 9 [Gross Weig (Number (double))] vs. [Gross Weig (String)] So, how can I change the table structure to ensure two tables have the same characters? thanks for your help! example.PNG

I tried this earlier also but it didn’t work, I’ll again explain my task, I’ve some files in my pc(they can be of any format excel or csv) and I need to import them into knime environment at one go instead of using Excel Reader(XLS) node again and again. I’m attaching 3 files here, please help me with the workflow that I can use. For the reference I’m taking example of 3 files but there can be hundred files since I’m very new to KNIME and wants to explore this as much I can. Data1.xlsx (15.3 KB) Data2.xlsx (16.1 KB) Data3.xlsx (15.8 KB)

You could take a look at this workflow. Not sure if there is a way to load Excel files in one step without loop. Only technique I could think of is an external Hive table referring to a folder of CSV files (have not yet tried that with KNIME) but that seems not to work with KNIME. And another note. There seem to be some customer informations and names in the sheets. Maybe you want to check if you are 100% comfortable with sharing them. [image] kn_example_multiple_excel_sheets4.knar (136.3 KB)

Hi, how can we apply fuzzy in knime as the same fuzzy that we apply in SQL, like if I want to check the similarity between name or address or telephone numbers. For eg: We have address column in two different files(one is employee_master and second is vendor_master) and I want to check the similarity % between these columns(in any)

First I think it would be best if you have a new question to open a new topic, makes it easier for people to find relevant information. Then as has been mentioned here there seems to be just the workflow you need to compare Adresses. Maybe you could adapt that: Deduplicate Address Data for Happier Customers | KNIME Deduplication is the process of identifying redundant records in a data set referring to the same real-world entity and subsequently merging these together. This article talks about how to avoid address deduplication. https://www.knime.com/knime-applications/address-deduplication Also if you just want to calculate the similarity of strings there is this thread: [image] Comparing Strings KNIME Analytics Platform Hello, I’m having problems doing something which I hope is quite simple. Ideally I would like to solve this without the need for any scripting. I’ve split a string up into a list of all the words that make that string (max 10). I then want to compare this list of words with those of another string using. I can do this in Excel easily - the first comparison yields a score of 2 and the second comparison yields a score of 3. In this instance I would choose the second comparison over the first one…

Hi, I,m trying to import multiple excel files in knime using one workflow but getting error in one of the node, ii would be great if anyone can help me about the thing that I’m missing here. I’ll attach all the files that I want to import along-with the picture of the workflow with the error. [Capture]

Hi there! What error are you getting? Do you manage te read at least one Excel file or you get error in first iteration? Br, Ivan

Hi Swatityagi, can you try uncheck the first row header option while configuring the node. Regards, Pavan.

Hi together, Thanks for the super workflows, it helped me a lot. Can you help me once more please to solve following further problem: I have one folder with 2 Excel files each Excel file has 5 Tables. Now I would like to read these 10 Tables in 10 seperate Nodes (Excel Reader). With this wf I would like to skip the manual selection of each table… Is that possible? Best wishes, Bili

Look at @mlauber71 example here [image] How to read multiple excel files in a folder and multiple sheets in an excel file? KNIME Analytics Platform Hi Iris, I am trying to read/consolidate data from multiple sheets and files in a folder. I have created the same workflow as given in the link shared by you. I was not successful in getting the desired output. I am not sure where i am missing. I have attached the workflow and the files for the reference. It would be very helpful if anyone can assist me on this. Regards, Pavan. Test.knwf (16.1 KB)

Hello izaychik, Thanks for the wf, I tried it already, my tables are all different therefore it is not working (Execute failed: Input table’s structure differs from reference (first iteration) table: different column counts…), further i would like to have the results each in a separate node for further processing. Any ideas?? Regards Bili

How to read multiple excel files in one folder?

KNIME Analytics Platform

mlauber71 September 21, 2019, 12:38pm 29

Maybe I still do not understand what you want to do. An example might help explain what your idea is. Of course, you can also save the table you ran thru in separate tables. You might use the name of the file or generate a new one from the number of the iteration.