Loading data with firstname and lastname in separated columns

GSQL
#1

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.

#2

Hi Darrenwang,

you can use gsql_concat(string1, string2) in your loading job, please see the examples here:
https://docs.tigergraph.com/dev/gsql-ref/ddl-and-loading/creating-a-loading-job#token-functions-for-attribute-expressions

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

Best,
Bruno

1 Like