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]

Hi Ravi,

i have many segments like in the below part of the code being repeated multiple times in my main query.

Please suggest the best approach to implement this in bods.

please note that the same table CL is called B and used again as Y.

Regards,

Swetha

[Former Member]

Hi,

If the inner query is repeated multiple times, you can use script and call sql function and store the value in variable.

Thanks

[Former Member]

Hi,

If the inner query is repeated multiple times, you can use script to call sql function and store the value in a variable. you can then use this variable.

Thanks

[former_member186160]

Hi Sweekriti,

thanks for your suggestion.

i meant same pattern is repeated but not the same text, so i cannot use the function call here.