Talend community forum / how to apply business logic for a field

s2btalend · 2012-06-25 08:22:06

Tags: [database, development, java, oracle]

hi,

i need to read a file and convert the data as schema based on position in that filed (schema) i need to apply some business logic that business logic also available from table(database)

ex:

schema:
f1,f2,f3

business;
b1=f1+f2
b2=f1 is null f2+f3 or f2 is null f1+f3 or f1+f2+f3

outfield1=b1;
outfield2=b2;

how to acheive this please help me on this.

Thanks and Regards,
G.Suresh.

pedro · 2012-06-25 08:28:27

Hi

You might do this in the component tJavaRow.

output_row.b1 = input_row.f1 + input_row.f2;
output_row.b2 = input_row.f1==null?(input_row.f2+input_row.f3):(input_row.f2==null?(input_row.f1+input_row.f3):(input_row.f1+input_row.f2+input_row.f3))

Regards,
Pedro

s2btalend · 2012-06-25 08:35:48

hi,

thanks for your reply

this is not static business logic it will get change.
business logic also need to fech from table(database).

how we can implement that.

thanks and regards,
G.Suresh.

pedro · 2012-06-25 08:43:35

Hi G.Suresh

Code:

this is not static business logic it will get change. 
business logic also need to fech from table(database).

I think it's impossible to finish this requirement... Sorry. It can't be a dynamic job with dynamic business logic.

Regards,
Pedro

Announcement

Unanswered posts

#1 2012-06-25 08:22:06

how to apply business logic for a field

#2 2012-06-25 08:28:27

Re: how to apply business logic for a field

#3 2012-06-25 08:35:48

Re: how to apply business logic for a field

#4 2012-06-25 08:43:35

Re: how to apply business logic for a field

Code:

Board footer