system.kanoa.utilities.createTreeHierarchy(inputData, levels)

Takes a dataset, and appends an extra 'path' column based on the passed in levels levels are column names that the data will be grouped by Example: if levels are column1, column2, column3, the path of a row will be "value1\value2\value3" e.g data = createHierarchy(inputData, 'ItemClassCode', 'ItemClassName', 'ItemName')

---

Parameters

inputData Dataset: data to generate tree against
levels Tuple: i.e. (column1, column2, column3)

---

Returns

data Dataset

---

Example

data = system.kanoa.item.getItems()
data = system.kanoa.utilities.createTreeHierarchy(data, 'ItemClassCode', 'ItemClassName', 'ItemName')