AnsweredAssumed Answered

Pentaho environment variable and excel export

Question asked by Alberto Sanchez on Jun 14, 2018
Latest reply on Jun 25, 2018 by Alberto Sanchez

Hi!

 

I have problem with XLS or CSV export if I use an enviroment variable as a parameter (${env::username}) in my SQL queries  to obtain data of a table. Sometimes the problem is only with numeric fields, sometimes data is completely empty after export. Curiously, export works perfectly if I use XML or JSON format. Any idea about it?

 

Many thanks in advance!

Outcomes