What library is currently (and will be) supported for reading tabular data files that are delimited by specific characters - for e.g., tabs? Is there an option to specify delimiter in the DEX library for mapping these data files? Or, is the best course to use the CSVProvider (depedent on DataLink) and use ReadWriteAttribute?
Page 1 / 1
Hi
The DEX library will guess the delimiter based on the first line, and is tested to work with comma, semi-colon and tab separators. When writing, it will always generate comma-separated files.
The DEX library is currently under full development to become a kind of Swiss army knife for data exchange in AIMMS, supporting reading and writing multiple data formats (JSON, XML, CSV, Excel, Parquet, DB), auto-generated mappings from annotated identifiers, auto-generating application databases capable of storing datasets for multiple scenarios from annotated identifiers (currently under development), generating REST API clients from OpenAPI specifications, exposing model procedures as REST services on our cloud platform, exposing generated application databases through a REST service in our cloud platform (next on roadmap), …
So, if anything, my bet would be for DEX as the future proof library for data exchange.
The DEX library is currently under full development to become a kind of Swiss army knife for data exchange in AIMMS, ...
This is great to see as we look to expanding how we develop and deploy models.
Reply
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.