Advent of Code is back! Unwrap daily challenges to sharpen your Alteryx skills and earn badges along the way! Learn more now.
Free Trial

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

Automatically Generating Rows Between Existing Data

WSPAY123
5 - Atom

Greetings!

 

Wee bit of a newbie question - but I am rusty and getting back into Alteryx after a year away.

 

I am wanting to generating distances of 0.1KM (100 metres) between existing data so I can do some basic interpolation.

 

For example, in the screenshot, I am missing the distances between 64.9 and 67.3 - The reality is there is no data there, but I'd like to generate those rows (so 65.0, 65.1, etc) at the very least. Is there an easy way to do so?

 

Many thanks!

3 REPLIES 3
Raj
16 - Nebula

@WSPAY123 you can use generate rows to achieve this.
hope this helps
mark done if solved.

gawa
16 - Nebula
16 - Nebula

Generate Rows tool will do!

image.png

Raj
16 - Nebula

@WSPAY123 
find the workflow attached

mark done if solved.

Labels
Top Solution Authors