Skip to main content
Question

excel sheet - copy a row based on a value to another sheet

  • July 15, 2019
  • 3 replies
  • 48 views

kevinkies
Contributor
Forum|alt.badge.img+3

hello,

i have a excel document that i want to change with fme.

What i want is that colum A, B, C, D and E are copieed to another file if there is a value in a certain date (of colum F........till...AC)

 

 

Here is the result that a want: U will see that a want that a row will be copieed if there are more values of a diffrent month, see row 20 and 21.

 

 

i hope that u understand it, the document of excel is attached

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

stalknecht
Contributor
Forum|alt.badge.img+21
  • Contributor
  • 305 replies
  • July 18, 2019

xlsxr2none.fmwt

Here is an example in FME 2019 using an inlineQuerier.

Good luck!


kevinkies
Contributor
Forum|alt.badge.img+3
  • Author
  • Contributor
  • 15 replies
  • July 22, 2019

Thanks for the response, i wil try the inlineQuerier.


kevinkies
Contributor
Forum|alt.badge.img+3
  • Author
  • Contributor
  • 15 replies
  • July 24, 2019

it worked perfect thanks!

 

i also add a cloner to split a row on a value (higher then 1), so u get multiple rows of the value is bigger then 1