Merging data files

[Greg Stuart]

Good Day to All,

I have a large Excel spreadsheet that has been broken into various sheets. I have loaded each sheet separately into Sofa. Is there a way to combine these separate files into one data set?

Thanks to All

[Grant Paton-Simpson]

Hi Greg,

Sort of. I can give a hint now and more details later.

SOFA stores the imported data in an SQLite database called sofa.db which you'll probably find in the C:\Users\your_name\sofastats\_internal folder.

If you can get an open-source SQLite data browser you can run a UNION query to combine all the separate tables into one.

Is this something you would consider trying?

All the best,
Grant

--

---
You received this message because you are subscribed to the Google Groups "sofastatistics" group.
To unsubscribe from this group and stop receiving emails from it, send an email to sofastatistic...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/sofastatistics/81641a84-6984-4f97-829c-e9aaf3cf1a7b%40googlegroups.com.