Skip to main content
Question

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


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

3 replies

stalknecht
Contributor
Forum|alt.badge.img+19
  • Contributor
  • July 18, 2019

xlsxr2none.fmwt

Here is an example in FME 2019 using an inlineQuerier.

Good luck!


  • Author
  • July 22, 2019

Thanks for the response, i wil try the inlineQuerier.


  • Author
  • 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


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