Assign a number per value upto a limit

[anudeepy]

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

[Emil_Kos]

Hi @anudeepy,

I have created a workflow for you:

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

[Qiu · Accepted solution]

@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.

Y

[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.

[messi007]

Hello,

Attached the workflow.

Hope it will help 🙂

Regards,

[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!

[vizAlter]

@anudeepy — Enclosed workflow for your 2018.2 version

[anudeepy]

Thank you @Viz Works well and good.

Thank you @messi007 but the numbering is reversed in your case. But thank you for your efforts.

[Qiu]

@anudeepy 
Thank you for the mark.
I am uploading the workflow again for your reference, both the workflow and the package.