Excel reader does not read URI files

Hi Knimers,

I have a workflow that works perfectly reading URI paths with the Excel Reader (deprecated) node. Now that I did the update I want to replace all the deprecated nodes with the new ones, but when I tried with the Excel Reader y lost the possibility to read the Custom/KNIME URL with the variable:

I was searching for info and I found this:

but as you can see in the following image, I use the deprecated node with Custom URL and the URI variable.

How can I do the same with the new Excel Reader node?

Thanks in advanced for all your help :smiling_face_with_three_hearts: :+1:t2: :rose:

Hello @IvaR

In the latest versions of KNIME the readers work with ‘Path’ format. You can extract the Path from URI with Extract URI Info node

I hope this helps.

BR

2 Likes

Thank you so much @gonhaddock, I put it like that:

image

2 options: but none seem to work :frowning:

and the error is the same:

what am I doing wrong? :frowning: :pensive:

@IvaR
You are missing to create the Path variable. The path Out from ‘Extract URI Info’ is a string. ‘URI to String’ would operate in a similar way…

Checking the options, this sketch would be two possible approach. Extract URI and URI to String can be interchangeable:

image

BR

3 Likes

@IvaR my recommendation would be to read the (somewhat lengthy):

https://docs.knime.com/latest/analytics_platform_file_handling_guide/index.html#introduction

yes it is long but then you will know all about paths in KNIME which will help you in the future. Also you can take a look at this workflow that has a lot of waht you can do with Paths and URIs. Rule of thumb: you can convert nearly everything ito everything else with a little effort:

Then paths are the concept with which to locate files in KNIME. Here is how you create them:

3 Likes

Hello @IvaR
Any progress with this challenge?

I’ve deployed the conceptual sketch in to an executable workflow. Besides that, here I deliver a sketch tip -not included in .knwf-, displaying how it would be connected to a file system (i.e. SharePoint, GoogleDrive…)

20230228_file_reader_from_URI_v0.knwf (34.2 KB)

BR

2 Likes

Hi @gonhaddock , that’s awesome!!! perfectly works!!! thank you so much <3
I really appreciate it :rose:

1 Like

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