topic Talend If Else Statement tMap tJavaRow in Talend Studio

Talend If Else Statement tMap tJavaRow

talend777 — Wed, 17 Jul 2024 23:27:44 GMT

Hi all,

I have a job in which when i query the DB i get output OF 2 columns as below:

DAY_BEGIN- 20200101

DAY_END-20200102

YEAR-2020

MONTH_BEGIN- 01

MONTH_END-02

i would like to construct this statement from this DB input

"select * from ABC where

DAY between '20200101' and '20200102'

and YEAR = '2020'

and MONTH between '01' and '02' ;

Basically when there are BEGIN and end in prefixes , i would like to use BETWEEN statement and pass values and when there is only single value e.g. YEAR i would like to pass = in statement.

Please recommend what would be better TMAP or TJAVAROW and the solution for java code.

Thank you.

Re: Talend If Else Statement tMap tJavaRow

Shicong_Hong — Thu, 18 Jul 2024 04:20:52 GMT

Sorry, I think I don't understand your question well, you want to extract the values like 20200101, 20200102 from the output of one query, and pass these value to another query? I would suggest you to use tJavaRow to hard code to parse the input rows and construct different query based on different input data, and store the query into context variable for used later on other tDBInput component.

Regards

Shicong

Re: Talend If Else Statement tMap tJavaRow

talend777 — Thu, 18 Jul 2024 12:30:55 GMT

Thank you Shicong,

Yes , i would extract the values like 20200101, 20200102 from the output of one query, and pass these value to another query.

I am trying to find sample code of tjavarow where

i can get values of 20200101, 20200102
truncate DAY_BEGIN, DAY_END to DAY,
get values of DAY_BEGIN and DAY_END
form a statement DAY BETWEEN (value of DAY_BEGIN) AND (value of DAY_end)