How to optimize Workspace for better performance.
The following are few methods to Optimize the Workspace.
- When adding lookup column, ensure that the reference column in the parent table contains unique data.
- When you set Import Type to UPDATE ADD for uploading data into an existing table, you need to specify one or more matching columns based on which the existing records in the table will be matched. Specify column which contains unique data as matching columns.
- When you use Join clause in Query table, then the where clause should satisfy the following criteria.
- One of the column in the Join clause should contain unique data.
- Date column should not be used directly in the Join clause. Convert the date data into string using the Concatenation {concat(Column_Name)} formula.
- Do not use any function over the column in join clause. Create a formula column with the required function and then use this new column in the Join clause.
Access your files securely from anywhere
Zoho CRM Training Programs
Learn how to use the best tools for sales force automation and better customer engagement from Zoho's implementation specialists.
Zoho DataPrep Personalized Demo
If you'd like a personalized walk-through of our data preparation tool, please request a demo and we'll be happy to show you how to get the best out of Zoho DataPrep.
- Zoho Workerly Home
- Forums
- Connect With Us:
- Zoho Recruit Home
- Forums
- Connect With Us:
New to Zoho Writer?
Create. Review. Publish.
New to Zoho CRM Plus?
Deliver unforgettable customer experiences
New to Zoho CRM Plus?
Deliver unforgettable customer experiences
New to Zoho Marketing Plus?
Everything you need to run your marketing
New to Zoho Marketing Plus?
Everything you need to run your marketing
You are currently viewing the help pages of Qntrl’s earlier version. Click here to view our latest version—Qntrl 3.0's help articles.
New to Zoho Survey?
Zoho Sheet Resources
Zoho Forms Resources
New to Zoho Sign?
Zoho Sign Resources
Sign, Paperless!
New to Zoho TeamInbox?
Zoho TeamInbox Resources
New to Zoho ZeptoMail?
Design. Discuss. Deliver.
New to Zoho Workerly?
New to Zoho Recruit?
New to Zoho CRM?
New to Zoho Projects?
New to Zoho Sprints?
New to Zoho Assist?
New to Bigin?
Related Articles
Linked Workspace
Linked Workspace in Zoho Analytics allows you to create a connection between two distinct workspaces, allowing them to push views from one workspace to another. In this relationship, one workspace acts as a primary workspace, so that changes in that ...Managing users in Workspace
1. Who is a Workspace User? Users who can access the view in your workspace are your users. Click here to know more on the users in Zoho Analytics. 2. What are the user roles available in Zoho Analytics? Zoho Analytics supports the following user ...Importing Data from Zoho Analytics Workspace
Creating reports from tables/data spread across multiple workspaces is now made easy with the Zoho Analytics Workspace import option. You might sometimes have relevant data spread across separate workspaces. However, you cannot create reports from ...Can I change the cloud data source of my Workspace?
Yes, you can change the cloud database from which you are importing data into your workspace. Follow the steps below to change the data source of your reporting database. From Workspace Explorer, click Data Sources. In the Data Sources section, ...Workspace Administrators
Zoho Analytics supports adding multiple Workspace Administrators in your Workspace. With this, you can entitle your user to perform all operations on the Workspace without individually setting them. Permission Required Account Administrator and ...
New to Zoho LandingPage?
Zoho LandingPage Resources