Alteryx Designer Desktop Discussions

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

Transpose and get separate table per ID

dexter90
8 - Asteroid

Hi All,

 

I am stuck with a table forma need.My data is ID,IssueID,Issue,Details.For each ID I have to create a transpose table with each issueid and details ,one table per finding.

 

Ex:Table 1

      ID1:

      IssueID1:

      Details

 

      Table 2

       ID1:

       IssueID2

       Details

 

I have attached a sample workflow,any suggestions would be helpful.

 

 

4 REPLIES 4
JosephSerpis
17 - Castor
17 - Castor

Hi @dexter90 I mocked up a workflow that I think answers your question let me know what you think?

dexter90
8 - Asteroid

Awesome this works.Any suggestions on what to study to come up on own such solutions?

JosephSerpis
17 - Castor
17 - Castor

Hi @dexter90 I learnt mostly through practice but the interactive lessons and weekly challenges are good places to look at.

dexter90
8 - Asteroid

Thanks JS420,I will go through.

Labels