Skip to main content

Hello,

We have an excel file with different first lines.
For this reason, we have defined the featurereader in the excel file, which allows us to have the column names in A, B, C ... and not the column name with the values of the first line.

This works very well, but as soon as we put a parameter in the dataset (instead of a hard-coded directory path), we lose the A, B, C field names and can't use them generically.

do you think there's a solution for keeping column names in A, B, C?

Best regards

When I need this, I use the “Generic (Any Format)” reader. This will not return A,B,C but col_1,col_2,col_3. Sample attached.

 


Thanks Niels, I can't download your attachment, as soon as I can I'll have a look with pleasure.


 


Hi Niels, 

it works well !

I searched for a while to find the format “generic(any format)”. I've never used it before :)

I get the col_1 col_2 etc columns and I can filter on xlsx_row_id to take into account only the data and not the header.
the only problem I have is that I have two tabs in my excel files and I only want to retrieve data from one tab and I haven't found a way to retrieve the tab name and filter it …

I can't get the tab name by doing an attribute_expose


Sorry, I found the name of the tab with the fme_feature_type !
so all's well!

 

Thank you again Niels !


Hi Niels, 

it works well !

I searched for a while to find the format “generic(any format)”. I've never used it before :)

I get the col_1 col_2 etc columns and I can filter on xlsx_row_id to take into account only the data and not the header.
the only problem I have is that I have two tabs in my excel files and I only want to retrieve data from one tab and I haven't found a way to retrieve the tab name and filter it …

I can't get the tab name by doing an attribute_expose

Ah yes, unexposed attributes. I always open my results in a different window (Data Inspector) where the feature information panel is always visible. You can try this by closing the visual preview and change something in the settings. I believe the visual preview window is limiting most users because of this.

  

Sorry, I found the name of the tab with the fme_feature_type !
so all's well!

 

Thank you again Niels !

Happy I could help :)


Thanks Niels, I can't download your attachment, as soon as I can I'll have a look with pleasure.

@danielleatsafe for this post also, something seems off with the attachment. Personally I think the attachments with working samples are the key to get new users up and running. To have something which just works and can be changed to your needs.


thanks for the tip on unexposed attributes


Thanks Niels, I can't download your attachment, as soon as I can I'll have a look with pleasure.

@danielleatsafe for this post also, something seems off with the attachment. Personally I think the attachments with working samples are the key to get new users up and running. To have something which just works and can be changed to your needs.

The attachments issue should be fixed now!


 

@danielleatsafe for this post also, something seems off with the attachment. Personally I think the attachments with working samples are the key to get new users up and running. To have something which just works and can be changed to your needs.

The attachments issue should be fixed now!

Great, thanks, works for me :)


Reply