Solved

Cardinality of domain

  • 24 May 2019
  • 2 replies
  • 185 views

Hi! I encountered this problem as I try to recall my data from an excel file.

The error says: ExcelRetrieveParameter(FINAL DATA.xlsx, N(E), B16:DQ16, , 0) failed: Actual cardinality (0) of domain #1 is smaller than specified cardinality (120).

what should I do?
icon

Best answer by mateusarakawa 24 May 2019, 22:10

View original

2 replies

It worked! Thank you sooo much
Userlevel 5
Badge +2
Hi @pamjsnn.

I think your set, which has "E" as index, is empty.
Therefore, AIMMS can't link the excel table index to your set elements.

If you want to automatically populate your set, I would try Spreadsheet::RetrieveTable with argument "AutomaticallyExtendSets" : 1.

Reply


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

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