Skip to main content
  • EN

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.

 

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

30,108
Posts
114,295
Replies
37,744
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.