Hi Team,
Can some one help me in achieving the output below using Alteryx
Current Scenario in report
Desired Output
Thanks
Suraj
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
Hi @surajseshan
Step 1: Input
Step 2: Filter
Step 3: Crosstab
Step 4:
Step 5:
Step 6:
Step 7:
Step 8:
Step 9:
Result / Output:
@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.
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
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.
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.
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.
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)
not able to get input 1 - senior there
input 1 - role type there
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
in this how did you get input 1 senior the third line showed and like wise
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 ?
