Capstone exercise Help

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.

Capstone.yxzp

Workflow

Power BI

Accepted answers

ShankerV

Hi @omkarshinde

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

For learning.yxzp

ShankerV

Hi @omkarshinde

Please find the solution via Join for your learning purpose.

Many thanks

Shanker V

For learning vai Join tool.yxzp

All comments

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

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

Many thanks

Shanker V

omkarshinde

actually i had proceeded via the earlier approach and reached till join via record position. Any way I can reach solution via that?

ShankerV

Hi @omkarshinde

One second, I will recreate the earlier flow.

It was too lengthy one to use join tool, so I deleted and used the different approach.

JRBeaudry

Nice work ShankerV, That was very useful and with the "For learning" a very good addition to my learning path ! 🤓

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15878

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703