A spreadsheet-based data transformation tool
Hi, All,
My team is working on a spreadsheet-based data transformation and modeling tool. It has the following features:
1, It is spreadsheet-based
2, It can process millions of rows of data interactively
3, You do not need to know complex functions, just use the menu to clean and process data.
4, All your interactive data processing work will be logged as steps automatically and can be reviewed and shared
5, It can support different data sources including csv, googlesheet, databases(MySQL, Postgresql), and data warehouses(Snowflake, databricks)
Do you think this tool is useful to you?
Tony, can you handle JSON format?
Yeah, we can handle JSON format.
Interesting. I'd be putting that front and centre with your integration formats. Regardless of database or API type, if you cater for JSON then you are gonna be able to handle the majority of datasets.
I'd be interested to see how you represent a document (as JSON format) with nested child objects as rows and columns
Hi, Thunk,
Our product is ready for your try. You can go to https://www.quicktable.io to try it.
Any suggestion is welcome!
Tony
For json format, we embedded a json parser in our product. You can extract those child objects as columns while browsing the dataset. I will let you know when the product is available for test and you can have a try.