Specify an SQL query string for nodes (in the Nodes
tab) and an SQL query string for links (in the Links tab).
If the database is a Microsoft®
Excel®
file, you specify the name
of the sheet instead of a table name. The default sheet names in Excel®
are just Sheet1, Sheet2, and
so on.
The default query shown selects all columns from an Excel®
sheet called Nodes, as follows:
select * from [Nodes$]
In the example supplied as ArizonaData.xls
, suitable queries are as follows:
For node data:
select T1.*, T2.Availability, T2.Throughput
from [Sheet1$] as T1, [Sheet2$] as
T2 where T1.City = T2.City
For link data:
select * from [Sheet3$]