Having Input Variables and Conditions to select a table in an aggregate

By Nuno Pereira on 21 Dec 2017

Hi all!

Introduce input values in an aggregate with a certain type, so that it is possible to introduce both variables and aggregates of different types in the sql query, in a generic way, ie, being able to put conditions in the source tab to choose which table to use, instead of having multiple flows to perform the same sql query.

imagine so, can insert a condition in "Source" such as:





(Other Table)


Instead of:

what do you think?

J.22 Dec 2017


I cannot see the advantage but only to hide the logic inside the aggregate.

I prefer the instead of, because it's more visible

Nuno Pereira22 Dec 2017

instead of its ineficient too, if you have much agreggates