gephi.team team mailing list archive

[David E Monarchi <question115813@xxxxxxxxxxxxxxxxxxxxx>]

Question #115813 on Gephi changed:
https://answers.launchpad.net/gephi/+question/115813

    Status: Answered => Open

David E Monarchi is still having a problem:
Hi Mathieu -

Thanks for the suggestion.  I rewrote the queries as follows

Node query:
SELECT domain_name_dom as ID, fast_score_dom as force,class_dom as vertical, outgoinglinkscount_apr as outgoinglinkscount, incominglinkscount_apr as incominglinkscount  FROM gephi.CJ_EXAMPLE_DOMAIN1_DOM join  gephi.CJ_EXAMPLE_ALX_PPL_ROLLUP_APR on domain_name_dom = domain_name_apr ;

Edge query: 
SELECT ID, concat(from_domain_dda,"->",to_domain_dda) as label, from_domain_dda as source, to_domain_dda as target, nlinks_dda as weight, date_lastlink_dda as date_lastlink, latcount_dda as latcount from gephi.cj_example_d2drollup_alx_dda;

The attributes for the node (force, vertical, outgoinglinkscount, and
incominglinkscount) are still not available.  The attributes for the
edge (date_lastlink and latcount) are there, although I don't know how
to use the date_lastlink as a date.  One thought I had was to convert it
using a CAST.

Please let me know if you have any suggestions.  Thanks.

Best,
David

-- 
You received this question notification because you are a member of
Gephi Team, which is an answer contact for Gephi.