# To ignore extra columns in th delimited file connector

**URL:** <https://developer.sailpoint.com/discuss/t/to-ignore-extra-columns-in-th-delimited-file-connector/4720>\
**Category:** SHF Discussion and Questions\
**Created:** [June 21, 2022, 3:10pm UTC](https://developer.sailpoint.com/discuss/t/to-ignore-extra-columns-in-th-delimited-file-connector/4720 "2022-06-21T15:10:30Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![prajna\_shetty](https://avatars.discourse-cdn.com/v4/letter/p/65b543/32.png) [@prajna\_shetty](https://developer.sailpoint.com/discuss/u/prajna_shetty)\
**Post date:** [June 21, 2022, 3:10pm UTC](https://developer.sailpoint.com/discuss/t/to-ignore-extra-columns-in-th-delimited-file-connector/4720/1 "2022-06-21T15:10:30Z")

</div>

there are extra columns in the delimited file that shouldn’t be imported. I am not able to find the way. Has anyone worked on a similar use case?

---

<div class="post-metadata">

**Author:** ![colin\_mckibben](https://sea1.discourse-cdn.com/sailpoint/discuss/user_avatar/developer.sailpoint.com/colin_mckibben/32/37182_2.png) [@colin\_mckibben](https://developer.sailpoint.com/discuss/u/colin_mckibben)\
**Post date:** [June 21, 2022, 3:34pm UTC](https://developer.sailpoint.com/discuss/t/to-ignore-extra-columns-in-th-delimited-file-connector/4720/2 "2022-06-21T15:34:48Z")

</div>

Are these extra columns created by IDN when you export the CSV, or is it something that was added later? Are these extra columns causing import errors?

---

<div class="post-metadata">

**Author:** ![prajna\_shetty](https://avatars.discourse-cdn.com/v4/letter/p/65b543/32.png) [@prajna\_shetty](https://developer.sailpoint.com/discuss/u/prajna_shetty)\
**Post date:** [June 22, 2022, 8:10am UTC](https://developer.sailpoint.com/discuss/t/to-ignore-extra-columns-in-th-delimited-file-connector/4720/3 "2022-06-22T08:10:22Z")

</div>

> [@colin\_mckibben](#):
>
> Are these extra columns causing import errors?

I have this columns a part of csv which I suppose import to the delimited file connector. but I don’t want all the columns to be part of the schema.

---

<div class="post-metadata">

**Author:** ![colin\_mckibben](https://sea1.discourse-cdn.com/sailpoint/discuss/user_avatar/developer.sailpoint.com/colin_mckibben/32/37182_2.png) [@colin\_mckibben](https://developer.sailpoint.com/discuss/u/colin_mckibben)\
**Post date:** [June 23, 2022, 2:00pm UTC](https://developer.sailpoint.com/discuss/t/to-ignore-extra-columns-in-th-delimited-file-connector/4720/4 "2022-06-23T14:00:10Z")

</div>

The delimited file connector has no means to ignore or exclude columns. The CSV file that you import must match the account schema that is configured on the source. If you have a CSV file that has extra columns that aren’t in the account schema, then you must remove those columns before importing the file. This can be done either manually or programmatically.

---

<div class="post-metadata">

**Author:** ![system](https://global.discourse-cdn.com/sailpoint/original/2X/f/f2136700ed5e3703e0b85e02f6be799dacca7735.png) [@system](https://developer.sailpoint.com/discuss/u/system)\
**Post date:** [July 19, 2023, 2:23pm UTC](https://developer.sailpoint.com/discuss/t/to-ignore-extra-columns-in-th-delimited-file-connector/4720/5 "2023-07-19T14:23:14Z")

</div>