Description Usage Arguments Value Examples
The DB Lytix function called is FLWideToDeep.Stored Procedure that transforms the data in a deep table format to a wide table format.
1 2 | deepToWide(object, whereconditions = "", mapTable = "", mapName = "",
outWideTableName = "", Analysisid = "")
|
object |
FLTable object to convert to wide table |
whereconditions |
character vector specifying whereconditions if any to reference the input deep table |
mapTable |
name of the in-database table containing mapping information to be used in conversion if any |
mapName |
unique identifier for the mapping information in mapping table if any |
outWideTableName |
name to give to the output wide table |
deepToWide
returns a list containing components
table
which is the FLTable referencing the wide table and AnalysisID
giving the AnalysisID of conversion
1 2 3 4 | deeptable <- FLTable(getTestTableName("tblUSArrests"), "ObsID","VarID","Num_Val")
resultList <- deepToWide(deeptable)
widetable <- resultList$table
analysisID <- resultList$AnalysisID
|
Add the following code to your website.
For more information on customizing the embed code, read Embedding Snippets.