Forum Discussion
Solved
Improve performances for Nested.Join
Dear all, I have a two tables: Table 1, which is the main one Table 2's, i.e. a lot of subtables from where I need to recover values to make calculation in the Table 1. I am using a custom f...
Hi Mic1979
After reviewing the dataset, it was found that the file contains a large amount of data, which could impact the performance of the functions. To enhance performance, follow these steps:
- Use Direct Query or Live connection for importing data this will reduce the time and improves the query performance .
- Remove unnecessary rows or columns from tables. This will help speed up operations, especially when performing joins.
- Since you are using custom function due to this the performance will reduced. If possible, try to replace your custom function with built-in functions that are often optimized for performance.
If this post helps, then please consider Accepting as solution to help the other members find it more quickly, don't forget to give a "Kudos".
If your "Table2" all have the same columns (in as far as you are usinbg them), first do a Table.Join({Table1, Table2, Table3, etc.})
Then use the combine tbale in the merge.
If that is not suitable for your use case, give us some more details. Like the structure of the various tables, the expected number of records and some usable (NO SCREENSHOT) sample data both before and the result.
Typo! I meant a Table.Combine() ! Not a Table.Join()... 🙄