Presidents:
LOAD 
	No, 
	No as No2,
	Name, 
	Born, 
	Deceased, 
	TermFrom, 
	TermTo, 
	Party
FROM Presidents.txt (txt, utf8, embedded labels, delimiter is '\t', msq);

// ========================================
SemanticTable:
Semantic
Load 
	No - 1 as No,
	'Successor' as Relation,
	No,
	'Predecessor' as Relation
	Resident Presidents
	Where No > 1
	Order By No;