| |||||||||||||||||||||||||||||||||||||||||||||||
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
multitab.csv COLDAT1,,,,COLDAT2,,,,COLDAT3,, CUST,PERIOD,INCOME,,CUST,PERIOD,INCOME,,CUST,PERIOD,INCOME 1,1,11,,2,1,12,,3,1,13 1,2,21,,2,2,22,,3,2,23 1,3,31,,2,3,32,,3,3,33 1,4,41,,2,4,42,,3,4,43 1,5,51,,2,5,52,,3,5,53 ,,,,,,,,,, COLDAT1A,,,COLDAT2A,,,COLDAT3A,,,, PERIOD,INCOME,,PERIOD,INCOME,,PERIOD,INCOME,,, 1,11,,1,12,,1,13,,, 2,21,,2,22,,2,23,,, 3,31,,3,32,,3,33,,, 4,41,,4,42,,4,43,,, 5,51,,5,52,,5,53,,, ,,,,,,,,,, "For data in rows, note that ranges must have a title row when using ODBC, even if titles are not required in communicating program.",,,,,,,,,, ,,,,,,,,,, ROWDAT1,,,,,,,,,, DUMMY,0,0,0,0,0,,,,, PERIOD,1,2,3,4,5,,,,, INCOME,11,21,31,41,51,,,,, ,,,,,,,,,, ROWDAT2,,,,,,,,,, DUMMY,0,0,0,0,0,,,,, PERIOD,1,2,3,4,5,,,,, INCOME,12,22,32,42,52,,,,, ,,,,,,,,,, ROWDAT3,,,,,,,,,, DUMMY,0,0,0,0,0,,,,, PERIOD,1,2,3,4,5,,,,, INCOME,13,23,33,43,53,,,,, | |||||||||||||||||||||||||||||||||||||||||||||||
© Copyright 2024 Fair Isaac Corporation. |