Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

Creating Pivot Table

nat0028
6 - Meteoroid

Hi,

 

I've just started to use Alteryx Designer and have run into some issues regarding creating a "pivot" table from an output of a workflow which I created.  I've attached an excel file with the first tab for the data (# of VAR columns can differ depending on data), and a second tab  for the desired results.  I've tried numerous Transform functions including combining them, but just can't seem to produce the table needed.  Thanks.

4 REPLIES 4
vizAlter
12 - Quasar

@nat0028 — Welcome to the Alteryx Discussion!

Try this solution:

 

vizAlter_0-1603913348270.png

 

ImadZidan
12 - Quasar

Hello @nat0028 ,

 

May be this will help.

 

 

nat0028
6 - Meteoroid

Tnx.  This helps.

vizAlter
12 - Quasar

@nat0028 — Thank you!

Labels