topic Re: if row1 is zero, then return as 1 else return row1 in Talend Studio

if row1 is zero, then return as 1 else return row1

prabuj — Fri, 15 Nov 2024 23:46:28 GMT

Hi Team,

Please help out on this logic.

For ex: I have three columns A, B, C ----- all the three columns are string data type.

If C is 0 , then I want it as 1 , else C as it is. From this output,

I want to add the C column numbers , based on the A column ID's and return a output as D column.

Thanks & Regards,

Prabuj

XJ_1630 — Sat, 04 Sep 2021 19:50:49 GMT

your question seems to be asking for a very simple Java solution.

Please confirm.

your pseudo-solution could as:

tFileInput -(row1)-> tMap -(row2)-> tFileOut

in tMap, you define your 'Column_C' as:

row1.Column_C == "0" ? "1" : row1.Column_C

i hope it helps

prabuj — Sun, 05 Sep 2021 16:03:35 GMT

@Xuan Junior error,

Please find the screenshot below

Help out to solve. thanks in advance.

XJ_1630 — Mon, 06 Sep 2021 14:37:35 GMT

@Prabhakaran Rajendran

i will teach you to fish, instead of, giving you a single fish ..

Talend is a code generator

the Graphical Job is used to create JAVA CLASSES (and other objects)

thus, your error refers to a COMPILE ERROR in the java class created by Talend based on your job.

to verify, the code created by Talend -> click on: CODE

in the lower left coner of the Job

the CODE editor will highlight errors with a RED DASH on the right of the editor:

this makes easier to find any existing problems

your error is a very basic Java error - just research a little and learn more Java

this is the best advice at this point.

Good Luck