rHpcc (version 1.0)

ECLDedUp-class: Class "ECLDedUp"

Description

Creates an ECL "DEDUP" definition. The DEDUP function evaluates the recordset for duplicate records, as defined by the condition parameter, and returns a unique return set. This is similar to the DISTINCT statement in SQL. The recordset should be sorted, unless ALL is specified

Fields

name:

Object of class character Class name.

inDataset:

Object of class ECLDataset Input record name.

def:

Object of class character ECl definition/code

Methods

print():

Prints the ECL code.

addField(value):

Used to add ECL definitions.

getName():

Returns class name.

Examples

  ## Not run: 
#     ecl1 <- ECL$new(hostName="127.0.0.1", port="8008")
#     recPerson <- ECLRecord$new(name="rec_person")
#     recPerson$addField("STRING", "code")
#     recPerson$addField("STRING", "firstName")
#     recPerson$addField("STRING", "lastName")
#     recPerson$addField("STRING", "address")
#     recPerson$addField("STRING", "stateCode")
#     recPerson$addField("STRING", "city")
#     recPerson$addField("STRING", "zip")
#     ecl1$add(recPerson)
#     
#     dsPerson <- ECLDataset$new(name="ds_person", datasetType = recPerson,
#     logicalFileName ="~ds::person", fileType="CSV")
#     ecl1$add(dsPerson)
#     
#     recPersonTable <- ECLRecord$new(name="personNewTableFormat")
#     recPersonTable$addField(dsPerson$getName(), "code", seperator=".")
#     recPersonTable$addField(dsPerson$getName(), "firstName", seperator=".")
#     recPersonTable$addField(dsPerson$getName(), "lastName", seperator=".")
#     
#     ecl1$add(recPersonTable)
#     
#     tblPerson <- ECLTable$new(name="PersonNewTable", inDataset = dsPerson, 
#                     format= recPersonTable)
#     ecl1$add(tblPerson)
#     
#     PersonNewTableSorted <- ECLSort$new(name="PersonNewTableSorted", 
#                               inDataset = tblPerson)
#     PersonNewTableSorted$addField("lastName")
#     ecl1$add(PersonNewTableSorted)
#     
#     mySets <- ECLDedUp$new(name="mySets", inDataset = PersonNewTableSorted)
#     mySets$addField("lastName")
#     ecl1$add(mySets)
#     ecl1$print()
#   ## End(Not run)