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]

@surajseshan 

Could you please share the screenshot of the issue.

Will be able to identify the bug.

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

[surajseshan]

not able to get input 1 - senior there

[surajseshan]

input 1 - role type there

[ShankerV · Accepted solution]

Hi @surajseshan 

Can you please attach the workflow with the sample data's.

I see the column name shared with random sample are different from the screenshot.

Many thanks

Shanker V

[surajseshan]

Hi Shanker,

Thanks . just that i am not able to take role type there in that multi join. can you please send the workflow so that i can have a look and amend it in my report field accordingly

[surajseshan]

in this how did you get input 1 senior the third line showed and like wise

[ShankerV · Accepted solution]

Hi @surajseshan 

By joining the output node to the join multiple tool.

Green, Orange, Blue and Yellow are highlighted in different colors for your reference.

Let me know if you have any more questions. Happy to support.

Many thanks

Shanker V

[surajseshan]

Hi Shanker

Thanks . i went as per the steps but still that 3rd line in join tool i am not able to achieve. will be really helpful if you can attach the work flow so that i can replicate the same with the change of column names as per my original data

if possible is there any way to reach out so that i can get it cleared with you via chat ?

[ShankerV · Accepted solution]

Hi @surajseshan 

The field name cant be same as Start date and Start date.

Hence it can be modified as Senior Start date, Manager Start date and so on to have the difference.

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