Query with count(*) for tMap

[stephbzr]

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.

[Anonymous · Accepted solution]

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