Skip to main content
Question

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

  • March 29, 2024
  • 1 reply
  • 17 views

stevegrahambart
Observer
Forum|alt.badge.img

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 

 

AliAtSafe
Safer
Forum|alt.badge.img+18

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


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings