Cant make the new CSV Reader to accept a file path sent by a variable

I have a folder where all the automated extractions come with a pattern like Extraction_DBXXX_YYYYMMDD.

I only want to process the last one.

With the old node I would use a list files, Sorter, Table row to variable, CSV Reader .

With the new CSV reader it refuses to accept my variable even after onverting to a “file Path” using the “URL to File Path(Variable)” node.

novonoknimeerro

What can I do apart from using deprecated nodes?

Hi @paulohap and welcome to the forum.

Any chance that the Path to String node is what you need here? See similar thread below:

1 Like

Hi!

Thanks for the quick response.

Did some testing and did not work.

This the part of the old workflow, using the deprecated nodes. It is still working.
knime_deprecated_nodes

This is the test workflow using the newer nodes with and without the “path to string” node.
Both CSV readers shows the same original error message in the initial post
knime_new_nodes

made it work.

never do knime workflows until 2:00 AM!

3 Likes

@paulohap,

Path to string variable will not work since the node requires a path variable (list files creates the corresponding cell type). I assume @ScottF thought you were using the deprecated version of the node or has mistaken it with the file reader.

I guess everything works now as I was not able to reproduce the issue?

Best
Mark

3 Likes

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