Nesting IF THEN ElSE Logic with columns with same values in tMap String Method

Anonymous — Tue, 12 Feb 2019 20:42:19 GMT

If you had three columns that only have certain values but they only appear once in the three columns. Can you Nest the Three Columns into One Output Column that has True or False Logic in it in this way

Column 1 + Column 2 + Column 3.equals("Do Not Call")?"True" : "False"

or would you have to seperate each IF THEN ELSE Statement for each column with ":"

Column 1.equals("Do Not Call")?"True" : "False" : Column 2.equals("Do Not Call")?"True" : "False" : Column 3.equals("Do Not Call")?"True" : "False"

Was just curious what the proper syntax is for this specific Logic

Let me know

Thanks,

Andrew

Re: Nesting IF THEN ElSE Logic with columns with same values in tMap String Method

vapukov — Tue, 12 Feb 2019 20:49:58 GMT

Hi,

if I understand correct the logic, it is:

Column 1.equals("Do Not Call")&&Column 2.equals("Do Not Call")&&Column 3.equals("Do Not Call")?"True":"False"

topic Re: Nesting IF THEN ElSE Logic with columns with same values in tMap String Method in Talend Studio

Nesting IF THEN ElSE Logic with columns with same values in tMap String Method

Re: Nesting IF THEN ElSE Logic with columns with same values in tMap String Method