topic Re: How to check if a column is not empty when another is not empty in Talend Studio

How to check if a column is not empty when another is not empty

Anonymous — Tue, 24 Jul 2012 10:02:43 GMT

Hello team,
Do you have an idea to help me please:
i import a file with multiple column.
Column 1 must have a value if the Column 2 is not empty
same for the Column 3, but column 2 and 3 are optional, the file can have only 1 column with value
i tried
(!Relational.ISNULL(row3.Level_2_cd) && !row3.Level_1_cd.equals("")) ==
(!Relational.ISNULL(row3.Level_3_cd) && !row3.Level_2_cd.equals(""))
but that report me an error due to the fact the column 1 is not empty
and that in a tmap
thanks for your help

Re: How to check if a column is not empty when another is not empty

Anonymous — Tue, 24 Jul 2012 10:08:08 GMT

Hi
First, where do you want to use this condition? What's your essential requirement to do this? To filter rows?
Regards,
Pedro

Re: How to check if a column is not empty when another is not empty

Anonymous — Tue, 24 Jul 2012 10:09:45 GMT

i used this condition in a tmap

Re: How to check if a column is not empty when another is not empty

Anonymous — Tue, 24 Jul 2012 10:14:15 GMT

here is a screenshot

Re: How to check if a column is not empty when another is not empty

Anonymous — Tue, 24 Jul 2012 10:22:19 GMT

Hi
In fact, I don't understand your filtering rule.
Sorry.
Regards,
Pedro

Re: How to check if a column is not empty when another is not empty

Anonymous — Tue, 24 Jul 2012 10:47:21 GMT

it's not easy to explain.
in the screenshot, on the left my imported file
on the right mut ouput file (out1) and rejected file (reject)
i will put in reject file all rows with an level_1_cd empty while level_2_cd full

Re: How to check if a column is not empty when another is not empty

Anonymous — Tue, 24 Jul 2012 13:19:03 GMT

hello,
i found why, just an issue with my expression.
(!Relational.ISNULL(row3.Level_2_cd) && !row3.Level_1_cd.equals("")) && (!Relational.ISNULL(row3.Level_3_cd) && !row3.Level_2_cd.equals(""))
instead of
(!Relational.ISNULL(row3.Level_2_cd) && !row3.Level_1_cd.equals("")) == (!Relational.ISNULL(row3.Level_3_cd) && !row3.Level_2_cd.equals(""))
Sorry for your time

Re: How to check if a column is not empty when another is not empty

Anonymous — Wed, 25 Jul 2012 03:33:27 GMT

Hi
Great! Glad to hear you have fixed it.
Regards,
Pedro