Cross Tab

I have a table that I'm pulling in and it has only two fields. Pin and Language. There can be multiple rows for each pin because they may have multiple languages.

What I need is to transform and have 1 row for each PIN and then columns for their languages.

How can I use the Cross Tab tool to do this because I can't seem to get it to work?

Transformation

Accepted answers

grazitti_sapna

Hi @cowannbell , Another way to approach the solution.

If this is what you are looking for kindly mark this post as solution.

Thanks.

Cross Tab-GS.yxmd

All comments

AngelosPachis

Hi @cowannbell ,

I have created a new field that acts as a flag, before using a cross-tab tool to bring the table in the format that you would like.

"y" stands for yes, so everything else is no, so that langiage is not contained in that pin group.

Let me know if that worked for you

Cheers,

Angelos

example.yxmd

vizAlter

Hi @cowannbell — Try this solution:

Here, I have included an example of duplicates row (PinCodes and Languages), then presented in the sorted output:

CrossTab PinCodes__vA.yxmd

grazitti_sapna

Hi @cowannbell , Another way to approach the solution.

If this is what you are looking for kindly mark this post as solution.

Thanks.

Cross Tab-GS.yxmd

cowannbell

Thank you all so much. Sapna's solutions worked best for my needs.

Quick Links

This months top contributors

AkimasaKajitani 387

mceleavey 383

mbarone 337

Hollingsworth 335

LanisC 335