Skip to main content
Solved

Changing the header name of table based on cell location

  • February 17, 2016
  • 3 replies
  • 79 views
A

Hi,

I am looking to rename a cell in an excel spreadsheet reader using the cell's location (e.g. E1) rather than the default option in AttributeRenamer of choosing a header (e.g. RATECAT, SERVICEADDRESS, ect.). I currently receive the dataset with the headers, like what is shown in the image provided, with one of the headers being the date. Every month this header changes... Is there a way for me to rename the cell in location E1 rather than renaming based on the field "2015/10"?

Thank you in advance!

Best answer by takashi

If you set 0 (or blank) to the "Field Names Row" and set 2 to the "Cell Range" in the reader parameters dialog, the Excel column names (A, B, C, ...) will be used as attribute names and the first (header) row will be skipped. Then you can rename the attributes with the AttributeRenamer, if necessary.

View original
Did this help you find an answer to your question?
This post is closed to further activity.
It may be a question with a best answer, an implemented idea, or just a post needing no comment.
If you have a follow-up or related question, please post a new question or idea.
If there is a genuine update to be made, please contact us and request that the post is reopened.

3 replies

pratap
Contributor
Forum|alt.badge.img+11
  • pratapContributor
  • Contributor
  • February 18, 2016

Hi,

If you don't want to keep the header row, set "Cell range" to start from row 1 and Place the header with attribute creator and map the header back to required attribute.

Pratap

takashi
Influencer
  • takashiInfluencer
  • Best Answer
  • February 18, 2016

If you set 0 (or blank) to the "Field Names Row" and set 2 to the "Cell Range" in the reader parameters dialog, the Excel column names (A, B, C, ...) will be used as attribute names and the first (header) row will be skipped. Then you can rename the attributes with the AttributeRenamer, if necessary.

A
  • ac_gnv
  • Author
  • February 18, 2016
pratap wrote:

Hi,

If you don't want to keep the header row, set "Cell range" to start from row 1 and Place the header with attribute creator and map the header back to required attribute.

Pratap

Hi Pratap and Takashi

Thank you both for your answers, they were great solutions and they both worked well for what I needed to do. Thanks again!

Amber

Helpful Members This Week

Community Stats

31,344
Posts
118,867
Replies
38,934
Members

Latest FME

Terms & ConditionsCookie settings

Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings
A product of
Safe Software respectfully acknowledges that we live, learn and work on the traditional and unceded territories of the Kwantlen, Katzie, and Semiahmoo First Nations.