I have an Excel file which has the header on the 3rd row. The first and second rows have additional information. My actual data values start from row 4.
Is there any way in FME to remove the first two rows and use the 3rd row for attribute names?
I have attached my example file.
Thanks in advance.
Best answer by andreaatsafe
Hi @ghma1011,
You can set this when you are adding the Excel Reader. In the parameters settings, you can specify the Field Name Rows and the Cell Range for the data you are wanting to read:
Hope this helps!
- Andrea
+15Hi @ghma1011,
You can set this when you are adding the Excel Reader. In the parameters settings, you can specify the Field Name Rows and the Cell Range for the data you are wanting to read:
Hope this helps!
- Andrea
Hi @ghma1011,
You can set this when you are adding the Excel Reader. In the parameters settings, you can specify the Field Name Rows and the Cell Range for the data you are wanting to read:
Hope this helps!
- Andrea
For some reason, I am doing this, but it is still pulling from the first row?
+15For some reason, I am doing this, but it is still pulling from the first row?
Hi @morijlumos,
It appears that you may have changed the source file than what was originally used to create the Excel Reader Feature Type.
I would suggest adding a new Excel Reader, specify the field names etc for how you have it and then ensure you specify the "Multiple File Parameters" to "Use Current Settings". So that if you change the source file, you will be able to read the file provided it has the same schema.
Hope that helps!
- Andrea
