Skip to main content
Question

Creating Tables from Excel

  • January 24, 2020
  • 3 replies
  • 91 views
jmhomza
Contributor
Forum|alt.badge.img+1

Hi,

I have an Excel spreadsheet that has thousands of rows that need to be grouped by a couple of columns/attributes, then each grouping written to their own respective fan-out spreadsheet. I've accomplished creating reports by using the HTMLReportGenerator, then writing each report to an emailer. So, I need to accomplish what the ReportGenerator can do - group by attributes and create tables - but I need the results written to either individual spreadsheets or as tables in individual Word documents. Any ideas on what Transformers will give me the grouped Features to write to individual files?

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.

3 replies

salvaleonrp
Enthusiast
Forum|alt.badge.img+20
  • salvaleonrpEnthusiast
  • Enthusiast
  • 152 replies
  • January 24, 2020

Use aggregator to group by the columns you want them to be grouped with. Depending on what attributes that you need to keep or do analyses you will likely use need to check the box for List, expose elements of this list in the aggregate if not use the Attribute Exposer. As for your output, use the same attribute values as your sheet names for your excel writer to create separate worksheets for each group. For more details, just follow @Mark's link on his comment.

M
Forum|alt.badge.img+2
  • markatsafe
  • 1891 replies
  • January 24, 2020

@jmhomza There is a tutorial on using FME with Excel and the article Fanout takes this s little further to show how to create separate sheets (Feature Type Fanout) or separate files (Dataset Fanout)

takashi
Celebrity
  • takashiCelebrity
  • 7843 replies
  • January 25, 2020

I guess that you have two or more tables within a single spreadsheet, and the point of the question seems to be how to separate them into individual tables. Am I right?

Why not inspect features with Visual/Data Preview and Feature/Record Information before writing them into a destination dataset?

Community Stats

32,068
Posts
121,762
Replies
39,693
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.