none
Table Arrangement / Transformation RRS feed

  • Question

  • Hello all,

    my original table contains three columns (DeviceTransactionID, AllocationCodeName, AllocationCodeValue) and it can be the case that multiple AllocationCodeNames and AllocationCodeValues are linked to one DeviceTransactionID. In such cases, the data are listed in addtional rows. Now I would like to transform the table in the sense that I get only one row per DeviceTransactionID. The multiple AllocationCodeNames and AllocationCodeValues shall be added as additional columns (AllocationCodeName1, AllocationCodeValue1, AllocationCodeName2, AllocationCodeValue2, AllocationCodeName3, AllocationCodeValue3, etc.). How can I realize this? I appreciate your support - thanks in advance!


    Friday, February 17, 2017 12:31 PM

Answers

  • Presuming your table has only those 3 columns, follow this recipe:

    • select the AllocationCodeName column 
    • in the Transform ribbon, click Pivot Column
    • choose AllocationCodeValue as your Values Column

    Dale


    Friday, February 17, 2017 2:15 PM