ITableCreator.Execute

A table is created in the repository when executing the method according to the information specified in the ObjectCreateInfo property. The corresponding physical table is created in the database specified in the Database property. The table structure is determined automatically and corresponds to the structure of the data source specified in the Source property. The data from the data source is loaded to the table after the table creation.

Example

Executing the example requires that the repository contains a database with the DB identifier and a folder with the FTable identifier. The file system must contain the C:\result.txt file with data.

The example uses the Converter custom class. Class implementation is given in the example for IValueConverter.Convert.

"Indicator";"UNIT";"CITY";"Year";"Value"

"Population, mln. people";"Millions";"Chicago";"2005";17,41692859

"Population, mln. people";"Millions";"Chicago";"2006";16,776

"Population, mln. people";"Millions";"Chicago";"2007";16,776

"Population, mln. people";"Millions";"Chicago";"2008";16,776

"Population, mln. people";"Millions";"Chicago";"2009";17,314

"Population, mln. people";"Millions";"Chicago";"2010";17,314

"Population, mln. people";"Millions";"Chicago";"2011";17,93

"Population, mln. people";"Millions";"Chicago";"2012";17,603

"Population, mln. people";"Millions";"Chicago";"2013";17,603

"Population, mln. people";"Millions";"Chicago";"2014";17,566

"Population, mln. people";"Millions";"Chicago";"2015";17,975

"Unemployment rate, %";"Share";"Chicago";"2005";41,96283448

"Unemployment rate, %";"Share";"Chicago";"2006";61,98195058

"Unemployment rate, %";"Share";"Chicago";"2007";41,68466547

"Unemployment rate, %";"Share";"Chicago";"2008";12,90894701

"Unemployment rate, %";"Share";"Chicago";"2009";91,55051799

"Unemployment rate, %";"Share";"Chicago";"2010";81,2726319

"Unemployment rate, %";"Share";"Chicago";"2011";9,12417907

"Unemployment rate, %";"Share";"Chicago";"2012";36,50366842

"Unemployment rate, %";"Share";"Chicago";"2013";22,35032041

"Unemployment rate, %";"Share";"Chicago";"2014";97,99169619

"Unemployment rate, %";"Share";"Chicago";"2015";23,13102147

Fore Fore.NET

Sub UserProc; Var     MB: IMetabase;     Db: IDatabase;     CrInfo: IMetabaseObjectCreateInfo;     TextProvider: IDtTextProvider;     Fields: IDtFieldDefinitions;     TCreator: ITableCreator;     Conv: Converter;     TmpTable: ITable; Begin     // Get current repository     MB := MetabaseClass.Active;     // Create data source for table     TextProvider := New DtTextProvider.Create;     // Set file from which data will be loaded     TextProvider.File := "c:\result.txt";     // Set row with headers     TextProvider.HeaderRow := 1;     // Specify the character dividing fields     TextProvider.DelimitedColumnDelimiter := ";";     // Set date format in file     TextProvider.StringDataFormat.DateFormat := "YYYY";     // Get fields from source file     Fields := TextProvider.Fields;     // Set data type of fields     Fields.Item(0).DataType := DbDataType.String;     Fields.Item(1).DataType := DbDataType.String;     Fields.Item(2).DataType := DbDataType.String;     Fields.Item(3).DataType := DbDataType.DateTime;     Fields.Item(4).DataType := DbDataType.Float;     // Create an object that i used for field creation     TCreator := New TableCreator.Create;     // Set data source for created table     TCreator.Source := TextProvider;     // Create information about created table     CrInfo := MB.CreateCreateInfo;     // Determine folder where the table will be created     CrInfo.Parent := MB.ItemById("FTable");     // Set information about created table     TCreator.ObjectCreateInfo := CrInfo;     // Get database     Db := MB.ItemById("DB").Bind As IDatabase;     // Set database where table data will be stored     TCreator.Database := Db;     // Determine row in data source     // starting from which data will be loaded     TCreator.DataRow := 0;     // Determine number of rows to be loaded     TCreator.RowCount := 100;     // Determine that empty rows will be skipped     TCreator.SkipEmptyRows := True;     // Create a value converter     Conv := New Converter.Create;     // Determine that values of the Value filed must be converted     TCreator.AddConverter("Value", Conv);     // Create a table and load data to it     TmpTable := TCreator.Execute;     // Save created table     (TmpTable As IMetabaseObject).Save; End Sub UserProc;

Imports Prognoz.Platform.Interop.Cubes;
Imports Prognoz.Platform.Interop.Dal;
Imports Prognoz.Platform.Interop.Db;
Imports Prognoz.Platform.Interop.Dt;
Imports Prognoz.Platform.Interop.Metabase;

Public Shared Sub Main(Params: StartParams); Var     MB: IMetabase;     Db: IDatabase;     CrInfo: IMetabaseObjectCreateInfo;     TextProvider: IDtTextProvider;     Fields: IDtFieldDefinitions;     TCreator: ITableCreator;     Conv: Converter;     TmpTable: ITable; Begin     // Get current repository     MB := Params.Metabase;     // Create data source for table     TextProvider := New DtTextProvider.Create();     // Specify file from which data will be loaded     TextProvider.File := "c:\result.txt";     // Specify string with headers     TextProvider.HeaderRow := 1;     // Specify a character deviding fields     TextProvider.DelimitedColumnDelimiter := ";";     // Set date format in file     TextProvider.StringDataFormat.DateFormat := "YYYY";     // Get fields from source file     Fields := TextProvider.Fields;     // Specify data type of fields     Fields.Item[0].DataType := DbDataType.ddtString;     Fields.Item[1].DataType := DbDataType.ddtString;     Fields.Item[2].DataType := DbDataType.ddtString;     Fields.Item[3].DataType := DbDataType.ddtDateTime;     Fields.Item[4].DataType := DbDataType.ddtFloat;     // Create an object used to create fields     TCreator := New TableCreator.Create();     // Specify data source for created table     TCreator.Source := TextProvider;     // Create information about created table     CrInfo := MB.CreateCreateInfo();     // Specify folder where table will be created     CrInfo.Parent := MB.ItemById["FTable"];     // Specify information about created table     TCreator.ObjectCreateInfo := CrInfo;     // Get database     Db := MB.ItemById["DB"].Bind() As IDatabase;     // Specify database where table data will be stored     TCreator.Database := Db;     // Specify a string in data source     // starting from which data will be loaded     TCreator.DataRow := 0;     // Specify number of rows to be loaded     TCreator.RowCount := 100;     // Specify that empty rows will be skipped     TCreator.SkipEmptyRows := True;     // Create a data converter     Conv := New Converter.Create();     // Specify that the Value field values must be converted     TCreator.AddConverter("Value", Conv);     // Create a table and load data to it     TmpTable := TCreator.Execute();     // Save created table     (TmpTable As IMetabaseObject).Save(); End Sub;

After executing the example a table is created in the FTable folder. Table structure is formed automatically based on data from the C:\result.txt file. The first 100 data rows are loaded to the table, empty rows are skipped. Values loaded from the Value field are rounded.

ITableCreator.Execute

Syntax

Description

Comments

Example