Description Usage Arguments Value Examples
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.
1 | wideToDeep(object, ...)
|
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 |
wideToDeep
returns a list containing components
table
which is the FLTable referencing the deep table and AnalysisID
giving the AnalysisID of conversion
1 2 3 4 5 6 7 8 | 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
|
Add the following code to your website.
For more information on customizing the embed code, read Embedding Snippets.