String Method syntax in tMap Expression for Two seperate columns values have to have two distinct values for a seperate column to have a True or False Value

Anonymous — Fri, 15 Feb 2019 15:38:16 GMT

I am wondering how I can nest a if then else statement based off of two seperate values in the two diffrent columns So a diffrent column would have a True or False Value.

This is a typical If then else string method in java

column1.equals("Home Phone")? "True":"False"

If I wanted to add another column with a distinct value would the syntax be

column2.equals("Fax") && column1.equals("Home Phone")? "True":"False"

I'm in early development of a job and can't run the job yet, so just making sure the syntax is right from the start.

Let me know,

Thanks,

Andrew

Re: String Method syntax in tMap Expression for Two seperate columns values have to have two distinct values for a seperate column to have a True or False Value

vapukov — Sun, 17 Feb 2019 20:41:03 GMT

the syntax looks correct, but you always could (and it very useful) make a small test for parts of a big job

it is very complicated to test not a finished job, but nothing easier than creating simple:

tFixedFlowInput
tMap
tLogRow

I have in any project folder tests where located any small tests and ideas what we want to check

topic Re: String Method syntax in tMap Expression for Two seperate columns values have to have two distinct values for a seperate column to have a True or False Value in Talend Studio

String Method syntax in tMap Expression for Two seperate columns values have to have two distinct values for a seperate column to have a True or False Value

Re: String Method syntax in tMap Expression for Two seperate columns values have to have two distinct values for a seperate column to have a True or False Value