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

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
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
Alteryx Certified Partner

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

Highlighted
Asteroid

Thanks JS420,I will go through.

Labels