topic Re: Do if-else based on row count in Talend Studio

Do if-else based on row count

Anonymous — Sat, 16 Nov 2024 09:48:06 GMT

Hi,

I'm wondering, when I do a SQL query, how can I configure an different outcome based on the resulting row count?

In other words, return different status codes (using the tRESTresponse) based on the query outcome (rows returned vs. none).

Br,

Tom

Re: Do if-else based on row count

TRF — Wed, 10 May 2017 22:24:07 GMT

Assume you are using SQL SERVER, you'll get the row count of the tMSSqlInput using the global variable tMSSqlInput_1.NB_LINE (just replace the component number according to jours). You can use this variable where you want using the following syntax: (Integer)globalVar.get("tMSSqlInput_1.NB_LINE")
Hope this helps.

Re: Do if-else based on row count

vapukov — Wed, 10 May 2017 23:50:43 GMT

NB_LINE may be not very effective if number of rows big - before return number of rows Talend will receive all data from server

I prefer use SQL construction tMSSQLRow, like

SELECT CASE WHEN EXISTS (SELECT id FROM t1) THEN 1 ELSE 0 END AS check_result

return 1/0

SELECT CASE WHEN EXISTS (SELECT id FROM t1) THEN (SELECT count(*) as cnt FROM t1) ELSE 0 END AS cnt

return number of rows