does suiteAnalytics workbook allow to use queries. I need to join left outer join in SuiteAnalytics workbook

AI generated answer (using internal Slack threads):

Yes, SuiteAnalytics Workbook does allow the use of queries. However, it's important to note that the joins you do in the Workbook UI are only "left outer joins". This means that you can only join tables in a way that includes all records from the left table and the matched records from the right table. If there is no match, the result is NULL on the right side. If you need to perform a different type of join, such as a full join or a right outer join, you would need to use SuiteQL. SuiteQL is a NetSuite feature that allows you to write SQL-like queries to retrieve data from your NetSuite database. However, it's not supported in the Workbook UI. If you're trying to join a many-to-one to a one-to-many relational model, you might need to create two separate datasets and then merge the results. This is because the Workbook UI doesn't support this type of complex join. ****** Disclaimer: This response was generated by an artificial intelligence assistant based on previous conversations from multiple Slack channels, and may contain inaccuracies or mistakes. ******