alteryx pivot table multiple columns

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

Workflow

Accepted answers

All comments

Pivot in Excel

You cant create a pivot table like above in Alteryx.

Hope this helps : )

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?

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.

Not able to find the file please reattach the file.

Hi @atcodedog05

also not if you refresh the page?

I uploaded it again

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

Test_Workflow.yxmd

Kudos on finding the solution.

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

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:

Test_Workflow.yxmd

check the unknown columns box in the select then it would pass the new columns.

Hope this helps : )

Hi @atcodedog05

wow perfekt thanks!! Finally I understand the *unknown field. I have so often wondered why this field is always generated.

Should work perfect now!

Thanks for your help

Kudos to you on solving a complex usecase @Max90

Happy to help : )

Cheers and have a nice day!

Quick Links

Tags

This months top contributors

Hollingsworth 335