Hi all,

New in LAL 6.1.38 / LAL 6.0.38

  • The Lavastorm Get for Salesforce node
  • The HTTP node enhancement
  • The K-means Advisor node enhancement
  • The K-means Clustering node enhancement
  • The R Library Package Download node enhancement

Details of New Functionality

The Lavastorm Get for Salesforce node queries SALESFORCE.COM objects via SOQL over the SALESFORCE.COM REST API. We recommend all new graphs use the “Lavastorm Get for Salesforce” node instead of the existing “Lavastorm Query for Salesforce” node which has been deprecated. The “Lavastorm Query for Salesforce” node will continue to operate for existing graphs.

The HTTP node has been enhanced to now include two “Truststore” parameters. These parameters enable the node to utilize a user specified Java Runtime Environment (JRE) trust store. LAL-4928

The K-Means Advisor node has been enhanced with a new “TransformData” parameter which provides the option to apply z-score standardization to each field in the input data. LAL-2306

The K-Means Clustering node has been enhanced with a new “TransformData” parameter which provides the option to apply z-score standardization to each field in the input data. LAL-2217

The R Library Package Download node has been amended to use our own repository https://lavastorm.exavault.com/p/LavastormStatRepo. This is due to compatibility issues with packages distributed on the official CRAN sites. Users of the R Library Package Download node do not need to do anything different. Users of the Power R node, who do not have the R Library Package node, are expected to use the above location in line with the install.packages command and save the libraries to <LAE temp directory>/TERR/libs/. The Lavastorm repository does not currently support linux distributions. The source files can be viewed here LAL-5379

Experimental Nodes
WARNING: A range of experimental nodes have been included with the LAE product that streamline a range of common data acquisition, preparation and analysis tasks, particularly for business users. When using nodes marked as experimental some features may not work. The name of the node or parameters may change, causing any graphs that use them to require updating. The documentation may be incomplete. Use of these nodes implies a willingness to accept these limitations.

  • Change Fields - Changes the name and/or data type of selected fields in the input data. Selected fields are reordered
  • Cleanse String Fields - Removes or replaces non-alphanumeric characters and reduces consecutive whitespace to a single space
  • Compare Data Sets - Compares the values for a specified field in each of the configured (up to 3) data sources
  • Compare Multiple Data Sets - Compares the values for a specified field in each of the configured data sources
  • Complex Lookup - Provides complex lookups using logical operator-based rules
  • CSV Data - Imports data from a CSV file or comma-separated data from an input field
  • Date Range Filter - Filters data using a date range
  • Date Range Lookup - Provides date-related lookups using logical operator-based rules
  • Delimited Data - Parses delimited data from a specified file, a set of input files or from data fields in the input
  • Dynamic Split String - Splits a string type field using a specified delimiter character
  • Excel Options - Reads and converts a single-sheet Microsoft Excel (.xls, .xlsx) file for input
  • Filter By Date Range - Filters data by data range
  • Filter By Dates Within Time Period - Filters data to identify records that are within a specified time period of a reference date (or today)
  • LAE Properties - Retrieves LAE properties information
  • Load CSV File with 1 Additional Column - Reads and converts a CSV file that has an additional column
  • Make R-Safe Fieldnames - Changes field names to valid R variable names
  • More/Less/Equal Date Filter - Filters data by comparing the values in a date field agaist a specified date
  • Multi-Format Date Conversion (with 2D checks) - Analyzes and normalizes dates in a field to have a consistent date format
  • Multi-Format Date Conversion - Analyzes and normalizes dates in a field to have a consistent date format
  • Multiple Way Data Profiling - Analyses the contents of up to four input data sets (e.g. database tables) to identify fields that may possibly contain primary keys and fields that contain foreign keys
  • N Period Date Filter - Filters the data by checking the value in a date field to determine if it is within a specified 'window' time period of a specified date or today's date
  • Oracle tnsnames.ora Analyzer - Extracts information from an Oracle tnsnames.ora file
  • Power R Read Delimited File - Imports data from a delimited file
  • Power R Read SAS Data File - Reads and converts a SAS Database (.sas7bdat) file for input
  • Power R Stats Over Calendar Period - Calculates statistics for a time series over calendar periods
  • Quick Acquisition - Imports data from a CSV or Excel file
  • Rolling Statistics - Analyzes data to generate statistics for a rolling 'window' of records
  • Select Fields - Filters the fields (columns) in the input data
  • Split Field By Delimiters - Splits string data by delimiter into multiple columns
  • Split String - Splits the contents a specified field using a given delimiter string
  • String Based Lookup - Provides lookups on string variables using logical operator-based rules.
  • Three Way Data Profiling - Analyses the contents of three input data sets (e.g. database tables) to identify fields that may possibly contain primary keys and fields that contain foreign keys
  • Top/Bottom N Records - Extracts the top 'N' or bottom 'N' records from the data using the value of a specified field as the selection criterion
  • Two Way Data Profiling - Analyses the contents of two input data sets (e.g. database tables) to identify fields that may possibly contain primary keys and fields that contain foreign keys

See the release notes for more details. the Release notes and download can be found on our download page.

Regards

Simon