Query with count(*) for tMap

stephbzr — Fri, 15 Nov 2024 22:21:52 GMT

Hello,

Is it possible to connect a tDBInput to a tMap with a query like below? I need to get the value of count(*) from my tMap, but the query requires data from the tMap. How do I do this?

I usually do this

And I fill in the values in my tMap schema, but with count(*) I don't know how to do this.

Re: Query with count(*) for tMap

Anonymous — Tue, 15 Nov 2022 01:02:20 GMT

You can setup an alias for count(*) field in the query like :

select count(*) as num1 from repre where xxxxx

then in the schema of tDBInput, setup the 'num1' as the column name

topic Query with count(*) for tMap in Talend Studio

Query with count(*) for tMap

Re: Query with count(*) for tMap