Skip to main content
  • EN

Hello everyone,

My colleague is trying to read a zip file in FME Form that contains 3 .xlsx files. My colleague read in this these three files and exploded the data, so it looks like image 1 and we were wondering how we would be able to transpose it to image 2. A criteria is that A1, B1,C1 should be in the same row  as shown as in image2. I was thinking of using the xlsx_row_id variable and maybe the name of excel file as attributes for sorting that out later. However, to go from image 1 to image 2  beforehand is unfortunately still  a bit of a mystery to us. I looked up into the attributetransposer, but that didn't yield the result I wanted.

 

image 1
image 2

You can use an AttributeCreator with the name being the value of attr_name and the value being attr_value.

You will then need to use an Aggregator with a group-by of xslx_row_id (and perhaps fme_basename). In the AttributeExploter you can choose to keep the orignal attributes which is important for the row and basename. 

At the end the attributes will not be exposed so you will either need to use an AttributeExposer or if dynamic you’ll need to use the SchemaScanner before the writer

 

Reply


Community Stats

31,773
Posts
120,715
Replies
39,396
Members

Latest FME

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.