wideToDeep: Convert Wide Table to Deep Table in database.

In Fuzzy-Logix/AdapteR: Converts R syntax to SQL to provide fast analytics using in-database C++ library DB Lytix.

Description

The DB Lytix function called is FLWideToDeep. FLWideToDeep is similar to FLRegrDataPrep , except that FLWideToDeep does not require dependent variable or intercept, thus it creates deep tables without them.

Usage

wideToDeep(object, ...)

Arguments

object	FLTable object
ExcludeCols	character vector specifying columns to be excluded from conversion
ClassSpec	list representing Class specification which identifies then value of the categorical variable to be used a reference
WhereClause	character vector giving where conditions if any to reference the wide table
OutDeepTable	name to be given to the output deep table, possibly with database
OutObsIDCol	name to give to the primary key column name of the output deep table
OutVarIDCol	name to give to the varibales name column of the output deep table
OutValueCol	name to give to the value column of the output deep table

Value

wideToDeep returns a list containing components table which is the FLTable referencing the deep table and AnalysisID giving the AnalysisID of conversion

Examples

widetable  <- FLTable(getTestTableName("tblAbaloneWide"), "ObsID")
deeptable <- wideToDeep(widetable)
analysisID <- deeptable@wideToDeepAnalysisID

## columns may be excluded from deeptable using ExcludeCols
widetable  <- FLTable(getTestTableName("tblAbaloneWide"), "ObsID", , whereconditions= "obsID< 101")
deeptable <- wideToDeep(widetable, ExcludeCols= "Sex")
analysisID <- deeptable@wideToDeepAnalysisID

Fuzzy-Logix/AdapteR documentation built on May 6, 2019, 5:07 p.m.