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_member186160]

thanks Dirk and Ravi for your answers.