How do I convert Excel add-in V1 (legacy) formulas to V2?
Here are the steps to do so.
1. Hover over the cell with the V1 formula.
2. Open the relevant Kpler add-in V1 box/endpoint.
3. Review parameters used in filters/columns.
4. Close Kpler add-in V1 box.
5. Replicate the parameters from V1 into the Kpler add-in V2 including all filters and columns.
6. Click on RUN to replace the V1 formula in the cell.
How do I use the hash formula to maintain the columns from V1 to V2?
The hash is a string of alphanumeric characters that users can find in the query, just replace the existing hash in V2 with the old hash from V1.
This will ensure that the columns users see in V2 are the same as the ones they had in V1.
How do users avoid formulas from disappearing?
Users must ensure that there is an empty column between data sets so the extracted data does not overlap with the next formula.