Combinations & Tiling to Denormalize the Data Matrix

Question

Hi,

I need a help.

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

RecordIDTypeTYPE_VALUE1CITYMUMBAI1COUNTRYINDIA1REGIONASIA

Expected Output

CITYCOUNTRYREGIONREGION  ASIACOUNTRY INDIAASIACITYMUMBAIINDIAASIA

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

CoG · Answer

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!!!

Sample Workflow.yxmd

mgrajkumar · Answer

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

binu_acs · Answer

@mgrajkumar you can do something like below

Denormalise_161223.yxmd