How to merge two columns from csv into one node?

[matthew_cash]

I want to be able to create one node from two different columns in a CSV when importing the data.

Column 1: AE19
Column 2: 1202

Resulting node: AE19.1202

Is there a cypher, neo4j, or apoc command that can do this when loading the data in from a CSV?

[yyyguy · Accepted solution]

Hey @matthew.cash,

When you are creating a node, use the following example as a potential approach:

MERGE (n:Node {combined: toString(Column 1) + toString(Column 2)})

-yyyguy

[matthew_cash]

worked perfect, thank you!