How to perform data load considering 3 nodes and 2 edges in tigergraph

Use Case.
The No of Sales order for an FGA manufactured in a site and fulfilled by the relevant site should be loaded to the corresponding edge between Manufacturing and Fulfilment Site.
The No of Sales order value will be the attribute of the edge between Manufacturing and Fulfilment Site.
When the user wants to traverse for an FGA via Manufacturing and Fulfilment site , the user should be able to see the No of sales order in the attribute of the edge between Manufacturing and Fulfilment site.

Sample data
FGA Manufacturing Site Fulfilment Site # of Sales order
ABC US US1 8
XYZ US US1 6
XYZ1 US US1 2
XYZ2 US US1 1
XYZ3 US US1 7
XYZ4 US US1 3
ABC1 CA US1 30

Design
a. Individual Nodes are created for FGA, Manufacturing Site , Fulfilment Site
b. Edges are created between.
Edge Name Node1 Node 2
Produces FGA Manufacturing Site
FulfillsTo Manufacturing Site Fulfilment Site

c. The “# of Sales order” value will be loaded to the Edge “FulfillsTo”

Problem Statement.
When the data ( given in the use case above) is loaded to the above Nodes and to the edges, the data is not getting correctly loaded.
We see that the data to the edge “FulfillsTo” is getting loaded as comma separated list for all the values under the combination of Manufacturing site and fulfilment Site.
Example as per the above data

Ask
Will the user be able to see the right data for the FGA, Manufacturing Site, Fulfilment combination at the FulfillsTo edge.

Ex if user selects ABC , traverse to US and to US1, the edge between US and US1, the edge should show 8 ( instead of 8,6,2,1,7,3)

1 Like