Assign a number per value upto a limit

Hi,

My data looks similar to this. Value is in descending order. (Name has been trimmed for privacy and all of them are unique)

I want to create an extra column which will have numbers from 1 onwards i.e highest Value gets 1 and so on.

Also, another condition is if the Value sum equals 75, remaining Rows should be assigned'0' in that extra column.

Attached is the sample data file. File Name is a random unique place name. For each place, the process should repeat. I'm using Alteryx 2018.2

Please provide your valuable suggestions/solutions. Greatly appreciated.

Regards,

Anudeep

TEST_Alteryx community.xlsx

Accepted answers

Qiu

@anudeepy
Your decription is very clear to me.

Check if this is what you need.

Appreciate if you would mark it as accepted if it does help.

Your Alteryx version might be an issue to open my workflow, but it should be ok if you just click ok and proceed.

1103-anudeepy.yxzp

All comments

Emil_Kos

Hi @anudeepy,

I have created a workflow for you:

Please let me know if this is what you were looking for!

Interesting.yxmd

Qiu

@anudeepy
Your decription is very clear to me.

Check if this is what you need.

Appreciate if you would mark it as accepted if it does help.

Your Alteryx version might be an issue to open my workflow, but it should be ok if you just click ok and proceed.

1103-anudeepy.yxzp

anudeepy

Hi Emil,

Thanks for your prompt reply. I need the extra column to have numbers 1, 2, 3 for values adding up to 75. and others to be 0.

The highest vale be assigned 1, following 2, and so on till the sum reaches 75 and all others become 0 after..

Thank you,

Anudeep

anudeepy

Hi Qiu,

I'm unable to even download your solution. It says No file. Can you please resend it?

Note - I think your workflow might be the solution. Just want to have a closer look.

Thank you,

Anudeep.

vizAlter

Hi @anudeepy — Try this solution which can also be done without using a Multi-Row formula:

If this assists you please mark the answer "Solved" with a Like, if not let me know!

Assign a number per value upto a limit__vA.yxmd

vizAlter

@anudeepy — Enclosed workflow for your 2018.2 version

Assign a number per value upto a limit__vA - 2018.2.yxmd

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703