Excel Manual Task to Perform in Alteryx

[Inactive User]

Hi Everyone,

I have to divide each cell of Col1,Col2....Coln separately with total of Col1,Col2....Coln to find Percentage of Each Col1,Col2....Coln in Col1 %.... Columns, Find below sample Data:

Can anyone help me to resolve this issue ? Thanks in Advance !

[binuacs · Accepted solution]

@Inactive User one way of doing this

[Inactive User]

Hi @binuacs,

Thanks for your revert, what if we want to perform this for muliple(20-30) columns.

[Emmanuel_G · Accepted solution]

Hi @Inactive User ,

You can find a very simple to use attached solution which is dynamic and generate exact desired output.

The main and only one tool to edit according to the number of fields is in yellow conteneur.

Let us know if it works the way you want.

Cheers !

[Inactive User]

Hi @Emmanuel_G,

Thanks for your revert, I am unable to open workflow, can you degrade it to 2019 version ?

[binuacs · Accepted solution]

@Inactive User Dynamic way of doing this. If you are using the older version of Alteryx the open the attached .yxmd into notepad++ and change the version to 2019, which you will able to see in the top of the notepad++ and save and open in Alteryx

[Ben_H · Accepted solution]

Hi @Inactive User,

There's actually a much cleaner way to get to this,

With the input you have, add a record ID and then transpose the data with Record ID as the Key Column.

Immediately Crosstab it back into the original format but make sure to check the Percent Column option.

You can clean up the headers afterward.

Note (my version of alteryx is newer, to open it in an older version open the yxmd file with notepad (right click and select open with) and change the version number to match your own.

You'll then be able to open it.

Regards,

Ben