# How to delete a column in Flatfile after parsing the data

**URL:** <https://techcommunity.softwareag.com/t/how-to-delete-a-column-in-flatfile-after-parsing-the-data/109846>\
**Category:** Forum\
**Tags:** EDI\
**Created:** [March 24, 2009, 1:57am UTC](https://techcommunity.softwareag.com/t/how-to-delete-a-column-in-flatfile-after-parsing-the-data/109846 "2009-03-24T01:57:24Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![Guest](https://sea1.discourse-cdn.com/techcommunity/user_avatar/techcommunity.softwareag.com/guest/32/75_2.png) [@Guest](https://techcommunity.softwareag.com/u/Guest)\
**Post date:** [March 24, 2009, 1:57am UTC](https://techcommunity.softwareag.com/t/how-to-delete-a-column-in-flatfile-after-parsing-the-data/109846/1 "2009-03-24T01:57:24Z")

</div>

Hi all,

I am trying flatfile parsing. I have successfully parsed the flatfile by flat file schema. Now, My requirement is after parsing the data…if there are any NULL fields under any column. It should not display that column.

For example, X is a column. In the flatfile there is no value for X. So, after parsing…it should not show the column X in the output.

I tried using…Format Services…but I didn’t had any luck.

Please help with your suggestions.

Thanks in advance.  
David.

---

<div class="post-metadata">

**Author:** ![reamon](https://avatars.discourse-cdn.com/v4/letter/r/b77776/32.png) [@reamon](https://techcommunity.softwareag.com/u/reamon)\
**Post date:** [March 24, 2009, 2:18am UTC](https://techcommunity.softwareag.com/t/how-to-delete-a-column-in-flatfile-after-parsing-the-data/109846/2 "2009-03-24T02:18:21Z")

</div>

What is the target format? How is it defined?

---

<div class="post-metadata">

**Author:** ![gupta\_r.17495](https://avatars.discourse-cdn.com/v4/letter/g/9fc348/32.png) [@gupta\_r.17495](https://techcommunity.softwareag.com/u/gupta_r.17495)\
**Post date:** [March 24, 2009, 7:59am UTC](https://techcommunity.softwareag.com/t/how-to-delete-a-column-in-flatfile-after-parsing-the-data/109846/3 "2009-03-24T07:59:52Z")

</div>

There is no direct way to accomplish this…But once you parse the data you can create a temp document and map/append the only records that are not null…and later use this new temp document in your downstream process.

HTH,  
RMG

---

<div class="post-metadata">

**Author:** ![system](https://global.discourse-cdn.com/techcommunity/original/3X/c/d/cd19967bb605d28a72d77eb83a1cae22f3df2eb8.svg) [@system](https://techcommunity.softwareag.com/u/system)\
**Post date:** [April 2, 2021, 3:05pm UTC](https://techcommunity.softwareag.com/t/how-to-delete-a-column-in-flatfile-after-parsing-the-data/109846/4 "2021-04-02T15:05:54Z")

</div>


