FLReshape: Data Preparation

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

Description

Process deep table to have consistent obs and var ids

Usage

FLReshape(data, formula, value.var, subset = NULL,
  outTable = paste0("ARBase", data, "Reshape"), deepOutput = TRUE, ...)

Arguments

data	name of table in the database
formula	should be of form column1~column2
value.var	column containing the values
outTable	name of output table
deepOutput	TRUE if output has to be a deep table

Value

list of table FLTable object, Dimnames Mappings

Examples

resultList <- FLReshape(data="medEconomicData",
                        formula=CountryName ~ IndicatorCode,
                        value.var="TimeSeriesVal",
                        subset="IndicatorCode in ('NY.GDP.MKTP.KD.ZG','FP.CPI.TOTL.ZG') and Years=2010",
                        outTable="tbl1",
                        drop=TRUE)

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