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
+2
@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.
Userlevel 5
+25
- Influencer
- 3345 replies
-
22 December 2022
@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
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.