# Simple column mapping

**URL:** <https://forum.cloverdx.com/t/simple-column-mapping/263>\
**Category:** CloverDX Platform\
**Created:** [December 27, 2007, 12:00am UTC](https://forum.cloverdx.com/t/simple-column-mapping/263 "2007-12-27T00:00:00Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![ashah](https://avatars.discourse-cdn.com/v4/letter/a/ba9def/32.png) [@ashah](https://forum.cloverdx.com/u/ashah)\
**Post date:** [December 27, 2007, 12:00am UTC](https://forum.cloverdx.com/t/simple-column-mapping/263/1 "2007-12-27T00:00:00Z")

</div>

Hi,  
I have an input file that contains fields:  
CustomerID Name Street City State Zip

and want to output records of form:  
Zip Name CustomerID

basically filtering and rearranging the columns.

Can Clover handle this?  
How do I set this up using the GUI?

Thanks!

---

<div class="post-metadata">

**Author:** ![dpavlis](https://avatars.discourse-cdn.com/v4/letter/d/90ced4/32.png) [@dpavlis](https://forum.cloverdx.com/u/dpavlis)\
**Post date:** [December 28, 2007, 8:14pm UTC](https://forum.cloverdx.com/t/simple-column-mapping/263/2 "2007-12-28T20:14:24Z")

</div>

You would need to use Reformat - that allows to change the structure of data stream (pick just few fields).

Watch the video tutorial on [cloveretl.org](http://cloveretl.org) site, section Clover.GUI - it shows how to accomplish this.
