Can I import date from two or more locations?

Can I import date from two or more locations?

Currently, Zoho Analytics does not support scheduling more than one import into the same table. However, you can combine the data from both tables for reporting by following the below workaround. 
Import data from each of the sources into separate tables. Then do a union to merge them into a single table using our query table features. 
If both the tables' data  are in the same format, the below query will merge the data.


Select column 1, column 2, ... column m from Table 1

UNION

Select column 1, column 2, ... column n from Table 2


You can read about the SQL UNION command here https://www.zoho.com/analytics/help/data-merging.html 
Now, over this newly created query table, you  can create the required import schedule.

    • Related Articles

    • Import Data

      Importing records into your Recruit account can help you create new candidates from data gathered through various sources, such as a purchased record database or records from different business units. You can import records using two features: Import ...

    • How can I calculate the number of hours between two date and time fields?

      To calculate the number of hours between two date and time fields, add a formula field and specify the formula expression as ((To_Date - From_Date) / (1000 * 60 * 60))   form Sample { FromDate ( type = datetime ) ToDate ( type = datetime ) Hours ( ...

    • How can I calculate the number of days between two date fields?

      To calculate the number of days between two given date fields, for instance, ServiceStartDate and ServiceEndDate, add a formula field to the form with formula expression as below. ((ServiceEndDate - ServiceStartDate) / (1000 * 60 * 60 * 24)) ,where ...

    • Viewing Import History

      Maintaining a log of the activities performed in your Zoho CRM account is always useful. You know when a record was edited, or who added a record. Similarly, a log of the import activities is also useful in knowing who imported records, when it was ...

    • Date-field Autoresponder

      Understanding date-field autoresponder Date-field based autoresponders are a series of automated messages that are sent to contacts based on the date in the date field associated with them. Wishing customers happy birthdays and anniversaries are ...