Skip to main content
  • EN

I have an excel document with row 2 has merged cells for data category and row 3 has headers for attributes, row 4 onwards has data.

 

how can I pull row as the data category? tried, columnstorow, and datapivot none seems to work as I expect

@acadien​ In the FME Excel reader parameters, you can set the header row, but the data rows can be before that. i.e. Header row 3 : Data Row 1. You can then use a test to separate the first two rows and then join those to all records. FME should split the merged cells. If you have an example of the data someone might dig a bit deeper.

@acadien​ In the FME Excel reader parameters, you can set the header row, but the data rows can be before that. i.e. Header row 3 : Data Row 1. You can then use a test to separate the first two rows and then join those to all records. FME should split the merged cells. If you have an example of the data someone might dig a bit deeper.

I agree with @Mark Stoakes​, it would be very useful to see a sample of your data.

Reply


Community Stats

30,126
Posts
114,374
Replies
37,765
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.