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?
Solved
Cardinality of domain
Best answer by mateusarakawa
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 originalI 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.
+2Hi @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.
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.
Sign up
Already have an account? Login
Please use your business or academic e-mail address to register
Login to the community
No account yet? Create an account
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.