Databases
StackOverflow2013
Postsdbo
POBuild multidimensional from single array
Body
 

Note that there are some explanatory texts on larger screens.

plurals
  1. POBuild multidimensional from single array
    text
    copied!<p><strong>Outline</strong> </p> <p>After spending 2 days trying to get this to work... </p> <p><strong>Solution</strong> </p> <p>I would like to restructure my array into a multidimensional array with the following structure:</p> <pre><code> Level 1 -&gt; All level 1s Level 2 -&gt; All level 2s Level 3 -&gt; Each level Three Item Level 3 -&gt; Each level Three Item Level 2 -&gt; All level 2s Level 3 -&gt; Each level Three Item Level 3 -&gt; Each level Three Item Level 1 -&gt; All level 1s Level 2 -&gt; All level 2s Level 3 -&gt; Each level Three Item Level 3 -&gt; Each level Three Item Level 2 -&gt; All level 2s Level 3 -&gt; Each level Three Item Level 3 -&gt; Each level Three Item </code></pre> <p><strong>Data</strong></p> <p>The data is written in the order that I need it to be. For example, all <code>level 2</code> directly below a <code>Level 1</code> should site within its parent <code>Level 1</code> until the next <code>Level 1</code> turns up in the data. This should be the same for <code>Level 2</code> and <code>3</code>. Basically until a higher number comes along, it should that start a new row.</p> <p>I have many different values, the data below is just an example. Inside the array <code>level</code> refers which level it should sit under.</p> <pre><code> array ( 0 =&gt; array ( 'key' =&gt; 0, 'id' =&gt; '7', 'level' =&gt; '1', 'name' =&gt; 'About Me', ), 1 =&gt; array ( 'key' =&gt; 1, 'id' =&gt; '78', 'level' =&gt; '2', 'name' =&gt; 'My Conduct at Work', ), 2 =&gt; array ( 'key' =&gt; 2, 'id' =&gt; '270', 'level' =&gt; '3', 'name' =&gt; 'Dispute Resolution/Grievance', ), 3 =&gt; array ( 'key' =&gt; 3, 'id' =&gt; 'TBC', 'level' =&gt; '3', 'name' =&gt; 'Learn More', ), 4 =&gt; array ( 'key' =&gt; 4, 'id' =&gt; '77', 'level' =&gt; '2', 'name' =&gt; 'My Environment, Health &amp; Safety', ), 5 =&gt; array ( 'key' =&gt; 5, 'id' =&gt; 'TBC', 'level' =&gt; '3', 'name' =&gt; 'Learn More', ), 6 =&gt; array ( 'key' =&gt; 6, 'id' =&gt; '238', 'level' =&gt; '3', 'name' =&gt; 'Policies and Guidance', ), 7 =&gt; array ( 'key' =&gt; 7, 'id' =&gt; '79', 'level' =&gt; '2', 'name' =&gt; 'My GSK Employment Journey', ), 8 =&gt; array ( 'key' =&gt; 8, 'id' =&gt; '274', 'level' =&gt; '3', 'name' =&gt; 'Changes in Role', ), 9 =&gt; array ( 'key' =&gt; 9, 'id' =&gt; '275', 'level' =&gt; '3', 'name' =&gt; 'Leaving GSK', ), 10 =&gt; array ( 'key' =&gt; 10, 'id' =&gt; '273', 'level' =&gt; '3', 'name' =&gt; 'My Moves', ), 11 =&gt; array ( 'key' =&gt; 11, 'id' =&gt; '272', 'level' =&gt; '3', 'name' =&gt; 'Starting at GSK', ), 12 =&gt; array ( 'key' =&gt; 12, 'id' =&gt; '80', 'level' =&gt; '2', 'name' =&gt; 'My Personal Information', ), 13 =&gt; array ( 'key' =&gt; 13, 'id' =&gt; 'TBC', 'level' =&gt; '3', 'name' =&gt; 'Learn More', ), 14 =&gt; array ( 'key' =&gt; 14, 'id' =&gt; '276', 'level' =&gt; '3', 'name' =&gt; 'Manage my Personal Information', ), 15 =&gt; array ( 'key' =&gt; 15, 'id' =&gt; '76', 'level' =&gt; '2', 'name' =&gt; 'My Talent, Performance &amp; Development', ), 16 =&gt; array ( 'key' =&gt; 16, 'id' =&gt; '266', 'level' =&gt; '3', 'name' =&gt; 'My Development', ), 17 =&gt; array ( 'key' =&gt; 17, 'id' =&gt; '268', 'level' =&gt; '3', 'name' =&gt; 'My Learning', ), 18 =&gt; array ( 'key' =&gt; 18, 'id' =&gt; '267', 'level' =&gt; '3', 'name' =&gt; 'My Performance', ), 19 =&gt; array ( 'key' =&gt; 19, 'id' =&gt; '75', 'level' =&gt; '2', 'name' =&gt; 'My TotalReward', ), 20 =&gt; array ( 'key' =&gt; 20, 'id' =&gt; '287', 'level' =&gt; '3', 'name' =&gt; 'Learn More My Benefits', ), 21 =&gt; array ( 'key' =&gt; 21, 'id' =&gt; '288', 'level' =&gt; '3', 'name' =&gt; 'Learn More My Pay', ), 22 =&gt; array ( 'key' =&gt; 22, 'id' =&gt; '264', 'level' =&gt; '3', 'name' =&gt; 'My Benefits', ), 23 =&gt; array ( 'key' =&gt; 23, 'id' =&gt; '263', 'level' =&gt; '3', 'name' =&gt; 'My Pay', ), 24 =&gt; array ( 'key' =&gt; 24, 'id' =&gt; '265', 'level' =&gt; '3', 'name' =&gt; 'My Recognition', ), 25 =&gt; array ( 'key' =&gt; 25, 'id' =&gt; '81', 'level' =&gt; '2', 'name' =&gt; 'Time Off, Time &amp; Attendance', ), 26 =&gt; array ( 'key' =&gt; 26, 'id' =&gt; '281', 'level' =&gt; '3', 'name' =&gt; 'Flexible Working', ), 27 =&gt; array ( 'key' =&gt; 27, 'id' =&gt; 'TBC', 'level' =&gt; '3', 'name' =&gt; 'Learn More', ), 28 =&gt; array ( 'key' =&gt; 28, 'id' =&gt; '279', 'level' =&gt; '3', 'name' =&gt; 'Leave of Absence', ), 29 =&gt; array ( 'key' =&gt; 29, 'id' =&gt; '280', 'level' =&gt; '3', 'name' =&gt; 'Time &amp; Attendance', ), 30 =&gt; array ( 'key' =&gt; 30, 'id' =&gt; '278', 'level' =&gt; '3', 'name' =&gt; 'Time Off', ), 31 =&gt; array ( 'key' =&gt; 31, 'id' =&gt; '1', 'level' =&gt; '1', 'name' =&gt; 'Buying and Paying', ), 32 =&gt; array ( 'key' =&gt; 32, 'id' =&gt; '1', 'level' =&gt; '2', 'name' =&gt; 'Budget Management', ), 33 =&gt; array ( 'key' =&gt; 33, 'id' =&gt; '1', 'level' =&gt; '3', 'name' =&gt; 'Asset scrapping or sale (equipment, PC …)', ), 34 =&gt; array ( 'key' =&gt; 34, 'id' =&gt; '221', 'level' =&gt; '3', 'name' =&gt; 'Cost center creation &amp; change', ), 35 =&gt; array ( 'key' =&gt; 35, 'id' =&gt; '2', 'level' =&gt; '3', 'name' =&gt; 'Finance Partner', ), 36 =&gt; array ( 'key' =&gt; 36, 'id' =&gt; '3', 'level' =&gt; '3', 'name' =&gt; 'Operating Budget', ), 37 =&gt; array ( 'key' =&gt; 37, 'id' =&gt; '222', 'level' =&gt; '3', 'name' =&gt; 'Provision request', ), 38 =&gt; array ( 'key' =&gt; 38, 'id' =&gt; '4', 'level' =&gt; '3', 'name' =&gt; 'X-charge (Cost Transfer)', ), 39 =&gt; array ( 'key' =&gt; 39, 'id' =&gt; '3', 'level' =&gt; '2', 'name' =&gt; 'Checks, GOA &amp; X-Charge', ), 40 =&gt; array ( 'key' =&gt; 40, 'id' =&gt; '10', 'level' =&gt; '3', 'name' =&gt; 'Check Requests', ), 41 =&gt; array ( 'key' =&gt; 41, 'id' =&gt; '11', 'level' =&gt; '3', 'name' =&gt; 'Collections, credits and debts', ), 42 =&gt; array ( 'key' =&gt; 42, 'id' =&gt; '12', 'level' =&gt; '3', 'name' =&gt; 'Discounts, Rebates, Commissions and Allowances', ), 43 =&gt; array ( 'key' =&gt; 43, 'id' =&gt; '217', 'level' =&gt; '3', 'name' =&gt; 'Grant of Authority', ), 44 =&gt; array ( 'key' =&gt; 44, 'id' =&gt; '4', 'level' =&gt; '3', 'name' =&gt; 'X-charge (Cost Transfer)', ), 45 =&gt; array ( 'key' =&gt; 45, 'id' =&gt; '6', 'level' =&gt; '2', 'name' =&gt; 'Finance for Finance', ), 46 =&gt; array ( 'key' =&gt; 46, 'id' =&gt; '241', 'level' =&gt; '3', 'name' =&gt; 'Finance Assurance', ), 47 =&gt; array ( 'key' =&gt; 47, 'id' =&gt; '22', 'level' =&gt; '3', 'name' =&gt; 'Order to Cash', ), 48 =&gt; array ( 'key' =&gt; 48, 'id' =&gt; '23', 'level' =&gt; '3', 'name' =&gt; 'R2R - Group Consolidation and Intercompany Profit', ), 49 =&gt; array ( 'key' =&gt; 49, 'id' =&gt; '24', 'level' =&gt; '3', 'name' =&gt; 'R2R - Management Reporting', ), 50 =&gt; array ( 'key' =&gt; 50, 'id' =&gt; '25', 'level' =&gt; '3', 'name' =&gt; 'R2R - Record, Forms &amp; Reports', ), 51 =&gt; array ( 'key' =&gt; 51, 'id' =&gt; '251', 'level' =&gt; '3', 'name' =&gt; 'R2R - Record, General Information', ), 52 =&gt; array ( 'key' =&gt; 52, 'id' =&gt; '252', 'level' =&gt; '3', 'name' =&gt; 'R2R - Record, Get Help', ), 53 =&gt; array ( 'key' =&gt; 53, 'id' =&gt; '26', 'level' =&gt; '3', 'name' =&gt; 'R2R - Statutory Reporting', ), 54 =&gt; array ( 'key' =&gt; 54, 'id' =&gt; '27', 'level' =&gt; '3', 'name' =&gt; 'R2R - Technical Accounting', ), 55 =&gt; array ( 'key' =&gt; 55, 'id' =&gt; '28', 'level' =&gt; '3', 'name' =&gt; 'Supply Chain Accounting', ), 56 =&gt; array ( 'key' =&gt; 56, 'id' =&gt; '65', 'level' =&gt; '2', 'name' =&gt; 'Invoice and Supplier Services', ), 57 =&gt; array ( 'key' =&gt; 57, 'id' =&gt; '13', 'level' =&gt; '3', 'name' =&gt; 'Invoice and Supplier Services', ), 58 =&gt; array ( 'key' =&gt; 58, 'id' =&gt; '93', 'level' =&gt; '2', 'name' =&gt; 'Mergers, Acquisitions and Divestments Support', ), 59 =&gt; array ( 'key' =&gt; 59, 'id' =&gt; '317', 'level' =&gt; '3', 'name' =&gt; 'Engage with MAD', ), 60 =&gt; array ( 'key' =&gt; 60, 'id' =&gt; 'TBC', 'level' =&gt; '3', 'name' =&gt; 'Learn More', ), 61 =&gt; array ( 'key' =&gt; 61, 'id' =&gt; '66', 'level' =&gt; '2', 'name' =&gt; 'Procurement Card', ), 62 =&gt; array ( 'key' =&gt; 62, 'id' =&gt; '14', 'level' =&gt; '3', 'name' =&gt; 'Procurement Card Program', ), 63 =&gt; array ( 'key' =&gt; 63, 'id' =&gt; '10', 'level' =&gt; '2', 'name' =&gt; 'Procurement for Procurement', ), 64 =&gt; array ( 'key' =&gt; 64, 'id' =&gt; '49', 'level' =&gt; '3', 'name' =&gt; 'Contract Management', ), 65 =&gt; array ( 'key' =&gt; 65, 'id' =&gt; '50', 'level' =&gt; '3', 'name' =&gt; 'Market Intelligence/Research Portal', ), 66 =&gt; array ( 'key' =&gt; 66, 'id' =&gt; '325', 'level' =&gt; '3', 'name' =&gt; 'Procurement Training', ), 67 =&gt; array ( 'key' =&gt; 67, 'id' =&gt; '51', 'level' =&gt; '3', 'name' =&gt; 'Risk Management', ), 68 =&gt; array ( 'key' =&gt; 68, 'id' =&gt; '52', 'level' =&gt; '3', 'name' =&gt; 'Spend Analytics', ), 69 =&gt; array ( 'key' =&gt; 69, 'id' =&gt; '53', 'level' =&gt; '3', 'name' =&gt; 'Supplier Diversity &amp; Development Support', ), 70 =&gt; array ( 'key' =&gt; 70, 'id' =&gt; '54', 'level' =&gt; '3', 'name' =&gt; 'Supplier Relationship &amp; Performance Management', ), 71 =&gt; array ( 'key' =&gt; 71, 'id' =&gt; '64', 'level' =&gt; '2', 'name' =&gt; 'Purchases', ), 72 =&gt; array ( 'key' =&gt; 72, 'id' =&gt; '9', 'level' =&gt; '3', 'name' =&gt; 'Buy Something', ), 73 =&gt; array ( 'key' =&gt; 73, 'id' =&gt; '259', 'level' =&gt; '3', 'name' =&gt; 'Learn About', ), 74 =&gt; array ( 'key' =&gt; 74, 'id' =&gt; '3', 'level' =&gt; '1', 'name' =&gt; 'Expenses &amp; Travel', ), 75 =&gt; array ( 'key' =&gt; 75, 'id' =&gt; '69', 'level' =&gt; '2', 'name' =&gt; 'Book a Flight', ), 76 =&gt; array ( 'key' =&gt; 76, 'id' =&gt; '72', 'level' =&gt; '3', 'name' =&gt; 'Airline Reservations', ), 77 =&gt; array ( 'key' =&gt; 77, 'id' =&gt; '71', 'level' =&gt; '2', 'name' =&gt; 'Book a Ground Transportaion', ), 78 =&gt; array ( 'key' =&gt; 78, 'id' =&gt; '319', 'level' =&gt; '3', 'name' =&gt; 'Rail', ), 79 =&gt; array ( 'key' =&gt; 79, 'id' =&gt; '76', 'level' =&gt; '3', 'name' =&gt; 'Taxi, Chauffeur &amp; Limousine Services', ), 80 =&gt; array ( 'key' =&gt; 80, 'id' =&gt; '70', 'level' =&gt; '2', 'name' =&gt; 'Book a Hotel', ), 81 =&gt; array ( 'key' =&gt; 81, 'id' =&gt; '75', 'level' =&gt; '3', 'name' =&gt; 'Hotel Room Booking', ), 82 =&gt; array ( 'key' =&gt; 82, 'id' =&gt; '67', 'level' =&gt; '2', 'name' =&gt; 'Credit Card', ), 83 =&gt; array ( 'key' =&gt; 83, 'id' =&gt; '68', 'level' =&gt; '3', 'name' =&gt; 'Amex', ), 84 =&gt; array ( 'key' =&gt; 84, 'id' =&gt; '13', 'level' =&gt; '2', 'name' =&gt; 'Expense Policies and Information', ), 85 =&gt; array ( 'key' =&gt; 85, 'id' =&gt; '69', 'level' =&gt; '3', 'name' =&gt; 'Expense Policies', ), 86 =&gt; array ( 'key' =&gt; 86, 'id' =&gt; '71', 'level' =&gt; '3', 'name' =&gt; 'VAT Reclaim', ), 87 =&gt; array ( 'key' =&gt; 87, 'id' =&gt; '68', 'level' =&gt; '2', 'name' =&gt; 'Report Expenses', ), 88 =&gt; array ( 'key' =&gt; 88, 'id' =&gt; '70', 'level' =&gt; '3', 'name' =&gt; 'Report Expenses', ), 89 =&gt; array ( 'key' =&gt; 89, 'id' =&gt; '15', 'level' =&gt; '2', 'name' =&gt; 'Travel Information', ), 90 =&gt; array ( 'key' =&gt; 90, 'id' =&gt; '73', 'level' =&gt; '3', 'name' =&gt; 'Benefits Administration and Management (UK/US)', ), 91 =&gt; array ( 'key' =&gt; 91, 'id' =&gt; '74', 'level' =&gt; '3', 'name' =&gt; 'Commuter Services/Shuttle Busses', ), 92 =&gt; array ( 'key' =&gt; 92, 'id' =&gt; '77', 'level' =&gt; '3', 'name' =&gt; 'Health while travelling', ), 93 =&gt; array ( 'key' =&gt; 93, 'id' =&gt; '320', 'level' =&gt; '3', 'name' =&gt; 'Travel Alerts', ), 94 =&gt; array ( 'key' =&gt; 94, 'id' =&gt; '14', 'level' =&gt; '2', 'name' =&gt; 'Travel Insurances', ), 95 =&gt; array ( 'key' =&gt; 95, 'id' =&gt; '65', 'level' =&gt; '3', 'name' =&gt; 'Loss and theft', ), 96 =&gt; array ( 'key' =&gt; 96, 'id' =&gt; '66', 'level' =&gt; '3', 'name' =&gt; 'Material damages insurance', ), 97 =&gt; array ( 'key' =&gt; 97, 'id' =&gt; '67', 'level' =&gt; '3', 'name' =&gt; 'Travel insurance for personal injury', ), 98 =&gt; array ( 'key' =&gt; 98, 'id' =&gt; '4', 'level' =&gt; '1', 'name' =&gt; 'IT Services &amp; Access', ), 99 =&gt; array ( 'key' =&gt; 99, 'id' =&gt; '16', 'level' =&gt; '2', 'name' =&gt; 'Basic IT Access', ), 100 =&gt; array ( 'key' =&gt; 100, 'id' =&gt; '78', 'level' =&gt; '3', 'name' =&gt; 'Getting an ID', ), 101 =&gt; array ( 'key' =&gt; 101, 'id' =&gt; '254', 'level' =&gt; '3', 'name' =&gt; 'Remote Access Tokens', ), 102 =&gt; array ( 'key' =&gt; 102, 'id' =&gt; '79', 'level' =&gt; '3', 'name' =&gt; 'Request Access', ), 103 =&gt; array ( 'key' =&gt; 103, 'id' =&gt; '255', 'level' =&gt; '3', 'name' =&gt; 'Request Access - Unix, Linux, VAX, AS400', ), 104 =&gt; array ( 'key' =&gt; 104, 'id' =&gt; '23', 'level' =&gt; '2', 'name' =&gt; 'Business Unit Systems', ), 105 =&gt; array ( 'key' =&gt; 105, 'id' =&gt; '93', 'level' =&gt; '3', 'name' =&gt; 'Corporate Finance Systems', ), 106 =&gt; array ( 'key' =&gt; 106, 'id' =&gt; '84', 'level' =&gt; '3', 'name' =&gt; 'Customer Relationship Management &amp; Marketing Systems', ), 107 =&gt; array ( 'key' =&gt; 107, 'id' =&gt; '120', 'level' =&gt; '3', 'name' =&gt; 'Discovery Systems', ), 108 =&gt; array ( 'key' =&gt; 108, 'id' =&gt; '94', 'level' =&gt; '3', 'name' =&gt; 'Global Finance Systems', ), 109 =&gt; array ( 'key' =&gt; 109, 'id' =&gt; '125', 'level' =&gt; '3', 'name' =&gt; 'HH and EHS Systems', ), 110 =&gt; array ( 'key' =&gt; 110, 'id' =&gt; '118', 'level' =&gt; '3', 'name' =&gt; 'IT support for audits and inspections', ), 111 =&gt; array ( 'key' =&gt; 111, 'id' =&gt; '127', 'level' =&gt; '3', 'name' =&gt; 'Legal &amp; Procurement Systems', ), 112 =&gt; array ( 'key' =&gt; 112, 'id' =&gt; '95', 'level' =&gt; '3', 'name' =&gt; 'Make MRP Services Systems', ), 113 =&gt; array ( 'key' =&gt; 113, 'id' =&gt; '85', 'level' =&gt; '3', 'name' =&gt; 'Market and Sell systems', ), 114 =&gt; array ( 'key' =&gt; 114, 'id' =&gt; '121', 'level' =&gt; '3', 'name' =&gt; 'Medical Systems', ), 115 =&gt; array ( 'key' =&gt; 115, 'id' =&gt; '96', 'level' =&gt; '3', 'name' =&gt; 'Pack &amp; Move Services Systems', ), 116 =&gt; array ( 'key' =&gt; 116, 'id' =&gt; '86', 'level' =&gt; '3', 'name' =&gt; 'PPV &amp; Sales Reporting &amp; Compliance Systems', ), 117 =&gt; array ( 'key' =&gt; 117, 'id' =&gt; '122', 'level' =&gt; '3', 'name' =&gt; 'Pre-Clinical Systems', ), 118 =&gt; array ( 'key' =&gt; 118, 'id' =&gt; '119', 'level' =&gt; '3', 'name' =&gt; 'Quality, Risk &amp; Analytics Systems', ), 119 =&gt; array ( 'key' =&gt; 119, 'id' =&gt; '312', 'level' =&gt; '3', 'name' =&gt; 'SAP Commercial', ), 120 =&gt; array ( 'key' =&gt; 120, 'id' =&gt; '128', 'level' =&gt; '3', 'name' =&gt; 'SAP Manufacturing', ), 121 =&gt; array ( 'key' =&gt; 121, 'id' =&gt; '129', 'level' =&gt; '3', 'name' =&gt; 'Supply Chain Planning Services Systems', ), 122 =&gt; array ( 'key' =&gt; 122, 'id' =&gt; '123', 'level' =&gt; '3', 'name' =&gt; 'Test Lab Systems &amp; Support', ), 123 =&gt; array ( 'key' =&gt; 123, 'id' =&gt; '27', 'level' =&gt; '2', 'name' =&gt; 'Desk Phones, Smartphones &amp; Tablets', ), 124 =&gt; array ( 'key' =&gt; 124, 'id' =&gt; '110', 'level' =&gt; '3', 'name' =&gt; 'Desk Phone', ), 125 =&gt; array ( 'key' =&gt; 125, 'id' =&gt; '111', 'level' =&gt; '3', 'name' =&gt; 'Fax', ), 126 =&gt; array ( 'key' =&gt; 126, 'id' =&gt; '247', 'level' =&gt; '3', 'name' =&gt; 'IP Phone Communicator Configuration', ), 127 =&gt; array ( 'key' =&gt; 127, 'id' =&gt; '112', 'level' =&gt; '3', 'name' =&gt; 'IP Phone Communicator Help &amp; How To', ), 128 =&gt; array ( 'key' =&gt; 128, 'id' =&gt; '104', 'level' =&gt; '3', 'name' =&gt; 'Mobile and Smart phones', ), 129 =&gt; array ( 'key' =&gt; 129, 'id' =&gt; '250', 'level' =&gt; '3', 'name' =&gt; 'Ordering an IP Phone and Headsets', ), 130 =&gt; array ( 'key' =&gt; 130, 'id' =&gt; '107', 'level' =&gt; '3', 'name' =&gt; 'Synchronization with MS Outlook', ), 131 =&gt; array ( 'key' =&gt; 131, 'id' =&gt; '108', 'level' =&gt; '3', 'name' =&gt; 'Tablets', ), 132 =&gt; array ( 'key' =&gt; 132, 'id' =&gt; '113', 'level' =&gt; '3', 'name' =&gt; 'Teleconference solution choice', ), 133 =&gt; array ( 'key' =&gt; 133, 'id' =&gt; '114', 'level' =&gt; '3', 'name' =&gt; 'Video phone', ), 134 =&gt; array ( 'key' =&gt; 134, 'id' =&gt; '109', 'level' =&gt; '3', 'name' =&gt; 'Wifi Guest for Smartphone', ), 135 =&gt; array ( 'key' =&gt; 135, 'id' =&gt; '18', 'level' =&gt; '2', 'name' =&gt; 'EMail and Collaboration', ), 136 =&gt; array ( 'key' =&gt; 136, 'id' =&gt; '87', 'level' =&gt; '3', 'name' =&gt; 'Distribution lists', ), 137 =&gt; array ( 'key' =&gt; 137, 'id' =&gt; '324', 'level' =&gt; '3', 'name' =&gt; 'Effective Collaboration', ), 138 =&gt; array ( 'key' =&gt; 138, 'id' =&gt; '88', 'level' =&gt; '3', 'name' =&gt; 'Filtering spam', ), 139 =&gt; array ( 'key' =&gt; 139, 'id' =&gt; '89', 'level' =&gt; '3', 'name' =&gt; 'Group mailbox', ), 140 =&gt; array ( 'key' =&gt; 140, 'id' =&gt; '80', 'level' =&gt; '3', 'name' =&gt; 'Live Meeting', ), 141 =&gt; array ( 'key' =&gt; 141, 'id' =&gt; '90', 'level' =&gt; '3', 'name' =&gt; 'Lotus Notes', ), 142 =&gt; array ( 'key' =&gt; 142, 'id' =&gt; '81', 'level' =&gt; '3', 'name' =&gt; 'Office communicator', ), 143 =&gt; array ( 'key' =&gt; 143, 'id' =&gt; '91', 'level' =&gt; '3', 'name' =&gt; 'Outlook Mailbox &amp; calendar', ), 144 =&gt; array ( 'key' =&gt; 144, 'id' =&gt; '92', 'level' =&gt; '3', 'name' =&gt; 'Securing email', ), 145 =&gt; array ( 'key' =&gt; 145, 'id' =&gt; '83', 'level' =&gt; '3', 'name' =&gt; 'Videoconference', ), 146 =&gt; array ( 'key' =&gt; 146, 'id' =&gt; '19', 'level' =&gt; '2', 'name' =&gt; 'Hardware', ), 147 =&gt; array ( 'key' =&gt; 147, 'id' =&gt; '97', 'level' =&gt; '3', 'name' =&gt; 'Borrow hardware', ), 148 =&gt; array ( 'key' =&gt; 148, 'id' =&gt; '98', 'level' =&gt; '3', 'name' =&gt; 'Buy Hardware', ), 149 =&gt; array ( 'key' =&gt; 149, 'id' =&gt; '99', 'level' =&gt; '3', 'name' =&gt; 'Move hardware', ), 150 =&gt; array ( 'key' =&gt; 150, 'id' =&gt; '100', 'level' =&gt; '3', 'name' =&gt; 'Protect computer', ), 151 =&gt; array ( 'key' =&gt; 151, 'id' =&gt; '101', 'level' =&gt; '3', 'name' =&gt; 'Repair hardware', ), 152 =&gt; array ( 'key' =&gt; 152, 'id' =&gt; '102', 'level' =&gt; '3', 'name' =&gt; 'Smartphone and Mobile Devices', ), 153 =&gt; array ( 'key' =&gt; 153, 'id' =&gt; '103', 'level' =&gt; '3', 'name' =&gt; 'Upgrade computer', ), 154 =&gt; array ( 'key' =&gt; 154, 'id' =&gt; '8', 'level' =&gt; '2', 'name' =&gt; 'IT for IT', ), 155 =&gt; array ( 'key' =&gt; 155, 'id' =&gt; '35', 'level' =&gt; '3', 'name' =&gt; 'Application Infrastructure Provisioning', ), 156 =&gt; array ( 'key' =&gt; 156, 'id' =&gt; '216', 'level' =&gt; '3', 'name' =&gt; 'Application, Process and Data Integration', ), 157 =&gt; array ( 'key' =&gt; 157, 'id' =&gt; '42', 'level' =&gt; '3', 'name' =&gt; 'Connect to or from External Partners', ), 158 =&gt; array ( 'key' =&gt; 158, 'id' =&gt; '36', 'level' =&gt; '3', 'name' =&gt; 'Data Center Operations and Facilities', ), 159 =&gt; array ( 'key' =&gt; 159, 'id' =&gt; '37', 'level' =&gt; '3', 'name' =&gt; 'Database Services', ), 160 =&gt; array ( 'key' =&gt; 160, 'id' =&gt; '47', 'level' =&gt; '3', 'name' =&gt; 'Hosting Services', ), 161 =&gt; array ( 'key' =&gt; 161, 'id' =&gt; '321', 'level' =&gt; '3', 'name' =&gt; 'Infrastructure Services', ), 162 =&gt; array ( 'key' =&gt; 162, 'id' =&gt; '39', 'level' =&gt; '3', 'name' =&gt; 'IT Audit and Risk', ), 163 =&gt; array ( 'key' =&gt; 163, 'id' =&gt; '40', 'level' =&gt; '3', 'name' =&gt; 'Malicious Code Management', ), 164 =&gt; array ( 'key' =&gt; 164, 'id' =&gt; '41', 'level' =&gt; '3', 'name' =&gt; 'Network Services', ), 165 =&gt; array ( 'key' =&gt; 165, 'id' =&gt; '326', 'level' =&gt; '3', 'name' =&gt; 'Optimise Application Performance', ), 166 =&gt; array ( 'key' =&gt; 166, 'id' =&gt; '28', 'level' =&gt; '2', 'name' =&gt; 'Printer, archiving &amp; scanning', ), 167 =&gt; array ( 'key' =&gt; 167, 'id' =&gt; '115', 'level' =&gt; '3', 'name' =&gt; 'Archiving', ), 168 =&gt; array ( 'key' =&gt; 168, 'id' =&gt; '116', 'level' =&gt; '3', 'name' =&gt; 'Desk Printers', ), 169 =&gt; array ( 'key' =&gt; 169, 'id' =&gt; '117', 'level' =&gt; '3', 'name' =&gt; 'Printing &amp; scanning', ), 170 =&gt; array ( 'key' =&gt; 170, 'id' =&gt; '74', 'level' =&gt; '2', 'name' =&gt; 'Remote Access Tokens', ), 171 =&gt; array ( 'key' =&gt; 171, 'id' =&gt; '11', 'level' =&gt; '2', 'name' =&gt; 'Reporting and Data Management', ), 172 =&gt; array ( 'key' =&gt; 172, 'id' =&gt; '55', 'level' =&gt; '3', 'name' =&gt; 'BI/DW (Business Intelligence/Data Warehouse)', ), 173 =&gt; array ( 'key' =&gt; 173, 'id' =&gt; '242', 'level' =&gt; '3', 'name' =&gt; 'Business Objects Application', ), 174 =&gt; array ( 'key' =&gt; 174, 'id' =&gt; '56', 'level' =&gt; '3', 'name' =&gt; 'CERPS Data Management Service (CDMO)', ), 175 =&gt; array ( 'key' =&gt; 175, 'id' =&gt; '243', 'level' =&gt; '3', 'name' =&gt; 'Cognos Application', ), 176 =&gt; array ( 'key' =&gt; 176, 'id' =&gt; '244', 'level' =&gt; '3', 'name' =&gt; 'Cognos Planning Application', ), 177 =&gt; array ( 'key' =&gt; 177, 'id' =&gt; '245', 'level' =&gt; '3', 'name' =&gt; 'DataStage Application', ), 178 =&gt; array ( 'key' =&gt; 178, 'id' =&gt; '246', 'level' =&gt; '3', 'name' =&gt; 'DataWarehouse Service', ), 179 =&gt; array ( 'key' =&gt; 179, 'id' =&gt; '57', 'level' =&gt; '3', 'name' =&gt; 'ONE Service', ), 180 =&gt; array ( 'key' =&gt; 180, 'id' =&gt; '29', 'level' =&gt; '2', 'name' =&gt; 'Software', ), 181 =&gt; array ( 'key' =&gt; 181, 'id' =&gt; '313', 'level' =&gt; '3', 'name' =&gt; 'Manage AIT', ), 182 =&gt; array ( 'key' =&gt; 182, 'id' =&gt; '124', 'level' =&gt; '3', 'name' =&gt; 'Requesting or Removing Software', ), 183 =&gt; array ( 'key' =&gt; 183, 'id' =&gt; '30', 'level' =&gt; '2', 'name' =&gt; 'Wi-Fi &amp; internet', ), 184 =&gt; array ( 'key' =&gt; 184, 'id' =&gt; '131', 'level' =&gt; '3', 'name' =&gt; 'GSK network for business partners', ), 185 =&gt; array ( 'key' =&gt; 185, 'id' =&gt; '132', 'level' =&gt; '3', 'name' =&gt; 'Wifi for visitors', ), 186 =&gt; array ( 'key' =&gt; 186, 'id' =&gt; '133', 'level' =&gt; '3', 'name' =&gt; 'Wifi in the office', ), 187 =&gt; array ( 'key' =&gt; 187, 'id' =&gt; '134', 'level' =&gt; '3', 'name' =&gt; 'Working from Home', ), 188 =&gt; array ( 'key' =&gt; 188, 'id' =&gt; '135', 'level' =&gt; '3', 'name' =&gt; 'Working in the Office', ), 189 =&gt; array ( 'key' =&gt; 189, 'id' =&gt; '5', 'level' =&gt; '1', 'name' =&gt; 'My Team', ), 190 =&gt; array ( 'key' =&gt; 190, 'id' =&gt; '88', 'level' =&gt; '2', 'name' =&gt; 'Environment, Health &amp; Safety', ), 191 =&gt; array ( 'key' =&gt; 191, 'id' =&gt; 'TBC', 'level' =&gt; '3', 'name' =&gt; 'Learn More', ), 192 =&gt; array ( 'key' =&gt; 192, 'id' =&gt; '89', 'level' =&gt; '2', 'name' =&gt; 'My Teams\' Conduct at Work', ), 193 =&gt; array ( 'key' =&gt; 193, 'id' =&gt; '296', 'level' =&gt; '3', 'name' =&gt; 'Code of Conduct', ), 194 =&gt; array ( 'key' =&gt; 194, 'id' =&gt; '294', 'level' =&gt; '3', 'name' =&gt; 'Disciplinary', ), 195 =&gt; array ( 'key' =&gt; 195, 'id' =&gt; '270', 'level' =&gt; '3', 'name' =&gt; 'Dispute Resolution/Grievance', ), 196 =&gt; array ( 'key' =&gt; 196, 'id' =&gt; 'TBC', 'level' =&gt; '3', 'name' =&gt; 'Learn More', ), 197 =&gt; array ( 'key' =&gt; 197, 'id' =&gt; '90', 'level' =&gt; '2', 'name' =&gt; 'My Teams\' Employment Journey', ), 198 =&gt; array ( 'key' =&gt; 198, 'id' =&gt; '301', 'level' =&gt; '3', 'name' =&gt; 'Changes', ), 199 =&gt; array ( 'key' =&gt; 199, 'id' =&gt; '297', 'level' =&gt; '3', 'name' =&gt; 'Hiring', ), 200 =&gt; array ( 'key' =&gt; 200, 'id' =&gt; 'TBC', 'level' =&gt; '3', 'name' =&gt; 'Learn More', ), 201 =&gt; array ( 'key' =&gt; 201, 'id' =&gt; '275', 'level' =&gt; '3', 'name' =&gt; 'Leaving GSK', ), 202 =&gt; array ( 'key' =&gt; 202, 'id' =&gt; '300', 'level' =&gt; '3', 'name' =&gt; 'Manage an International Assignment', ), 203 =&gt; array ( 'key' =&gt; 203, 'id' =&gt; '141', 'level' =&gt; '3', 'name' =&gt; 'Onboarding', ), 204 =&gt; array ( 'key' =&gt; 204, 'id' =&gt; '299', 'level' =&gt; '3', 'name' =&gt; 'Transfer/Promote/Change Job Permanent', ), 205 =&gt; array ( 'key' =&gt; 205, 'id' =&gt; '298', 'level' =&gt; '3', 'name' =&gt; 'Transfer/Promote/Change Job Temporary', ), 206 =&gt; array ( 'key' =&gt; 206, 'id' =&gt; '91', 'level' =&gt; '2', 'name' =&gt; 'Reporting , Data &amp; Analytics', ), 207 =&gt; array ( 'key' =&gt; 207, 'id' =&gt; 'TBC', 'level' =&gt; '3', 'name' =&gt; 'Learn More', ), 208 =&gt; array ( 'key' =&gt; 208, 'id' =&gt; '304', 'level' =&gt; '3', 'name' =&gt; 'My Teams\' Information', ), 209 =&gt; array ( 'key' =&gt; 209, 'id' =&gt; '303', 'level' =&gt; '3', 'name' =&gt; 'Workday Reporting', ), 210 =&gt; array ( 'key' =&gt; 210, 'id' =&gt; '87', 'level' =&gt; '2', 'name' =&gt; 'Talent, Performance &amp; Development', ), 211 =&gt; array ( 'key' =&gt; 211, 'id' =&gt; '290', 'level' =&gt; '3', 'name' =&gt; 'Learning', ), 212 =&gt; array ( 'key' =&gt; 212, 'id' =&gt; '291', 'level' =&gt; '3', 'name' =&gt; 'Performance &amp; Development', ), 213 =&gt; array ( 'key' =&gt; 213, 'id' =&gt; '292', 'level' =&gt; '3', 'name' =&gt; 'Talent', ) ) </code></pre>
 

Querying!

 
Guidance
An individual column

Larger individual text columns get their own page to allow for proper reading.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload