Remove strucutre empty columns to export excel file

Remove strucutre empty columns to export excel file

  

Hi,

I have the following action flow:

with the following query:

SELECT Id,
(case when @Nome = 0 then Nome end),
(case when @Apelido = 1 then Apelido end),
(case when @Idade = 0 then Idade end)
FROM {Aluno};


with the following structure:

In the  SQL1 query, I have some empty columns and when I export to Excel file, all columns are exported. How I can export only the filled columns?


Thanks.

Hi Catarina,

Unfortunately, it is not possible to dynamically decide which columns to include in an Excel export. You either need a RecordListToExcel for each possible combination, or you must resort to one of the Forge components that can output an Excel.