Get all numbers between two fields

[johnd2202]

Hi Everyone,

I'm trying to figure out the best way to get all of the numbers between two fields. I know this sounds confusing, but I don't know the best way to describe how to get my desired result, so see below for an example.

Current Data Structure

Column 1	Column 2
5	10

Desired Data Structure

New_Column 1	New_Column 2	New_Column 3	New_Column 4	New_Column 5	New_Column 6
5	6	7	8	9	10

I'm probably way overthinking this, but it has been bugging me to no end! Thanks in advance!

John

[LordNeilLord · Accepted solution]

Hey @johnd2202

Have a look at the generate rows tool..
This will give you all the values and then you'll need to crosstab the results to get the columns in order you want :)

Neil

[j_acon]

Not sure if i understood,

But look at the attached workflow

[johnd2202]

I'm such an **bleep**! lol. I have been using Alteryx for quite a long time and never had this scenario pop up before so I never even thought twice about the generate rows tool. Thank you for the quick response! Your explanation of an already existing solution saved me from writing overly complex formulas in the formula tool.

[johnd2202]

j_acon,

@LordNeilLord answered my stupid question. I was simply trying to get the increments between two numbers in different fields and, based on his suggestion, the generate rows tool was exactly what I needed. Thank you though!

[j_acon]

No worries, he beat me to it. Is the same answer though. :D Cheers

[haroon_sa]

Hi @johnd2202

i'd attached my file as like @j_acon solution,but i'd done it for single rows as like your input.

Thanks

Haroon.