Filtering using SQL commands - is this possible

[Rodolfo Mingoti]

Hello, I would like to create a filter using SQL commands on the Tibco Spotfire Canvas.

I'm a beginnerand created the code in another tool (SAS) - Sorry :( .

I would like to know if it is possible to apply in Tibco.

If so, someone could help me, because I have no idea how to do this!

 

I share my code below:

proc sql;

create table want as

select * from work.bull_diagnosis

group by bull

having count(*)>50 ;

quit;

 

The idea is to remain in the database only bulls with more than 50 observations.

Thanks...

[Prashant Ajjannavar]

Hello,

I see it is only possible through a transformation using expressions.

Unfortunately, you cannot add SQL statements there.

However, if it is an external connection, then you can filter using custom queries(No data canvas).

Similarly, In the case of IL, you will have the option to add a filter(No data canvas).