Capstone exercise Help

[omkarshinde]

I am finding it extremely difficult to pivot this particular dataset given into desirable format to compare it further in step1 itself. I request someone to give me detailed steps. I have already gone through previous exercises of transpose as well as cross tab videos also on youtube.I just have issues with this particular exercise. Please help.

[alexnajm]

I would put down a RecordID tool, then split your first dataset into two streams using a Filter tool based on even versus odd rows. Then you can Join the streams, using Record Position instead of on a key field. Then you should be able to CrossTab to finish it off

[omkarshinde]

can you elaborate the record position step join as I have exactly already done the first two steps you talked about

[alexnajm]

You can use the Join tool to join on record position - it's one of the options in the Join Tool | Alteryx Help

[omkarshinde]

---

@alexnajm wrote:

You can use the Join tool to join on record position - it's one of the options in the Join Tool | Alteryx Help

---

yeah then I got all the repeated headers on left side of my table and all values on my right. How do we use cross tab on this now?

[ShankerV]

Hi @omkarshinde 

Hope you are expecting the result like below.

Many thanks

Shanker V

[alexnajm]

I would check out the Sample Workflow for the CrossTab tool to show how it works - You would select what column you want to be your new headers, which column you want to be the values underneath those headers, and an aggregation method for those values (Concatenate for string values should work).

[ShankerV]

Hi @omkarshinde 

Please find the expected output.

As I see this a capstone project for you, does not want to attach directly the solution for you.

You can use the spoiler to check how it can be achieved.

All the best for your Capstone project!!!!

Spoiler

Spoiler

Many thanks

Shanker V

[omkarshinde]

exactly! can you please guide me and share your workflow file for referral?

[ShankerV · Accepted solution]

Hi @omkarshinde 

Sure can attach the file, hope it will help for your learning curve.