Graphgen in Aster Express

Database
Enthusiast

Graphgen in Aster Express

Hello,

 

This is the format of a simple nPath output that I saved on a table called path_out

 

[HOME]2072
[HOME, GLOBAL SEARCH: KEYWORD: SEARCH]275
[ACCOUNT-LANDING]158
[GLOBAL SEARCH: KEYWORD: REFINE]156
[PROMO: MOBILERELEASECALEN: 5003224]109
[HOME, HOME, HOME]68
[HOME, RELEASE-CALENDAR]61

 

Below it is my graphgen code but I get an error 'relation "nodes" does not exist'.  I know that 'nodes' is not on my table.  Please would you tell how I should change my code to graph my nPath output file 'Path_output'?  Thanks.

 

SELECT *

FROM GraphGen (

ON (select path, cnt from path_output)

PARTITION BY 1

ON nodes AS nodes

DIMENSION

item_join_col('id')

item_format('npath')

item1_col('path')

score_col('cnt')

output_format('sandkey')

directed('true')

title('Path Test')

)

;