alteryx pivot table multiple columns

[Max90]

Hi all, 

Is it possible to create a pivot with multiple columns?
I have already found several posts but no solution leads to the correct output. 

Raw Data

Pivot in Excel

Did any of you already had the same problem or does anyone know a post that solves such a problem?

Thanks for any help! 

Best wishes 
Max

[atcodedog05]

Hi @Max90 

Pivot in Excel

---

You cant create a pivot table like above in Alteryx.

Hope this helps : )

[Max90]

Thanks a lot for your answer. 

I do not need the function to hide anything. It would be enough if I have a hardcopy of the table. 

Is this also not possible?

[atcodedog05]

Hi @Max90 

Can you provide some sample input and expected output it will help us get a better understanding of the usecase.

[Max90]

Hi @atcodedog05

I uploaded you a Test Excel File. 

Upper lines - row data

Middle lines - two possible expected outputs. Different ways are possible

last lines- Pivot in Excel (not necessary)

If it is not understandable please let me know.

[atcodedog05]

Hi @Max90 

Not able to find the file please reattach the file.

[Max90]

Hi @atcodedog05

also not if you refresh the page? 

I uploaded it again 

[Max90]

Hi @atcodedog05

I found a solution for my problem. Could you have a look on it if you find any mistakes or is there maybe a better solution?

Thanks a lot

Regards

Max

[atcodedog05]

Hi @Max90 

Kudos on finding the solution.

This is one of the hectic usecases. If you are getting the expected output you should be good 🙂

[Max90]

Hi @atcodedog05

I found one mistake in my workflow. Maybe you can help me to solve it. See the attached Screenshots for my problem. The last select tool on my workflow do not change automatically if more lines are in the input file. If there is for example one more line, F9 would be created and should also be selected. In other words I need a option to select always all Fields with F plus Account and Balance at the beginning. 

Is my problem understandable? 

I also uploaded a new version of my workflow (one formula tool was missing)

Thanks a lot 
Max

Select tool: