Intern with Hierarchy Question

[#1]

I am an intern (and new to Qlikview) working with a large organization that has a hierarchy with just over 14,000 nodes. Using code copied from this community, I am able to load and utilize the data if I paste the table into an inline table; however, because there are multiple views of the nodes, and they can change on a monthly basis, I would like load a hierarchy from a view (table) I have stored on a sql server. I can get the pieces to work individually, but I am struggling with how to put it together. 

The following code works, but I would like to replace the inline table with a select all statement. Can this be done?

'T1:

LOAD * INLINE [

ID, ParentID, Name

    1, , World

    2, 1, Europe

    3, 1, North America

    4, 1, South America

    5, 1, Africa

    6, 1, Asia

    7, 1, Oceania

    8, 2, UK

    9, 2, France

    10, 2, Italy

    11, 3, USA

    12, 3, Canada

    13, 4, Colombia

    14, 4, Brazil

    15, 5, Nigeria

    16, 5, South Africa

    17, 6, Singapore

    18, 6, Japan

    19, 6, China

    20, 7, Australia

    21, 7, New Zeeland

];

Hierarchy(ID, ParentID, Name,,Name,TreeView) Load

ID,

ParentID,

Name

Resident T1;

drop table T1;'

Thanks!

[nagaiank · Accepted solution]

Yes, you can replace the inline load statement with

Select ID, ParentID, Name from (your data source).

[#3]

Thank you very much. *bow*