Gurus, I'm new to talend, just single week old in that.Kindly help me with below scenario. I have a scenario, where i'm extracting data from Delimited file. I'm using tfilterrow to avoid NULLs. Used below expression in advanced mode link.column !=null Then manually altered the source file with empty string like below 1||3 The above expression doesn't reject that particular record.It's taking all the record to target.
If I use below either expression, it works fine. !link.column.equals("") or !link.column.isEmpty()
Here are my questions. -->Does delimited file doesn't consider null? -->Will null be treated as empty string("")? -->If so, link.column !=null will not work. right? -->Is it is necessary to include both condition, while checking NULLs or Empty string. (link.column !=null && !link.column.equals("")) Thanks
It is a fact you have to use both methods to check if there is really a value.
I usually use a routine to check this and write this check in a more efficient way.
jlolling wrote:
It is a fact you have to use both methods to check if there is really a value.
I usually use a routine to check this and write this check in a more efficient way.
