Open GOESPROTOCALL opened 5 years ago
Hmm, how do you want the example to be? I can send you a 70mb json file that contains lots of records, which will resolve to about 7thousand over rows, but once you put them in google sheets and use the =unique() function, be reduced to only 5% remaining.
The unique feature that I hope you will have should actually help with the limitation of being unable to download too large output files.
Here's a part of the dataset that I've been trying to convert to table and find out and extract the unique rows. Each cell is different from the others as the data within is ordered differently, but when converted to table, they actually have mostly the same data.
How would you best tackle this dataset with the tools you have on hand?
https://docs.google.com/spreadsheets/d/1acwGXNqHbFni7SjI02ea66ZxpIEFdCJF1998Bci-h6g/edit?usp=sharing
Can you show me an example?
(The results area is only meant to be a preview to gut check that the parsing worked as expected.)