I am working on improving our data analytics and have come across Zoho. After a month of trialing it we are going ahead and getting all our data in it.

So far I am very impressed with this.

Only issue im stuck with and with many google searches and reading I am still stuck with this.

We have 20 stores and will be importing sales data into Zoho on a weekly basis via CSV file. Each store has its own CSV file We currently have no automatic way to do this due to system limitation.

I am needing to add the store name and date into the corresponding columns so the reports can pick up the correct data.

I am successfully able to do this using Union queries from the 20 individual tables, however I am having issues adding a date field.

I am setup an additional table with the date that we want to appear in the data column that we will manually update before importing.

Attached is some screenshots.

Any help greatly appreciated

Thanks,

Paul

Yellow is what I want to insert in the Query Table