NullColumns
Normal
0
/
WHICH_COLUMN
ADDRESSLINE2
ID_BATCH
Y
ID_BATCH
CHANNEL_ID
Y
CHANNEL_ID
TRANSNAME
Y
TRANSNAME
STATUS
Y
STATUS
LINES_READ
Y
LINES_READ
LINES_WRITTEN
Y
LINES_WRITTEN
LINES_UPDATED
Y
LINES_UPDATED
LINES_INPUT
Y
LINES_INPUT
LINES_OUTPUT
Y
LINES_OUTPUT
LINES_REJECTED
Y
LINES_REJECTED
ERRORS
Y
ERRORS
STARTDATE
Y
STARTDATE
ENDDATE
Y
ENDDATE
LOGDATE
Y
LOGDATE
DEPDATE
Y
DEPDATE
REPLAYDATE
Y
REPLAYDATE
LOG_FIELD
Y
LOG_FIELD
EXECUTING_SERVER
N
EXECUTING_SERVER
EXECUTING_USER
N
EXECUTING_USER
CLIENT
N
CLIENT
ID_BATCH
Y
ID_BATCH
SEQ_NR
Y
SEQ_NR
LOGDATE
Y
LOGDATE
TRANSNAME
Y
TRANSNAME
STEPNAME
Y
STEPNAME
STEP_COPY
Y
STEP_COPY
LINES_READ
Y
LINES_READ
LINES_WRITTEN
Y
LINES_WRITTEN
LINES_UPDATED
Y
LINES_UPDATED
LINES_INPUT
Y
LINES_INPUT
LINES_OUTPUT
Y
LINES_OUTPUT
LINES_REJECTED
Y
LINES_REJECTED
ERRORS
Y
ERRORS
INPUT_BUFFER_ROWS
Y
INPUT_BUFFER_ROWS
OUTPUT_BUFFER_ROWS
Y
OUTPUT_BUFFER_ROWS
ID_BATCH
Y
ID_BATCH
CHANNEL_ID
Y
CHANNEL_ID
LOG_DATE
Y
LOG_DATE
LOGGING_OBJECT_TYPE
Y
LOGGING_OBJECT_TYPE
OBJECT_NAME
Y
OBJECT_NAME
OBJECT_COPY
Y
OBJECT_COPY
REPOSITORY_DIRECTORY
Y
REPOSITORY_DIRECTORY
FILENAME
Y
FILENAME
OBJECT_ID
Y
OBJECT_ID
OBJECT_REVISION
Y
OBJECT_REVISION
PARENT_CHANNEL_ID
Y
PARENT_CHANNEL_ID
ROOT_CHANNEL_ID
Y
ROOT_CHANNEL_ID
ID_BATCH
Y
ID_BATCH
CHANNEL_ID
Y
CHANNEL_ID
LOG_DATE
Y
LOG_DATE
TRANSNAME
Y
TRANSNAME
STEPNAME
Y
STEPNAME
STEP_COPY
Y
STEP_COPY
LINES_READ
Y
LINES_READ
LINES_WRITTEN
Y
LINES_WRITTEN
LINES_UPDATED
Y
LINES_UPDATED
LINES_INPUT
Y
LINES_INPUT
LINES_OUTPUT
Y
LINES_OUTPUT
LINES_REJECTED
Y
LINES_REJECTED
ERRORS
Y
ERRORS
LOG_FIELD
N
LOG_FIELD
ID_BATCH
Y
ID_BATCH
CHANNEL_ID
Y
CHANNEL_ID
LOG_DATE
Y
LOG_DATE
METRICS_DATE
Y
METRICS_DATE
METRICS_CODE
Y
METRICS_CODE
METRICS_DESCRIPTION
Y
METRICS_DESCRIPTION
METRICS_SUBJECT
Y
METRICS_SUBJECT
METRICS_TYPE
Y
METRICS_TYPE
METRICS_VALUE
Y
METRICS_VALUE
0.0
0.0
10000
50
50
N
Y
50000
Y
N
1000
100
-
2023/02/03 10:38:23.037
-
2023/02/03 10:38:23.037
N
SampleDataAdmin
HYPERSONIC
JNDI
SampleDataAdmin
1521
Encrypted
FORCE_IDENTIFIERS_TO_LOWERCASE
N
FORCE_IDENTIFIERS_TO_UPPERCASE
N
IS_CLUSTERED
N
PORT_NUMBER
1521
PRESERVE_RESERVED_WORD_CASE
Y
QUOTE_ALL_FIELDS
N
SUPPORTS_BOOLEAN_DATA_TYPE
Y
SUPPORTS_TIMESTAMP_DATA_TYPE
Y
USE_POOLING
N
Filter rows
d-Nulls
Y
Filter rows
d-NotNull
Y
Table input
js-WhichColumn
Y
js-WhichColumn
Filter rows
Y
Table input
TableInput
Y
1
none
SampleDataAdmin
SELECT *
FROM "PUBLIC".CUSTOMER_W_TER
50
N
Y
N
N
Integer
normal
CUSTOMERNUMBER
9
0
Table input
CUSTOMERNUMBER
####0;-####0
.
,
none
N
Y
0
N
N
N
en_US
America/New_York
N
String
normal
CUSTOMERNAME
50
-1
Table input
CUSTOMERNAME
.
,
none
N
Y
0
N
N
N
en_US
America/New_York
N
String
normal
CONTACTLASTNAME
50
-1
Table input
CONTACTLASTNAME
.
,
none
N
Y
0
N
N
N
en_US
America/New_York
N
String
normal
CONTACTFIRSTNAME
50
-1
Table input
CONTACTFIRSTNAME
.
,
none
N
Y
0
N
N
N
en_US
America/New_York
N
String
normal
PHONE
50
-1
Table input
PHONE
.
,
none
N
Y
0
N
N
N
en_US
America/New_York
N
String
normal
ADDRESSLINE1
50
-1
Table input
ADDRESSLINE1
.
,
none
N
Y
0
N
N
N
en_US
America/New_York
N
String
normal
ADDRESSLINE2
50
-1
Table input
ADDRESSLINE2
.
,
none
N
Y
0
N
N
N
en_US
America/New_York
N
String
normal
CITY
50
-1
Table input
CITY
.
,
none
N
Y
0
N
N
N
en_US
America/New_York
N
String
normal
STATE
50
-1
Table input
STATE
.
,
none
N
Y
0
N
N
N
en_US
America/New_York
N
String
normal
POSTALCODE
15
-1
Table input
POSTALCODE
.
,
none
N
Y
0
N
N
N
en_US
America/New_York
N
String
normal
COUNTRY
50
-1
Table input
COUNTRY
.
,
none
N
Y
0
N
N
N
en_US
America/New_York
N
Integer
normal
EMPLOYEENUMBER
9
0
Table input
EMPLOYEENUMBER
####0;-####0
.
,
none
N
Y
0
N
N
N
en_US
America/New_York
N
BigNumber
normal
CREDITLIMIT
47
30
Table input
CREDITLIMIT
######0.0###################;-######0.0###################
.
none
N
Y
0
N
N
N
en_US
America/New_York
N
String
normal
TERRITORY
10
-1
Table input
TERRITORY
.
,
none
N
Y
0
N
N
N
en_US
America/New_York
N
160
208
Y
Filter rows
FilterRows
Y
1
none
d-Nulls
d-NotNull
N
lookupValue
IS NULL
496
208
Y
d-Nulls
Dummy
Y
1
none
672
144
Y
d-NotNull
Dummy
Y
1
none
672
304
Y
js-WhichColumn
ScriptValueMod
Y
1
none
N
9
0
Script 1
//Script here
var idx = getInputRowMeta().indexOfValue(getVariable("WHICH_COLUMN","N/A"));
var lookupValue = 0;
if ( idx >= 0 ) {
lookupValue = row[idx];
}
lookupValue
lookupValue
String
-1
-1
N
352
208
Y
N