community
cancel
Showing results for 
Search instead for 
Did you mean: 

Alteryx designer Discussions

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

Transpose and get separate table per ID

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

 

 

Alteryx Certified Partner

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

Asteroid

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

Alteryx Certified Partner

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

Asteroid

Thanks JS420,I will go through.

Labels