Empty line as constraint in transformer

chetan.c · Post by **chetan.c** » Tue Feb 14, 2012 4:37 am

Hi,

I have data like this.
Col1
a
b
c
"Empty line"
d
e
f

My output should be
abc
def

I'm using stage variables to concatenate the rows.
But how to mention the constraint in Transformer as blank line?

I tried trim(col1)='' but it is not working.

Thanks
Chetan

HendrikB · Post by **HendrikB** » Tue Feb 14, 2012 4:45 am

Hi,

just an idea: maybe could you identify an empty line by its length using length function len().

And what does empty line mean?
Number of Blanks? NULL?

chetan.c · Post by **chetan.c** » Tue Feb 14, 2012 4:59 am

Hi,

I tried len() but its not working either.
Empty line is just a blank line not any number of spaces or blanks.
Like
a

b

Thanks.

HendrikB · Post by **HendrikB** » Tue Feb 14, 2012 5:05 am

Ok,
what source are you talking about? DB, Flat file?
What is the datatype of your input column? CHAR, VARCHAR?

chetan.c · Post by **chetan.c** » Tue Feb 14, 2012 5:53 am

Sorry actually len() works but my logic in stage variables was wrong, fixed it thanks.

pandeesh · Post by **pandeesh** » Tue Feb 14, 2012 6:03 am

But, i prefer these things in doing filter option of sequential stage..