How to remove null from a list returned by query entitiy

Hi I have this code written

local!productgroup: a!queryEntity(
    entity: cons!MPPCONSCDT_megaMasterFile,
    query: a!query(
      /*selection: a!querySelection(*/
      /*columns: {*/
      /*a!queryColumn(*/
      /*field: "productline",*/
      /*alias: "productline",*/
      /*             */
      /*)*/
      /*}*/
      /*),*/
      aggregation: a!queryAggregation(
        aggregationColumns: {
          a!queryAggregationColumn(
            field: "EOMYear",
            alias: "EOMYear",
            isGrouping: true()
          )
        }
      ),
      pagingInfo: a!pagingInfo(
        startIndex: 1,
        batchSize: -1
      )
    ),
    fetchTotalCount: true
  ).data,

I returns below result

Is there any way I can remove the null one?

  Discussion posts and replies are publicly visible

Parents Reply Children
No Data