- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
How to create hierarchy tree view
Hi Guru's
How to create Hierarchy with the excel data.
below is the output format.
Thanks in advance
Thanks,
jason
Accepted Solutions
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Look at the Hiearchy function
Using the data below:
[Data]:
LOAD ProjectName,
TaskName,
TaskOutlineLevel,
TaskId,
ParentTaskId,
ProjectId,
TaskClientUniqueId,
ParentTaskName
FROM
[H:\Temp\test data.xlsx]
(ooxml, embedded labels, table is Sheet1);
[HierarchyTree]:
Hierarchy (TaskId,Parent,NodeName,'PathParent',NodeName,'TaskPath','/',Depth)
LOAD TaskId,
ParentTaskId as Parent,
TaskName as NodeName
Resident [Data];
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Look at the Hiearchy function
Using the data below:
[Data]:
LOAD ProjectName,
TaskName,
TaskOutlineLevel,
TaskId,
ParentTaskId,
ProjectId,
TaskClientUniqueId,
ParentTaskName
FROM
[H:\Temp\test data.xlsx]
(ooxml, embedded labels, table is Sheet1);
[HierarchyTree]:
Hierarchy (TaskId,Parent,NodeName,'PathParent',NodeName,'TaskPath','/',Depth)
LOAD TaskId,
ParentTaskId as Parent,
TaskName as NodeName
Resident [Data];