It seems to me that your workflow worked because you ran the tests from your “Local Space”.
The problem occurs when I try to download a file that is in a folder on the Knime Hub.
I also opened this topic on the subject, but I haven’t received a response.
In short, it seems the “File Download” node does not support paths to items on the Knime Hub.
Note that using the “List Files/Folders” node, it’s possible to connect to a file located within the Knime Hub, but not necessarily inside the “data” folder.
When I convert this to a “path” variable and try to connect it to the “File Download” node, it’s not accepted.
See the screenshots below.
As I mentioned, my goal is to create a folder within the Knime Hub for dimension tables.
This is a strategy I also use in my Local Space.
With all the dimension tables (Excel, CSV, etc.) in a fixed folder named Local Space, I build my workflows by connecting to them.
This way, when I update my dimension tables, all my workflows connected to these files are updated.
I try, as much as possible, to avoid keeping the dimension tables inside the “data” folders within the workflow, because I would have to update the files in every single workflow, which could be hundreds of them. It’s a strategy I use sometimes (I know that if I export the workflow and send it to someone, my workflow will break).
I saw that it’s also possible to do this on the Knime Hub, that is, to connect to files that are in some folder on the Hub, but downloading with the “file download node” is not possible because the “File Download” node does not support this type of path (hub data).
From my tests, if my file exists within the “data” folder, when I create my workflow through KAP (Knime Analytics Platform) and upload the workflow to the Knime Hub, I would be able to download it, but the problem is that my file is inside the “data” folder, I can no longer access that folder and file to update the file. That folder (data) no longer exists in a workflow on the Knime Hub. I can’t find it this folder(which is the doubt I raised in the topic I mentioned at the beginning of this response). If you know how can I access the folder (may be in temp folder) could you help me.
Topic UPDATED:(I founded the folder): Knime Pro: Where my "data" folder lives in a workflow from Knime Hub?
See the problem for “file download node”:
Component
List files/folder node - Connecting via Hub Space to find files
File founded
Table to row variable node - See HUB SPACE Location
*Using “path” to “file download node” - ERROR to Connection type 
using Excel Reader _ Works Fine 
