bods: how to implement subquery

[former_member186160]

hi all,

i am having very complicated query to be implemented in bods.

usage of sql transform is strictly prohibited in teh project.

there are several subqueries and several selfjoin etc required, please suggest how to implement this in bods.

[former_member186160]

converting the sql to bods components became a huge dataflow, i am starting to test if the efforts are really worth the performance 🙂

[former_member187605]

Don't start from the SQL statement, but from the logic behind it. What are the source data? What are the desired results? Once you've understood, you can easily implement that logic in a data flow.

[former_member186160]

Hi Dirk,

thanks for the suggestion, i will check on this direction.