Excel Manual Task to Perform in Alteryx

Question

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 !

binu_acs · Accepted Answer

@Inactive User one way of doing this

Emmanuel_G · Accepted Answer

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 !

binu_acs · Accepted Answer

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

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