You probably move your data from your current file sharing location to modify if, and then sometimes you replace the original file – sometime not. In Truii we try to be data centric so we have large (and growing) collection of data wrangling functionality within the truii platform. In this way you do the transformations right in the data collaboration platform so you always have the latest version of the data.
Sometime you will just have to use some other application to manipulate the data. If it is something you have to do regularly – let us know so we can add the wrangling functionality. Then, download your data, wrangle it and then upload it – not as a new file but overwrite the original. This way you have the latest data but you also have a version history so you know what is going on.
The data lineage is critical in data projects. You need to be able to answer the question “what happened to this data and who did it?” Truii includes version history. Within a session you can undo changes to a file. Major changes are stored as a separate version. For each version Truii automatically stores a summary message of what was changed, who did it and when it was done. You can download these version to compare differences or revert back to some previous version if things have gone awry.
Controlling the data version is great but the rows and columns are only part of what you need in a collaborative data project. You need context for the data – meta data. You need to be able to describe where your data comes from, any limitations or caveates for its use, any licencing restrictions on how you can use or publish it and handy search features like tags, or geo-locating it so that you can find it again. Truii has a simple but powerful meta data functionality to keep track of all this. The degree to which you use the meta fields is entirely up to your project team.