Crosstab Help

Hello all,

Right now, I currently have a crosstab result that looks like this

The issue is that each user(s) have a different manager. However, the cross tab function seems to have removed that relationship between user and the manager. This means when I try to render out separate tables for each manager, the same users stick around in the top row because the relationship was lost. What can I do?

TestWorkflow.yxmd

Workflow

Accepted answers

All comments

Qiu

@MWon
If I understand your intention correctly, you want the header to be dynamic and only users belong to that manager to be appear.

In that case, we can do a Batch Macro like below.

TestWorkflow-r1.yxzp

MWon

Thank You, I am currently using an older version of Alteryx, so I cannot open your macro. Could you describe what you did to achieve that result?

Qiu

@MWon
below is the snapshot of the macro.
I use the manager name as control parameter, then move the most part of your original flow to the macro.

MWon

I'm starting to get the general idea, however, I am having a bit of trouble setting up the macro, as I am not super familiar with using them. Would it be possible to see more on how you set up the settings for the macro themselves and your thought process?

SPetrie

If you want to open the macro @Qiu created, you can edit the file to match your Alteryx version.

Open the file in a text editor like notepad or notepad++ and change it to match your version number and then save the file. Open it in Alteryx and you should be good.

I reattached Qiu's workflow and macro for you with the only change being that I edited it to be Alteryx version 2020.4.

2020.4TestWorkflow-r1.yxzp

Qiu

@SPetrie
Thank you very much for the help!

MWon

Than you for the help. I wanted to ask about if there was a way to adjust the macro such that in can take input later. In my original workflow, I am joining two databases and doing some processing before running the macro. However, the macro input tool only seems to accept raw text table or an existing file, which is not what I need.

I've included screenshots below

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15881

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703