Skip to main content
Question

How to detect 'empty' keys when read parquet file using dex mapping

  • January 26, 2026
  • 2 replies
  • 12 views

Forum|alt.badge.img+4

Dear Community,

I’m using the following dex mapping :

<AimmsParquetMapping>

    <RowMapping name="xxx">
    <ColumnMapping name="A" binds-to="iA" binds-existing="1" skip-non-existing="0"/>
    <ColumnMapping name="B" binds-to="iB"/>
     <ColumnMapping name="C" maps-to="plan(iA,iB)"/>
    </RowMapping>
</AimmsParquetMapping>

Suppose now I have a row in the input file that has a NULL for the iA value. I would expect an error when reading the file, since NULL is not in the set, but the line just got skipped. Is there something wrong here or is there another way to detect empty key values?

Kind regards,

Marc

Using DEX version: 25.6.1.1

 

 

 

2 replies

Forum|alt.badge.img+3
  • Ace
  • January 26, 2026

Hi Marc, does using skip-non-existing="2" help in your case? Not sure if you have tried this already.

 

A value of 2 will skip the value, but will also issue a warning. You can use this attribute to skip objects or rows that are indexed by empty labels in the data file, but also by non-empty labels that cannot be added to e.g. a defined set in the model.


Forum|alt.badge.img+4
  • Author
  • AIMMS Partner
  • January 27, 2026

Hi Joost, yes I also tried value of ‘2’, but with same outcome


Didn't find what you were looking for? Try searching on our documentation pages:

AIMMS Developer & PRO | AIMMS How-To | AIMMS SC Navigator