Loading data with firstname and lastname in separated columns

Hello everyone. I am trying to load a csv file to my created schema. One of the vertexes contains (primary id, first name, last name, full name, age, etc). However, the csv file that I have only have first name and last name in separated columns. Is there any way that I can combine them together as a new column or put them into one column then insert it to my primary id?

I am totally a new learner for tighergraph, hope you guys can show me some methods or how to implement this would be better.

Thank you so much.

Hi Darrenwang,

you can use gsql_concat(string1, string2) in your loading job, please see the examples here:

I would recomend you to go through our 101 training if you haven’t done it already: https://www.tigergraph.com/certification-gsql-101/


1 Like