# Loading deliminated file using csv loader

**URL:** <https://discuss.aerospike.com/t/loading-deliminated-file-using-csv-loader/5110>\
**Category:** CSV Loader\
**Created:** [April 15, 2018, 11:51am UTC](https://discuss.aerospike.com/t/loading-deliminated-file-using-csv-loader/5110 "2018-04-15T11:51:41Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![kitex](https://avatars.discourse-cdn.com/v4/letter/k/f14d63/32.png) [@kitex](https://discuss.aerospike.com/u/kitex)\
**Post date:** [April 15, 2018, 11:51am UTC](https://discuss.aerospike.com/t/loading-deliminated-file-using-csv-loader/5110/1 "2018-04-15T11:51:41Z")

</div>

I am trying to load csv file using aerospike loader.

config file: { “version” : “2.0”, “dsv\_config”: { “delimiter”: “|” , “n\_columns\_datafile”: 2, “header\_exist”: false }, “mappings”: [ { “key”: {“column\_position”:2, “type”: “string”},

```
          "set": "cust360",
        
          "bin_list": [
            {"name":"daycd","value":{"column_position":1,"type":"string"}},
			{"name":"msisdn","value":{"column_position":2,"type":"string"}}		

          ]
        }
    ]
}

```

**test data**

```
20180404|9824
20180404|9824

```

I get following error: Column position defined for data file without header !!

---

<div class="post-metadata">

**Author:** ![kitex](https://avatars.discourse-cdn.com/v4/letter/k/f14d63/32.png) [@kitex](https://discuss.aerospike.com/u/kitex)\
**Post date:** [April 15, 2018, 2:53pm UTC](https://discuss.aerospike.com/t/loading-deliminated-file-using-csv-loader/5110/2 "2018-04-15T14:53:59Z")

</div>

so, I found if I use

if(dsvHasHeader()) { updateColumnInfoForMappingDefs(columnNames); }

instead of updateColumnInfoForMappingDefs(columnNames);

It would work. I changed the code and checked it.

[issue](https://github.com/aerospike/aerospike-loader/issues/9).
