Remove strucutre empty columns to export excel file


I have the following action flow:

with the following query:

(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?


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.