topic Re: How to check if a source value is > something? in Talend Studio

How to check if a source value is > something?

rp2018 — Sat, 16 Nov 2024 07:23:13 GMT

Have a sql server as a source database and a source field is called amt which is a Boolean field.

What tool to use to check if a value for amt > 300000.00 then insert the entire row into another table and add comment to a field called Reason = 'Amount exceeded 300000.00' .

NOTE: Reason field is not coming from source, but it is in the target table.

Re: How to check if a source value is > something?

Anonymous — Mon, 29 Oct 2018 19:55:36 GMT

Your question is a little confusing as you mention your column "amt" is defined as boolean (which should only allow true or false as values) If this is a simple mistake in the post, give the following a try:

you should be able to design a job that would look like this:
tDBInput ---row---> tDBOutput

in the DB input query, write something like the following:

"SELECT *, 'Amount Exceeded "+context.THRESHOLD_VALUE+"' as Reason FROM source_table WHERE amt 
> "+context.THRESHOLD_VALUE+""

This would retrieve only the rows in the source table that have amt greater than your expected value stored in the context variable THRESHOLD_VALUE, and copy them to the target table configured in your db output component.

Re: How to check if a source value is > something?

Anonymous — Tue, 30 Oct 2018 08:13:04 GMT

Firstly, How could a boolean field contain Integer ?

If thats by mistake then you can simply create a Select query with where clause on the amount field checking if its greater than 300000.00 and populate the Reason field of target with " Amount exceeded 300000.00 ".

Additional : If your Source and Target tables are in the same instance of MsSQL then you should go for ELT components ,

you will surely get the performance boost in terms of time taken .

Re: How to check if a source value is > something?

rp2018 — Tue, 30 Oct 2018 14:19:42 GMT

Sorry I meant to say the datatype is double.

Is there a component in Talend to do this instead of writing the sql query?

Re: How to check if a source value is > something?

manodwhb — Fri, 02 Nov 2018 07:39:16 GMT

@rp2018,you can use tFilterRows to filter the data.

Re: How to check if a source value is > something?

Anonymous — Mon, 05 Nov 2018 06:34:23 GMT

yes you can choose tmap or tfilter to filter out the rows required

but if you are fetching data from Database the query will anyways be generated.

Re: How to check if a source value is > something?

manodwhb — Thu, 29 Nov 2018 13:02:27 GMT

@rp2018,still do you have this issue?

Re: How to check if a source value is > something?

rp2018 — Fri, 30 Nov 2018 17:25:32 GMT

How can you achieve this in tmap?

Re: How to check if a source value is > something?

Anonymous — Mon, 03 Dec 2018 07:23:14 GMT

hi,

you can either use the filter available in map to filter out the rows or you can process at the column level to pass the value only if it is greater than some specific value.

Regards

Chandra Kant