Hi TG community,
In the TG documentation, it says that data can be mapped many-to-many meaning that two files should be able to be mapped to the same vertex or edge. However, I am unable to do this because TG requires the vertex ID to be identified from both of the files in the data mapping. In my case, the vertex ID is a concatenation of two variables that exist in one of the files but not the other. This means that I can’t map an attribute when in my csv file they are easily connected by an ID. One of the examples in my graph:
I have 2 vertices (“Accident” and “Consult”) that are connected by an edge. I have 2 csv files, one is called claims (that contains the attributes - cliamID, personID and acciToFirstConsult) and the other is called payments (that contains the attributes - claimID and paymentID). The “Accident” vertex primary ID is the concat of personID and claimID, the “Consult” vertex primary ID is the concat of paymentID and the constant “1”. I want to add the attribute acciToFirstConsult to the edge that connects the Accident and Consult Vertices but can’t because the claims csv file does not contain the paymentID from the payments file even though they can be connected via the claimID that exists in both files.
Is there a way to map this attribute on TG? Note, I am mapping the data via the TG interface.
Thanks for your help in advance!