Skip to main content
  • EN

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

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!

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.

 

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?
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.

 

 

 

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.

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.

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.

 

 

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
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!

 

 

Reply


Community Stats

30,099
Posts
114,259
Replies
37,731
Members
Terms & ConditionsCookie settings
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.