Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

Alteryx Designer Desktop Discussions

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

Incremental String (Excel Formula) based on Location

Mert
Alteryx
Alteryx

Hi,

 

Here is my dummy data:

 

LocationCategoryQtyBudget
Los AngelesRev4100
Los AngelesExp6170
New YorkRev2200
New YorkExp4250
LondonRev7325
LondonExp6325

 

What I would like to achieve is to add a field and add string (Excel formula) to every cell starting as C5*D5, incrementing based on Location. Please see below:

 

LocationCategoryQtyBudgetFormula
Los AngelesRev4100C5*D5
Los AngelesExp6170C6*D6
Los AngelesExp6120C7*D7
New YorkRev2200C5*D5
New YorkExp4250C6*D6
LondonRev7325C5*D5
LondonExp6325C6*D6

 

 

Any suggestions please? Thanks!

 

5 REPLIES 5
PhilipMannering
16 - Nebula
16 - Nebula

HI @Mert 

 

Not sure exactly what you're going for here, but does the following help?

PhilipMannering_0-1653938044224.png

 

DataNath
17 - Castor

If you just want the formula generating to then use downstream/export somewhere then this will start again at C5*D5 for each location:

 

DataNath_0-1653939885144.png

 

Let us know if the requirement is something different - happy to revisit!

binuacs
20 - Arcturus

@Mert Another way of doing this with the tile tool

 

binuacs_0-1653978055801.png

 

Mert
Alteryx
Alteryx

@binuacs and @DataNath thank you both for your prompt and working replies.

 

@PhilipManneringthank you for your time as well however I need a workflow that approaches the new field incrementally per location.

PhilipMannering
16 - Nebula
16 - Nebula

No worries @Mert. As long as the community as a whole has provided you with a working solution, that's the main thing! 

Labels