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 1Column 2510 Desired Data Structure New_Column 1New_Column 2New_Column 3New_Column 4New_Column 5New_Column 65678910 I'm probably way overthinking this, but it has been bugging me to no end! Thanks in advance! John

Get all numbers between two fields

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

Parse

Transformation

Expression

Accepted answers

LordNeilLord

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

All comments

LordNeilLord

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

Gen Columns.yxmd

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!

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.

column.yxmd

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703