[FONT="]Hi,[/FONT]
[FONT="]I am trying to merge 2 big queries:[/FONT]
[FONT="]1. My transaction query which contains all of my orders (some of the orders appears in more than 1 row, in case the customer ordered different products)[/FONT]
[FONT="]2. A reference I created from my transaction query which group by order number and sum some of my columns from the original query (i.e all the items discounts that, again, may appear in more than 1 row).[/FONT]
[FONT="] [/FONT]
[FONT="]The merge of the group by reference query to my transaction query is really slowing the model. Is there any solution to this issue? maybe a "set index" solution like you define to tables in SQL in order that the query won't need to run on the whole group by query every time? or a different method to create a group by based calculated column in my transaction query?[/FONT]
[FONT="] [/FONT]
[FONT="]Thank you very much.[/FONT]
[FONT="]I am trying to merge 2 big queries:[/FONT]
[FONT="]1. My transaction query which contains all of my orders (some of the orders appears in more than 1 row, in case the customer ordered different products)[/FONT]
[FONT="]2. A reference I created from my transaction query which group by order number and sum some of my columns from the original query (i.e all the items discounts that, again, may appear in more than 1 row).[/FONT]
[FONT="] [/FONT]
[FONT="]The merge of the group by reference query to my transaction query is really slowing the model. Is there any solution to this issue? maybe a "set index" solution like you define to tables in SQL in order that the query won't need to run on the whole group by query every time? or a different method to create a group by based calculated column in my transaction query?[/FONT]
[FONT="] [/FONT]
[FONT="]Thank you very much.[/FONT]