| |||||||||||||||||||||||||||||||||||||||||||||||
Spreadsheets and databases: working with multiple data tables and arrays Description A database table (or a spreadsheet range) may contain in its different fields (columns) the data for several Mosel arrays and inversely, a Mosel array may correspond to several data tables (ranges). We have here examples of various different cases:
Source Files By clicking on a file name, a preview is opened at the bottom of this page. Data Files
multicol5.mos (!******************************************************* Mosel Example Problems ====================== file multicol5.mos `````````````````` Reading several data arrays from a single table. - Using 'initializations from' with xls IO driver - (c) 2012 Fair Isaac Corporation author: S. Heipcke, Dec. 2012 *******************************************************!) model "Multiple data columns (generic spreadsheet)" uses "mmsheet" parameters ! CSTR= 'mmsheet.xls:multicol.xls' CSTR= 'mmsheet.xlsx:multicol.xlsx' end-parameters declarations PRODUCTS: set of string MACH: range COST2: dynamic array(PRODUCTS,MACH) of real DUR2: dynamic array(PRODUCTS,MACH) of integer end-declarations ! **** Reading data from a spreadheet **** ! This assumes the spreadsheet contains a table "ProdData" in ! sparse format (i.e., with indices) with the columns "COST" and "DUR" initializations from CSTR [COST2,DUR2] as 'skiph;ProdData' end-initializations writeln("XLS:"); writeln(COST2); writeln(DUR2) end-model | |||||||||||||||||||||||||||||||||||||||||||||||
© Copyright 2023 Fair Isaac Corporation. |