Solved

List to Attributes

  • 17 July 2017
  • 4 replies
  • 30 views
pratap
Rank
Badge +2

Hi,

I have configuration file from which I have to extract attributes headers for excel file.

I have managed to bring as shown below...

A,B,C,D,E

Now I want to convert this to attribute header A B C D E

attached a screenshot for better understanding... Could any one throw some light and suggest me...

icon

Best answer by redgeographics 17 July 2017, 16:11

View original

4 replies

erik_jan
Rank
Userlevel 2
Badge +16

I think the AttributeSplitter is the transformer you need.

pratap
Rank
Badge +2

It is making list rather than attribute header.

redgeographics
Rank
Userlevel 5
Badge +25

I think I have a nice workaround: writing to a temporary CSV file and then reading that back in.

none2none.fmw

takashi
Rank
Userlevel 2
Badge +17

If you need to use A, B, C... (Excel column names) as attribute names of an Excel reader feature type, just leave the "Feature Names Row" blank in the reader parameters when adding the reader to the workspace.

Reply


Community Stats

28,731
Posts
109,528
Replies
36,565
Members
Terms & ConditionsCookie 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.