Skip to main content
Solved

Acess to Excel Sheets named by Attribute

  • October 18, 2017
  • 9 replies
  • 49 views
S
Forum|alt.badge.img

Hello everyone,

I am a bit frustrated and have done this in the past (April of this year actually) and for the life of me cannot get same results.

I have an access database with a large table that has multiple columns and one of the columns is "Town" and I need to export Excel sheets by town carrying all the data for that specific town (from all the other columns).

Ive tried Fanout and Ive tried in writer to ask it to create via town field. Nothing is working. Its frustrating.

I know the answer is simple and I thank you in advance to who ever can jog my memory.

Also dont get me started on co-worker whom deleted workbench!

Thanks!

Savas

Best answer by andreaatsafe

Hi @sav426

In the Excel feature type writer, you can set the Sheet Name to be the "Town" attribute. This should result in one Excel file with sheets named for each Town.

Hope this helps!

This post is closed to further activity.
It may be an old question, an answered question, an implemented idea, or a notification-only post.
Please check post dates before relying on any information in a question or answer.
For follow-up or related questions, please post a new question or idea.
If there is a genuine update to be made, please contact us and request that the post is reopened.

9 replies

andreaatsafe
Safer
Forum|alt.badge.img+15
  • andreaatsafeSafer
  • Safer
  • Best Answer
  • October 18, 2017

Hi @sav426

In the Excel feature type writer, you can set the Sheet Name to be the "Town" attribute. This should result in one Excel file with sheets named for each Town.

Hope this helps!

S
Forum|alt.badge.img
  • sav426
  • Author
  • October 18, 2017

Hi @sav426

In the Excel feature type writer, you can set the Sheet Name to be the "Town" attribute. This should result in one Excel file with sheets named for each Town.

Hope this helps!

 

Andrea I did that. Its such a puzzle I have no idea why its not working. I actually feel embarrassed for asking such a "simple" question.
andreaatsafe
Safer
Forum|alt.badge.img+15

 

Andrea I did that. Its such a puzzle I have no idea why its not working. I actually feel embarrassed for asking such a "simple" question.
What version/build of FME are you using?
S
Forum|alt.badge.img
  • sav426
  • Author
  • October 18, 2017
What version/build of FME are you using?
here is the info:

 

 

Edition: FME Desktop Smallworld Edition (floating)

 

Version: FME(R) 2016.1.0.1 (20160516 - Build 16494 - WIN32)

 

 

Im very surprised this isnt working. I consider myself fairly advanced FME user and for some reason this isnt working.

 

 

Its simple from an Access DB with a table within and lots records by town. So I need a spreadsheet to come out Named Town with all the records for that particular town in same format as database.

 

 

I tried it in the writer based on attribute AND I also tried the fanout option. Neither worked.

 

 

It strange and bothers me what I am doing wrong.

 

 

 

andreaatsafe
Safer
Forum|alt.badge.img+15
here is the info:

 

 

Edition: FME Desktop Smallworld Edition (floating)

 

Version: FME(R) 2016.1.0.1 (20160516 - Build 16494 - WIN32)

 

 

Im very surprised this isnt working. I consider myself fairly advanced FME user and for some reason this isnt working.

 

 

Its simple from an Access DB with a table within and lots records by town. So I need a spreadsheet to come out Named Town with all the records for that particular town in same format as database.

 

 

I tried it in the writer based on attribute AND I also tried the fanout option. Neither worked.

 

 

It strange and bothers me what I am doing wrong.

 

 

 

Yes, that is strange. Here's a screen shot of where it should be set, just to be sure.

Would you mind submitting a case and attaching your workspace? https://www.safe.com/support/report-a-problem/

 

And we can take a look into a bit more.
erik_jan
Contributor
Forum|alt.badge.img+23
  • erik_janContributor
  • Contributor
  • October 18, 2017

Did you look at the output, right before the writer, using an Inspector transformer?

It will show if the "Town" attribute actually has the values you expect it to have.

S
Forum|alt.badge.img
  • sav426
  • Author
  • October 18, 2017
Yes, that is strange. Here's a screen shot of where it should be set, just to be sure.

Would you mind submitting a case and attaching your workspace? https://www.safe.com/support/report-a-problem/

 

And we can take a look into a bit more.
I will absolutely send in my Workbench tomorrow. Thank so much.

 

 

S
Forum|alt.badge.img
  • sav426
  • Author
  • October 19, 2017
I will absolutely send in my Workbench tomorrow. Thank so much.

 

 

Andrea,

 

 

I recreated the workbench and its working fine now. Go figure. Must of been some bug or something. Thanks for everything
andreaatsafe
Safer
Forum|alt.badge.img+15
Andrea,

 

 

I recreated the workbench and its working fine now. Go figure. Must of been some bug or something. Thanks for everything
Glad to hear it is working now!

 

 

Community Stats

32,154
Posts
122,048
Replies
39,812
Members

Latest FME

Terms & ConditionsCookie settingsAccessibility statement
A product of
Safe Software respectfully acknowledges that we live, learn and work on the traditional and unceded territories of the Kwantlen, Katzie, and Semiahmoo First Nations.