Hello All,
I am trying to get rid all data (in the writer) except the first row (Pullin) and last row (Pickup) of each run (Only the Yellow Highlighted Rows). Is there any FMe transformer that can trim data? Please advise. I would appreciate the help.
Hi @gsgoraya, I think you can test these conditions with a Tester (Pass Criteria: One Test (OR)) to determine whether a row should be kept.
It's easy to test the 1st condition. Regarding the 2nd condition, you can retrieve the value of 'Drop off' in the NEXT row with the AttributeCreator using the 'Enable Adjacent Feature Attributes' option (Number of Subsequent features: 1) before testing. e.g.
You can then test whether the '_next_Drop_off' has a value, in the following Tester.
Hi @gsgoraya, I think you can test these conditions with a Tester (Pass Criteria: One Test (OR)) to determine whether a row should be kept.
It's easy to test the 1st condition. Regarding the 2nd condition, you can retrieve the value of 'Drop off' in the NEXT row with the AttributeCreator using the 'Enable Adjacent Feature Attributes' option (Number of Subsequent features: 1) before testing. e.g.
You can then test whether the '_next_Drop_off' has a value, in the following Tester.
Hello Takashi,
Thank you for answering. I tried but it does not work for me. Can you please provide detailed instructions if you don't mind. I would appreciate.
Goraya
Thank you Takashi for your help.
Gurpreet