This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
I have a dataset with lat/lon information. My problem is that I have multiple duplicate entries and would like to interpolate between them.
For instance say I have 1000 unique GPS points, but 10,000 recorded data points (associated with other unique information that updated faster than GPS when collecting).
It's not always a fixed amount of points between unique GPS points so it has to be somewhat of a dynamic solution. I can probably write a C# or python script to handle it and run it externally from the run command, but that's a pretty ugly solution, is there a way to handle it within alteryx?
I was thinking multi-line formula, but the fact that there are different numbers of duplicates in a row is throwing me off.
Thank you @NicoleJohnson for your valuable post, now if we have the opposite case, let's say there is (GPS OFF) and back again on, how can we find the missing coordinates e.g.: (missing n points) and display it again on the map from the data when the GPS off? I don't have data but if possible can you simulate it from the original data available in this post?