Hello,
I would like to ask if it is possible in FME to configure it to always work with the first column or row without knowing its name (to use columns or rows based on their general order). I have many Excel files where columns and rows have different names. This way, I wouldn't have to rewrite everything each time.
Thank you very much for your help.
+54Not sure if I understand exactly what you need, but if you use the Generic reader, it returns col_1, col_2 etc instead of column names.
Not sure if I understand exactly what you need, but if you use the Generic reader, it returns col_1, col_2 etc instead of column names.
Let's say you have 3 Excel files, and the first column in each of them is named: ID, ExternalID, NumberID. Is it possible to instruct FME to always work with the first column without having to rename or modify the columns in FME? Is it possible to configure FME to always work with the first column in a generic manner, regardless of the column names?
+54Let's say you have 3 Excel files, and the first column in each of them is named: ID, ExternalID, NumberID. Is it possible to instruct FME to always work with the first column without having to rename or modify the columns in FME? Is it possible to configure FME to always work with the first column in a generic manner, regardless of the column names?
Yes, with the Generic (Feature)Reader combined with an xls or xlsx, you can.
Let's say you have 3 Excel files, and the first column in each of them is named: ID, ExternalID, NumberID. Is it possible to instruct FME to always work with the first column without having to rename or modify the columns in FME? Is it possible to configure FME to always work with the first column in a generic manner, regardless of the column names?
Could you please help me with the exact setup of the Feature Reader to achieve this? I am new to FME and still have a lot to learn. Thank you very much for your help.
+54Let's say you have 3 Excel files, and the first column in each of them is named: ID, ExternalID, NumberID. Is it possible to instruct FME to always work with the first column without having to rename or modify the columns in FME? Is it possible to configure FME to always work with the first column in a generic manner, regardless of the column names?
Sure 🙂
Let's say you have 3 Excel files, and the first column in each of them is named: ID, ExternalID, NumberID. Is it possible to instruct FME to always work with the first column without having to rename or modify the columns in FME? Is it possible to configure FME to always work with the first column in a generic manner, regardless of the column names?
Thank you
+38If you're just working with excel files you can just choose to skip the headers and start from line2
Attributes are then named A,B,C etc.
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
