Question

Joining to an existing excel spreadsheet

Forum|Forum|10 years ago
October 23, 2015
3 replies
336 views

+1

aquamarine

Hi,

I have an existing excel spreadsheet that I want to update with values calculated in an FME workbench.

The existing excel spreadsheet contains a column with a unique ID that I want to join on from the data in the FME workbench.

I know how to join within a workbench using FeatureMerger or Joiner, but trying to join on a writer seems a bit more difficult. Any ideas?

Thanks,

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.

+12

pratap
Contributor
Forum|Forum|10 years ago
October 24, 2015

Hi,

I dont understand what do you mean by "Join on writer"... I think, you want to fill attributes based on the unique ID wise.

Is there any issue, if you writer in new file along with unique ID and use that file?

Upvote

A

+1

aquamarine
Author
Forum|Forum|10 years ago
October 26, 2015

Hi Pratap, thank you for your response.

Yes I worded it quite badly, what I want to do is add a value in the same row as the unique ID in the existing spreadsheet. I actually worked out that I could do this by exposing the "xlsx_row_id" in the "Format Attributes" of the reader and then in the writer "Format Parameters" I selected the "xlsx_row_id" as the "Row ID Attribute".

This then ensured that the values were populated in the appropriate rows.