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

Restructure Data Record

gumpi
7 - Meteor

Hi,

 

I manipulated my data using Alteryx. Now, the structure is as follows:

 

 

Store/ChainItem AItem B
M. A.53
A. M.105
A. B.87
J. L.29

 

I want to have a look at the store/chain M.A. for item A. 

To do this, I'd like to get the following structure:

 

Market size A =10+5+8+2=25
Interesting storeM. A.
Sales A5
M. A. abs share A=5/25
M. A. rel share A=5/(10/25)
Top 1 comp.A. M.
Sales A10
Top 2 comp.A. B.
Sales A8

 

The equations are just an illustration. I don't need the single numbers. I just need the result in the cell.

Do you have any idea how to achieve this?

 

Thank you very much.

 

P.S.: I am quite new to Alteryx.

3 REPLIES 3
AngelosPachis
16 - Nebula

Hey @gumpi 

 

I have mocked up a workflow that I thing meets your requirements.

 

Workflow

 

Screenshot 2020-10-18 193405.jpg

 

Output

 

Screenshot 2020-10-18 193418.jpg

 

Let me know if that helps

gumpi
7 - Meteor

Works perfectly. Thank you for your effort and have a nice week!

AngelosPachis
16 - Nebula

You're welcome @gumpi , have a nice week too

Labels