Alteryx Designer Desktop Discussions
Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
As you've laid this ask out, in my opinion, it is not solvable. I am (and others are) not following your explanations. The provided data and result do not appear to relate to each other with the absence of logic and context that explain how the data is transformed or summarized.
Consider the following (sorry for the craziness of colors):
You can see that from the guidance you have provided it is very difficult to track the movement of the data. Translating this to an Alteryx workflow would require more intimate knowledge of the data and your ask.
I think the only way the community could help support would be for you to attach an excel document with your starting data, along with the output table, but in a way that shows the formulas and/or pivot table behavior so that we can track and attempt to replicate the logic. Unfortunately, just providing the summarized data without the formulas would not be helpful.
If this is not possible, I understand, but then would not be able to provide any further support.
Either way, best of luck and I hope you are able to figure out a solution.
Cheers, -Jay
Hi @SouravKayal
If I've understood your problem, I think this workflow does what you want:
It's basically repeating the same steps in an iterative way, and reordering your cells. I'm not 100% happy with the workflow, as there is probably a more elegant solution, but it does at least (I think) get to the desired end based on your question.
The container in the middle adds dummy issue and risk ("Issue Name"/"Risk Name") to Tasks/Risks which don't have them. I'm not sure if it's needed, but I thought it might be from your question.
Hope that helps,
Ollie
