Things learned other than Pentaho
28 Jan 2014
Sample query
select A.column1 from TABLEA A where not exists (select 1 from TABLEA, schemaX.TABLEZ Z where A.Column1=Z.Column2)
JAVA SCRIPT
Example
var str = "Hyderabad";
var result= str.substr(1,4)
So result is yder
Format
str.substr(Index Number,# of characters from Index)
--
CHECK FOR NUMERIC DATA
CREATE DATABASE LINK (Oracle)
Sample query
select A.column1 from TABLEA A where not exists (select 1 from TABLEA, schemaX.TABLEZ Z where A.Column1=Z.Column2)
JAVA SCRIPT
Example
var str = "Hyderabad";
var result= str.substr(1,4)
So result is yder
Format
str.substr(Index Number,# of characters from Index)
--
CHECK FOR NUMERIC DATA
replace( translate( rtrim(ltrim(FIELD_NAME)), '.0123456789',
'00000000000' ), '0', '' ) is null condition will identify the data (numeric
data only)
replace( translate( rtrim(ltrim(FIELD_NAME)), '.0123456789',
'00000000000' ), '0', '' ) is not null
condition will identify the data (contains non-numeric data) that
require cleansing.
Comments
Post a Comment