Alteryx Designer Desktop Discussions

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

Combinations & Tiling to Denormalize the Data Matrix

mgrajkumar
7 - Meteor

Hi,

I need a help.

For the below dataset how to de-norrmalize the data considering record id as the key

RecordIDTypeTYPE_VALUE
1CITYMUMBAI
1COUNTRYINDIA
1REGIONASIA

 

Expected Output

 

 CITYCOUNTRYREGION
REGION  ASIA
COUNTRY INDIAASIA
CITYMUMBAIINDIAASIA

 

I got all the combiations of the data with crossing it, then i tried with Tile and Cross and Transpose but couldn't arrive the result.

 

Appreciate any help

 

Thx

3 REPLIES 3
binuacs
20 - Arcturus

@mgrajkumar you can do something like below

image.png

mgrajkumar
7 - Meteor

Hi @binuacs 

Thanks for the response. In my case the type and type values are dynamic so i can't hardcode these values in the formula. May need a refined approach. I tried few combinations but couldn't achieve the desired results 

 

Thanks

Raj

AndrewDMerrill
13 - Pulsar

Here is a more dynamic workflow that should still accomplish what you're looking for (This workflow assumes that the data starts in order (e.g. city is at the top for a given recordID and region is on the bottom):

_Screenshot.png

Happy Solving!!!

Labels