Hi,

I currently use Zoho creator along with Zoho Analytics to have an application that i can import sales data into. I import the data as CVS.

Before I import the CVS file I need to process the data to have all my clients information in one file.
 
To do this I download a report weekly for a 10 clients (the data is a CSV but I've been saving it to a XLSX). Then I run a macro which uses an append query to add the data to a master table.

And there it fell over.

Turns out the downloaded report is dynamic and only contains relevant data for the time frame selected, so, if something didn't happen last week then several columns might be missing from the source spreadsheet.

Therefore, the macro cannot deal with the dynamic spreadsheets (Some weeks there may not be need for certain columns and therefore they will not appear)

My question is:
Can Zoho somehow extract the data I want from each spreadsheet by 'looking' at the column headings and just populating that data?

If there are columns missing in the spreadsheet then Zoho just leaves those fields blank.


Many thanks

Usayd