Need to separate data by column Id's (COL_ID) into two files.
File 1 should have column id's with length 10 characters
File 2 should have column id's with "everything else."
COL_ID CHAR 18
AX02L7-CAL-110
AX02D7-DOM
ZZZ2D7-DMM-285
Am able to put column id's with length 10 Char to file 1.
using COL_ID[1,10] in transformer
However, in file 2 am NOT able to keep column id's with length 10 Char "OUT" they too get included in this other column Id's file.
Tried using constraint in transformer with
COL_ID <> COL_ID[1,10] or
COL_ID > COL_ID[1,10]
what happens then is that both files output COL_ID with 10 chars.
Code: Select all
Seq File ---> Transform --->COL_ID_with_10Chars
|
|
\/
Rest_All_COL_ID
In the Where Clause used COL_ID[1,10] for Link 1 but when I execute the job get the following error:
Parse error: Expected comparison, 'between', or 'like' operator, got: "["
Parse error: Expected boolean operator (and, or) got: "1".
How do I accomplish this...?