Skip to content

Instantly share code, notes, and snippets.

@ralfbecher
Last active September 26, 2015 20:20
Show Gist options
  • Save ralfbecher/a44eb3a4ecdafacfd676 to your computer and use it in GitHub Desktop.
Save ralfbecher/a44eb3a4ecdafacfd676 to your computer and use it in GitHub Desktop.
QlikView transform matrix into adjacencylist
// matrix has numeric field names starting from "0" and a record number:
for i=0 to 34
for j=0 to 34
adj_list:
LOAD $(i) as node1,
$(j) as node2,
"$(j)" as measure
resident matrix
Where rec - 1= $(i) and "$(j)" > 0;
next
next
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment