Cross Tab help

[StephenT]

Greeting all

Apologies for the vagueness of this request

I run a weekly asset report that currently lists all assets allocated to staff members in each row (see below), and send those staff members an email to remind them to return unused assets.

Currently my report lists each asset on a seperate row (see below)

Staff name	Serial #	Primary Asset	Asset Status	Type/Model	SIM #	SIM Status
John Smith	PF1P8YFN	Yes	Spare	Laptop	123456789	Deactivated
John Smith	PC0NUMAC	No	Spare	Laptop	9876564321	Not listed
John Smith	PC0S50PG	No	Spare	Laptop	1472583969	Not listed

I have played around with the CrossTab tool as I want to have the additional laptops show in the one row for each staff member, so they appear as extra columns and not affecting the other 20+ columns or data in the report

Needs to show as (if possible)

Staff name

Serial # 1

Primary Asset 1

Asset Status 1

Type/Model 1

SIM # 1

SIM Status 1

Serial # 2

Primary Asset 2

Asset Status 2

Type/Model 2

SIM 2 #

SIM Status 2

Serial # 3

Primary Asset 3

Asset Status 3

Type/Model 3

SIM # 3

SIM Status 3

John Smith

PF1P8YFN

Yes

Spare

Laptop

123456789

Deactivated

PC0NUMAC

No

Spare

Laptop

9876564321

Not listed

PC0S50PG

No

Spare

Laptop

1472583969

Not listed

Is this possible in Alteryx 2019.3.5.17947 ?

[bhrmitra]

Hi  StephenT

Please find the updated solution attached. Apologies, I did not understand your question initially. Hope this solution helps you.

Thanks,

Abhra Mitra

[bhrmitra · Accepted solution]

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

[StephenT]

Thanks Abhra

I've combined your workflow in to my workflow, and with a bit of tweaking (of field names etc.,) it works like a treat.

The only thing i noticed is my workflow is generating 80,000+ warnings (which I am not worried about).

Thanks for your help.

I have "Liked" your workflow, and will accept it as my solution after I do a bit more testing.

Cheers

Stephen

[bhrmitra]

Hi Stephen,

Thanks. I am glad that the solution worked. You are getting the warnings because many columns have null values.

Thanks,

Abhra

[StephenT]

Thanks Abhra

I'll accept your workflow solution next week, as I now have to merge it with a 2nd workflow, and have to test it. 

Cheers

Stephen