Combinations & Tiling to Denormalize the Data Matrix

[mgrajkumar]

Hi,

I need a help.

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

RecordID	Type	TYPE_VALUE
1	CITY	MUMBAI
1	COUNTRY	INDIA
1	REGION	ASIA

Expected Output

	CITY	COUNTRY	REGION
REGION			ASIA
COUNTRY		INDIA	ASIA
CITY	MUMBAI	INDIA	ASIA

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

[binu_acs]

@mgrajkumar you can do something like below

[mgrajkumar]

Hi @binu_acs 

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

[CoG]

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):

Happy Solving!!!