47
Views
1
Comments
Remove strucutre empty columns to export excel file
Question

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.

2020-09-15 13-07-23
Kilian Hekhuis
 
MVP

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.

Community GuidelinesBe kind and respectful, give credit to the original source of content, and search for duplicates before posting.