Advent of Code is back! Unwrap daily challenges to sharpen your Alteryx skills and earn badges along the way! Learn more now.

Alteryx Designer Desktop Discussions

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

creating a table from data

nirvapatel1998
7 - Meteor

Hi all, 

 

nirvapatel1998_1-1687379734351.png

 

 I am trying to create  a table that is on the right side of the picture from the data that is provided on the left side. Can someone please guide me how can I achieve the result. 

 

Thank you 

 

 

5 REPLIES 5
geraldo
13 - Pulsar

@nirvapatel1998 

 

An workflow example

geraldo_0-1687379868509.png

 

Dina
9 - Comet

Dina_0-1687380635575.png

 

 

binuacs
21 - Polaris

@nirvapatel1998 Another way of doing this

binuacs_0-1687380767109.png

 

geraldo
13 - Pulsar

@nirvapatel1998 

 

New Version for 2  or more unique no

 

geraldo_0-1687380830321.png

 

Dina
9 - Comet

Workflow for the updated table.

Dina_0-1687381324811.png

 

Labels