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.