Cross Tab help

Hi StephenT

Attached is even a easier solution based on my 1st solution with just a few changes. Hope this helps.

If this solves your issue please mark the answer as correct and also hit the like button, if not let me know! I've attached my workflow for you to download if needed.

Thanks,

Abhra Mitra

All comments

grazitti_sapna

Hi @StephenT , please refer to the screenshot and workflow.

Thanks.

crosstab.yxmd

Hi StephenT,

You can achieve it using transpose, crosstab and record ID tool properly.

Solution - Abhra Mitra.png

If this solves your issue please mark the answer as correct and also hit the like button, if not let me know! I've attached my workflow for you to download if needed.

Thanks,

Abhra Mitra

Apologies for not responding sooner, but took a week's leave .

I have tried the both of the above solutions on my data files, and found bhrmitra's works better for me, giving me the result I need

When running the workflow on my data file i get a warning "Warning: Dynamic Rename (7): The number of rows in the Source do not match the number of renames."

I also found that when i run the workflow for 2 people, with multiple laptops assigned (1 staff member with 9 laptops, 1 staff with 9 laptops) the workflow created the correct number of columns (9 assets x 7 columns for each asset) for the first staff member, then adds another 63 columns (9 assets x 7 columns) per the attached XLSX file.

Have I done something wrong, when configuring the workflow

Crosstab Help.xlsx

sorry, I forgot to attach a 2nd file, with how I would like the results to look.

Crosstab Help (final layout).xlsx

Hi StephenT,

Can you provide us with the exact input data so that the scenario can be replicated?

Thanks,

Abhra Mitra

Here is the data file

Download assets.csv

Hi StephenT,

Check if the attached solution works for you. You have to actually group by the User name or staff name in the "Crosstab" and "Transpose" tools.

Thanks,

Abhra Mitra

Thanks Abhra

When I run your workflow it still adds extra columns for each user.

I've had a look at the crosstab and transpose tools and can't work out how to group. I also compared the first workflow you sent last week, against today's and they look the same.

Sorry, still a learner as far as Alteryx goes.

Cheers

Stephen

grazitti_sapna

Hi @StephenT , I guess this is what you are looking for if this solves your purpose please mark this post as solution.

Thanks.

crosstab_v2_GS.yxmd

Hi StephenT

Attached is even a easier solution based on my 1st solution with just a few changes. Hope this helps.

If this solves your issue please mark the answer as correct and also hit the like button, if not let me know! I've attached my workflow for you to download if needed.

Thanks,

Abhra Mitra