| Product(s): | Cube |
| Version(s): | 6.1 to 6.5 |
| Area: | Matrix |
DBF files are commonly used in modeling transportation projects. Cube provides many useful functions to manipulate DBF files. In the following example, we will first demonstrate how to create a DBF file from a CSV file and vice versa using some of the DBI sub keywords.
Solution
After one is familiar with those, we will show how to use DBISeek function to extract some of the records from one DBF file. DBISeek is another useful function Cube provides. It can search for a record based on multiple criteria. In this specific example, we have a DBF file containing all the link information as shown below:
Now we want to know the capacity of two specific links only according to the CSV file we have:
The selection criteria for those link will be based on A node and B node. We can achieve this by the following script:
myLink = DBISEEK(#, myA, myB)
The output of Matrix 3 in the sample catalog is the following:
Please refer to the attached sample catalog for detailed information regarding DBI functions in Cube. Feel free to twist any input files/scripts to practice those sub keywords.