How to achieve this output using Alteryx - Transpose and Repeat columns

[surajseshan]

Hi Team,

Can some one help me in achieving the output below using Alteryx

Current Scenario in report

Desired Output

Thanks

Suraj

[ShankerV · Accepted solution]

hI @surajseshan 

Please find the below expected output.

Input was, 

Workflow solution:

If you believe your problem has been resolved. Please mark helpful answers as a solution so that future users with the same problem can find them more easily!!!!

Many thanks

Shanker V

[ShankerV · Accepted solution]

Hi @surajseshan 

Step 1: Input

Step 2: Filter

Step 3: Crosstab

If you believe your problem has been resolved. Please mark helpful answers as a solution so that future users with the same problem can find them more easily!!!!

Many thanks

Shanker V

[surajseshan]

Hi Shanker

Thank you for your response. can you please send me the workflow file so that i can try if it is working in my report (As the data seems to be very huge in the actual report) 

[ShankerV · Accepted solution]

Hi @surajseshan 

Step 4:

Step 5: 

Step 6:

If you believe your problem has been resolved. Please mark helpful answers as a solution so that future users with the same problem can find them more easily!!!!

Many thanks

Shanker V

[ShankerV · Accepted solution]

Hi @surajseshan 

Step 7:

Step 8:

Step 9:

Result / Output:

If you believe your problem has been resolved. Please mark helpful answers as a solution so that future users with the same problem can find them more easily!!!!

Many thanks

Shanker V

[ShankerV · Accepted solution]

@surajseshan 

Sure, give me few minutes will attach the workflow.

Am not able to save the workflow due the error prompted.

Will fix the issue and attach the workflow. In the meantime have attached the steps for you to replicate my workflow.

Many thanks

Shanker V

[surajseshan]

Hi Shanker,

Thank you .If multiple role types are coming in the subsequent records how do i do the multi join and also is there a way to combine this in a more easy manner

[surajseshan]

Hi Shanker

Thank you . I am getting stuck with multi join functionality . Please help me with the same

[surajseshan]

Hi Shanker,

Still errors in multi join functionality. i am not able to check the same in the main report. Input not able to capture properly

Thanks