How to set up data for edge data?

Hey guys, I’m in the process of converting a bunch of csv files to JSON format and I’ve come to a bit of a head scratcher.

I’ve been following this guide to do the conversion so far :
https://dgraph.io/docs/howto/loading-csv-data/#sidebar

Here is my header for the specific file I want to load :
Forumid | Personid | joinDate

For my previous files that were straight forward, they only had 2 columns.
How would I format this file so that I could load a piece of data on to the connecting edge between the forumID and personID?

Thanks,
Kevin

Hey @wood ,

You can consider removing the third column by some pre-processing, in case the joinDate isn’t required. Else you can create two rows for each row in your data, for eg.

Forumid | Personid | joinDate
will become
Forumid | Personid
Personid | joinDate
please let me know in case of any doubts.

Hi @Neeraj,

Thanks for the response.

So are you suggesting that I put the joinDate as a property of Personid?

yes.

There is a possibility of multiple dates per personid.
Is it possible to store data on the edge? If not, I will skip this step.

Yes, you can use Facets to store the data on edges.

Ok thanks for confirming - I spent a little time looking into that and I played with ratel and got it working.

1 Like