Solved

Cardinality of domain


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

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.
View original

2 replies

Userlevel 5
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.
It worked! Thank you sooo much

Reply


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

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