AnsweredAssumed Answered

Unable to Pass the file path from a field to a Text file input

Question asked by Gargi Chatterjee on Jan 11, 2019
Latest reply on Jan 14, 2019 by Roguen Keller

Hi All,

 

I am very new to Pentaho. I am having one task where I have to load the text file into table output. The CSV file path with date have to get from a log table. It might be more than one file. I am calculating the filepath in SQL query and keeping in a field but I am not able to pass the file path to load the original data from the CSV file into table. I am attaching the file what I am trying to do.

 

These are the result of the SQL

 

I am not getting any data in the table.

Outcomes