deepToWide: Convert Deep Table to Wide Table

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.Stored Procedure that transforms the data in a deep table format to a wide table format.

Usage

deepToWide(object, whereconditions = "", mapTable = "", mapName = "",
  outWideTableName = "", Analysisid = "")

Arguments

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

Value

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

Examples

deeptable  <- FLTable(getTestTableName("tblUSArrests"), "ObsID","VarID","Num_Val")
resultList <- deepToWide(deeptable)
widetable <- resultList$table
analysisID <- resultList$AnalysisID

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