Question

Excel: Grouping Features by Attribute

  • 25 January 2019
  • 1 reply
  • 8 views
M

I have an excel file containing 100,000 items placed in 700 boxes. The file has two columns, one column is the item and the other is the corresponding box. I would like to get them rearranged as a file with 700 columns and each column (box) has all it's corresponding items listed underneath. Attached is an example:

 

Excel's Pivot table and FME's AttributePivoter are asking me to group the items by columns AND rows. But I don't have rows to group the items with. I just wanna group the items by columns.

 

1 reply

ebygomm
Rank
Userlevel 1
Badge +10

The main challenge is going to be to get the attribute names if there are 700, is your final destination an excel file?

This sort of process will work for your sample data, but would require knowing the 700 names of the attributes you want to expose

 

fruits.fmwt

Reply


Community Stats

28,665
Posts
109,338
Replies
36,533
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.