New Node for Reading Multiple Sheets and URI Extracting in Loop

[aldeansyahprima]

Hi. I want to perform a multiple excel sheets read including extracting URI of its specific file path, file name, etc. The solution I took was from this workflow:
Reading Multiple Excel files with different sheet names – KNIME Community Hub

However, this workflow brings me to a deprecated node of all orange and blue nodes. I have tried a few times to change all deprecated nodes to a new one, but the result seems not what I expected. Can someone please help me to re-create this workflow using latest node? My current KNIME version is 5.3.3 (5 Nov 2024).

P.S. that deprecated node (especially the Excel Reader XLS, maybe) led me to a wrong column type, e.g. column with value “2,470; - 0; (2)” should be number, but turns string since it’s failed to read a punctuation as numerical operator like “( )”, “-”, and “,”. To handle it, I used column expression to replace any punctuation with blank.
Error example attached below, that I have to remove the comma:

Thank you for your assistance.

[rfeigel]

Not sure where your problem is. I just ran the original workflow in KAP 5.4 and it worked perfectly. Just to be sure I also ran it in KAP 5.3.3 and it also ran fine. Have you tried to run the original workflow with its data before changing to your data? This might help determine whether the problem is with your data.

[aldeansyahprima]

Thanks @rfeigel, the problem maybe is in excel reader XLS (deprecated) node. I never had such an error when I used latest excel reader node. That deprecated node somehow can’t read e.g. 3,000 as a number, so the column will be string instead of number.
I tried changing to current excel reader node, but the loop seems doesn’t work at all with desired result.

[rfeigel]

If you want help, you’ve got to provide more detail. What error are you getting? Can you share a sample of your data?

[mlauber71]

@aldeansyahprima here you go:

Reading Multiple Excel files with different sheet names – mlauber71

Other than that. You might have to manipulate strange number formats. And as @rfeigel said: best to provide a sample that shows the error.

[rfeigel]

See if this helps.
Excel Number w Comma Separator.knwf (80.9 KB)
The Excel file has three types of data:

1. Number with comma separator
2. String with comma separator
3. Number with no separator.
   The Excel reader reads 1 & 3 as numbers. The String to Number node converts the string data to a number. I still don’t know how your Excel data is formatted. If as I suspect you have strings it might be easier to format them as numbers before importing to Knime.