Hello,
I've created a process that executes a SQL query that I export
in a CSV file with a dynamic filename. "CANCEL_" + date of execution + ".csv"
That part works fine.
But I want to send the file by email with the transformer EMAILER.
I can't figure out how to manage the dynamic filename. Everything I tried fail :(
I've put the filename directly in the SQL query with the field name "fichier", that I retrieve in a variable.
Any idea?my error message
Thanks a lot !