How to pass the command line argument in the Table data input using pentaho data integration

Just use the get system input module as the system input
then set a variable as command line argumnet
then call it in Table input
and in the SQL query write like this. Select * from table where name=? //Command line argument 1

Configure the mail to send the mail with attachment in pentaho

Take the parameter in the setting file and call them in send mail. not call directly in send mail


If yo have attachment just give the path of that attachment