Question

Read two workbooks, identify common worksheets and then update from one sheet to another

  • 29 March 2024
  • 1 reply
  • 13 views

Badge

Hi,

I am very new to FME and thought this would be a good exercise to get my feet wet.

However, I am having trouble locating help based on workbooks updates.

I have two workbooks named A and B for the example.

They both common worksheet names. 

I want to read both workbooks, identify the common worksheet and update from a specific location from worksheet A to a specific location in worksheet B.

Cheers 

Steve 

 


1 reply

Userlevel 1
Badge +6

Hi, @stevegrahambart, welcome!

Just wanted to clarify some things from your question.

For your worksheets, your trying to append/join data? If so, check out this article on joining/appending; has an example there too.

If not, are you trying to update the drive location of workbook A to the other drive location of workbook B after appending/joining (as above in the first question)? If so, you can click on the writer feature type itself and select the icon (image below).

Thanks!

Reply