# Row's value with create

**URL:** <https://community.neo4j.com/t/rows-value-with-create/37124>\
**Category:** Cypher\
**Created:** [April 20, 2021, 7:41am UTC](https://community.neo4j.com/t/rows-value-with-create/37124 "2021-04-20T07:41:00Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![Novice](https://sea1.discourse-cdn.com/flex021/user_avatar/community.neo4j.com/novice/32/15877_2.png) [@Novice](https://community.neo4j.com/u/Novice)\
**Post date:** [April 20, 2021, 7:41am UTC](https://community.neo4j.com/t/rows-value-with-create/37124/1 "2021-04-20T07:41:00Z")

</div>

\<Please keep the following things in mind:

1. did you [search](https://community.neo4j.com/search?expanded=true) for what you want to ask before posting?
2. please use [tags](https://community.neo4j.com/tags) for additional info
3. use a self-descriptive title

Please format code + Cypher statements with the code `</>` icon, it's much easier to read.

Please provide the following information if you ran into a more serious issue:

- neo4j version, desktop version, browser version
- what kind of API / driver do you use
- screenshot of [`PROFILE` or `EXPLAIN`](https://community.neo4j.com/t/how-can-i-optimize-my-cypher-queries/114/2) with boxes expanded (lower right corner)
- a sample of the data you want to import
- which plugins / extensions / procedures do you use
- neo4j.log and debug.log\>  
===========================================================================  
Hi,  
This is my csv table. And load csv file in 'neo4j browser'  
anyway I want create node with column's name. but, failed  
 ![csvtype](https://us1.discourse-cdn.com/flex021/uploads/neo4jcommunity/original/3X/a/8/a820a370a9cad338cc975f1a600de05bcf8471af.png)

This is my failed cypher.  
I wanted to give a name according to the type of change row.\_labels name.  
Is it possible? Thank you!😅

```auto
LOAD CSV WITH HEADERS FROM 'file:///neo4j_data_ansi.csv' AS row
CREATE (row._labels: row._labels)
return *

```

---

<div class="post-metadata">

**Author:** ![Cobra](https://sea1.discourse-cdn.com/flex021/user_avatar/community.neo4j.com/cobra/32/35243_2.png) [@Cobra](https://community.neo4j.com/u/Cobra)\
**Post date:** [April 20, 2021, 7:51am UTC](https://community.neo4j.com/t/rows-value-with-create/37124/2 "2021-04-20T07:51:59Z")

</div>

Hello @Novice 🙂

You will have to use [APOC plugin](https://neo4j.com/labs/apoc/4.1/installation/), for example:

```auto
LOAD CSV WITH HEADERS FROM 'file:///neo4j_data_ansi.csv' AS row
CALL apoc.create.node([row._labels], {name: row.name, count: row.Count})
YIELD node
RETURN node

```

Links:

- [apoc.create.node()](https://neo4j.com/labs/apoc/4.1/overview/apoc.create/apoc.create.node/)
- [apoc.merge.node()](https://neo4j.com/labs/apoc/4.1/overview/apoc.merge/apoc.merge.node/)

Regards,  
Cobra

---

<div class="post-metadata">

**Author:** ![Novice](https://sea1.discourse-cdn.com/flex021/user_avatar/community.neo4j.com/novice/32/15877_2.png) [@Novice](https://community.neo4j.com/u/Novice)\
**Post date:** [April 20, 2021, 8:00am UTC](https://community.neo4j.com/t/rows-value-with-create/37124/3 "2021-04-20T08:00:20Z")

</div>

Hi, Thank you reply !

Install APOC plugin and I was try it.  
Is it wrong way?? 😬

 ![image](https://us1.discourse-cdn.com/flex021/uploads/neo4jcommunity/original/3X/2/e/2e4ee74f90c6c7e2cf8c9ec037e3973267e9479c.png)

 ![image](https://us1.discourse-cdn.com/flex021/uploads/neo4jcommunity/original/3X/e/6/e6003e1edbd59811eaa88689eaa4c8617fd2c037.png)

---

<div class="post-metadata">

**Author:** ![Cobra](https://sea1.discourse-cdn.com/flex021/user_avatar/community.neo4j.com/cobra/32/35243_2.png) [@Cobra](https://community.neo4j.com/u/Cobra)\
**Post date:** [April 20, 2021, 8:01am UTC](https://community.neo4j.com/t/rows-value-with-create/37124/4 "2021-04-20T08:01:33Z")

</div>

I forgot the `YIELD`:

```auto
LOAD CSV WITH HEADERS FROM 'file:///neo4j_data_ansi.csv' AS row
CALL apoc.create.node([row._labels], {name: row.name, count: row.Count})
YIELD node
RETURN node

```

---

<div class="post-metadata">

**Author:** ![Novice](https://sea1.discourse-cdn.com/flex021/user_avatar/community.neo4j.com/novice/32/15877_2.png) [@Novice](https://community.neo4j.com/u/Novice)\
**Post date:** [April 20, 2021, 8:05am UTC](https://community.neo4j.com/t/rows-value-with-create/37124/5 "2021-04-20T08:05:18Z")

</div>

oh...!  
nice work! 🙂

Thank you! Have a nice day!!
