Exclude empty columns from a table

ValentinDes — Tue, 11 Mar 2025 10:08:47 GMT

Hi guys,

I have a table with a lot of columns that are completely empty, i'd like to exclude them, it's pretty easy when we talk about rows but here i really don't know, do you have an idea ?

Re: Exclude empty columns from a table

marcus_sommer — Tue, 11 Mar 2025 12:21:48 GMT

You may create a for-loop over all fields of a table per nooffields() to get the fieldname() and within it an if-loop check per fieldvaluecount() if there is any content and if not to drop the field.

A better approach as the above may be not load the tables with a field-wildcard else to define the wanted ones explicitly.

topic Exclude empty columns from a table in Integration, Extension & APIs

Exclude empty columns from a table

Re: Exclude empty columns from a table