topic Re: if/else in Talend Studio

if/else

Edi1 — Thu, 01 Apr 2021 19:16:17 GMT

Hello,

Help please!

getting an error in syntax in tMAP

"ROA&E".equals(row1.Division_1)?"00000"!=ROA&E:" "

I am trying to say in this code that the output will be "00000" if not equal to ROA&E. Otherwise, it will be the project number. (The output for the project number can be a variation of numbers)

Input data type, I am using String. Output type is a String too.

Thanks-

Re: if/else

gjeremy1617088143 — Thu, 01 Apr 2021 19:33:16 GMT

Hi edi :

!("ROA&E".equals(row1.Division_1))?"00000":row1.projectNumber

Re: if/else

Edi1 — Thu, 01 Apr 2021 20:18:03 GMT

@guenneguez jeremy

Thanks!

Errors...

The operator is undefined for the argument type String (! operator)

Also, The row1.Division will output "00000" or a variation of other Project Numbers.

Project Number is not a column row1.Division_1 is a column

Re: if/else

gjeremy1617088143 — Thu, 01 Apr 2021 20:58:29 GMT

!"ROA&E".equals(row1.Division_1)?"00000": here your value when row 1 division equals « ROA&E »

Re: if/else

Edi1 — Thu, 01 Apr 2021 23:34:33 GMT

@guenneguez jeremy

Thanks!

It looks to work up to the colon: here your value row 1....

Do you know how to allow multiple input here instead of one if it is ROA&E? It will need to output about 3 numbers that are ROA&E.

Re: if/else

Edi1 — Thu, 01 Apr 2021 23:46:52 GMT

I also tried the code below and it output all "00000" so part of the code is missing to get the other outputs that are not "00000"

!"ROA&E".equals(row1.Division_1)?"00000":""

Re: if/else

gjeremy1617088143 — Fri, 02 Apr 2021 06:53:38 GMT

I Edi , please be more precise , you want to use this for multiple columns of your input ?

the better way for that is to use routine instead of code replication.

Re: if/else

Edi1 — Fri, 02 Apr 2021 13:40:55 GMT

Hi @guenneguez jeremy

Thanks. I am trying to be precise with the info. I have.

"00000" if not ROA&E

Project Number if ROA&E

The req listed above.

The output is to generate "00000" (The code is code for that so far)

or the output will generate 04563

or the output will generate 0B332

or the output will generate 0B572

or the output will generate 0B889

or the output will generate 0B769

Project Number is not an input or output schema or value so not to be used in code.

Re: if/else

gjeremy1617088143 — Fri, 02 Apr 2021 13:44:24 GMT

How your project number is generate ?

Cause as i can understand now if row1.division = "ROA&E"

you can have différents values for project number, but what are the conditions to differentiate those values ? And where those values come from ?

Re: if/else

Edi1 — Mon, 05 Apr 2021 20:50:21 GMT

Hello @guenneguez jeremy

Here's the info...

The project number is the same as 00000...and the other numbers...

ROA&E is the variable.

If it is not !ROA&E then equal/populates to "00000"

Else if it is ROA&E equals to one of the other number...It will be/populate || or one of the numbers.

Re: if/else

Edi1 — Mon, 05 Apr 2021 22:07:09 GMT

@guenneguez jeremy

This is resolved. I was to use the values and not ROA&E... This is good to go. Thanks!