Skip to main content
Solved

Excel Reader: Selecting a single attribute to expose results in all attributes to be exposed [BUG?]


Forum|alt.badge.img

Hi all,

 

 

I'm facing a problem while adding an Excel Reader to my workspace:

 

Adding Excel Reader - I'm selecting only one attribute to be exposed:

 

When the Reader is brought into the workspace all attributes are exposed:

 

Is this a bug or am I doing something wrong?

I'm using FME(R) 2019.1.2.0 (20190829 - Build 19630 - WIN64) but I've noticed this on older versions as well.

 

Cheers,

Eduard

 

 

 

Best answer by markatsafe

@edhere This is definitely something we should clean-up. We've added the issue to our problem database.

As suggested by @danullen for now edit the schema in the feature types, not the reader parameters.

View original
Did this help you find an answer to your question?

6 replies

oscard
Influencer
Forum|alt.badge.img+21
  • Influencer
  • December 2, 2019

I have also had this problem in FME 2018


Forum|alt.badge.img
  • December 2, 2019

I get the same result as you in 2019.2. But it still works fine to edit the reader afterwards and change the list of exposed attributes. Then it sticks and gives the expected result.


Forum|alt.badge.img
  • Author
  • December 2, 2019
danullen wrote:

I get the same result as you in 2019.2. But it still works fine to edit the reader afterwards and change the list of exposed attributes. Then it sticks and gives the expected result.

That's true. But still it is annoying having to expose your attributes twice as the first time when importing the Excel Reader it doesn't work.


Forum|alt.badge.img
  • December 2, 2019
edhere wrote:

That's true. But still it is annoying having to expose your attributes twice as the first time when importing the Excel Reader it doesn't work.

Yep, agreed. (The obvious workaround is of course to not do it the first time. :-D )


Forum|alt.badge.img+2
  • Best Answer
  • December 2, 2019

@edhere This is definitely something we should clean-up. We've added the issue to our problem database.

As suggested by @danullen for now edit the schema in the feature types, not the reader parameters.


Forum|alt.badge.img
  • Author
  • December 3, 2019

Hi Mark,

 

 

Thanks for looking into this.

Best,

 

Eduard

Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings