We’ve extended Inspire Early Bird Pricing until March 1. Register now and enjoy 20% off conference passes and 10% off training passes. P.S. Don’t forget to bring friends! When you sign up for five or more tickets, you get an extra 20% discount on conference passes. Learn more now.

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

Transpose Table same Index

Tommy23
7 - Meteor

Hello 

 

I have this table as Input:

 

 

Source.NameColumn1Column3

1.pdfFindingsAlert Status
1.pdfCompany Information Associated with IndividualNo information available
1.pdfSanctions, Enforcements and WatchlistsNot Alerted
1.pdfPolitically Exposed PersonsRisk Alert
1.pdfCorruptionpossible
1.pdfOthersNot Alerted
2.pdfSTRICTLY CONFIDENTIAL STRICTLY CONFIDENTIALYes
3.pdfFindingsAlert Status
3.pdfCompany Registry StatusFound
3.pdfSanctions, Enforcements and WatchlistsRisk Alert
3.pdfPolitically Exposed PersonsRisk Alert
3.pdfCorruptionRisk Alert
3.pdfOthersCould Alerted

 

 

I would  like to transform this table into this:

 

NameFindingsCompany Information Associated with IndividualSanctions, Enforcements and WatchlistsPolitically Exposed PersonsCorruptionOthersSTRICTLY CONFIDENTIAL STRICTLY CONFIDENTIALCompany Registry Status
1.pdfAlert StatusNo information availableNot AlertedRisk AlertpossibleNot AlertedNULLNULL
2.pdfNULLNULLNULLNULLNULLNULLYESNULL
3.pdfAlert StatusNULLRisk AlertRisk AlertRisk AlertCould AlertedNULLFound

 

I try to used the "Transpose" tools without success. I would like the workflow to be running even if the value inside third column is different.  I will be using this workflow for multiple "Name" with multiple column, indeed it will not only be the column present is this example but also others column.

 

I would like to thank you in advance

4 REPLIES 4
DataNath
17 - Castor

Hey @Tommy23, how's this? You'll need to be looking at Cross-Tab here rather than Transpose - the latter would be if you were going from your desired output to your input:

 

DataNath_0-1676986846135.png

 

If you're precious about the record/field order then there needs to be a bit of extra work to maintain that so let us know.

RobertOdera
13 - Pulsar

Hi, @Tommy23 

 

Here you go.

The formula in the Dynamic rename tool is: TitleCase(TRIM(Replace([_CurrentField_], '_', ' ')))

 

Please mark it as an acceptable solution if it works for you. Cheers!

RobertOdera_0-1676991114041.png

 

Tommy23
7 - Meteor

Thanks a lot @DataNath  and @RobertOdera  It was really helpfull

RobertOdera
13 - Pulsar

You're most welcome @Tommy23 

Labels