Skip to main content
Solved

How to translate Access select query to FME?

  • April 26, 2016
  • 2 replies
  • 41 views
E

Hi all,

I'm trying to translate an Access select query to a FME script.

 

I have two Excel files in Access: one that contains data (LINC_RawData) and a comparison file (Linc_Recoding_Scheme)

Below select Access query shows records that have a value in the "Category" field and that do not have a value in the "UID" filed.

How can I translate this to FME?

 

Basically, all data should flow through to a writer except when it matches above query, I'd like it to appear in a separate output (or list / filter)

Thanks,

Ed

Best answer by david_r

Hi

The FeatureMerger can do it for you. Direct the "LINC_RawData" to the Requestor and the "Linc_Recoding_Scheme" to the Supplier. Merge on Category = UID.

If I've understood you correctly, you'll get what you need coming out of the NotMerged port, which you can then send to a suitable Writer.

David

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.

2 replies

david_r
Celebrity
  • david_rCelebrity
  • Best Answer
  • April 26, 2016

Hi

The FeatureMerger can do it for you. Direct the "LINC_RawData" to the Requestor and the "Linc_Recoding_Scheme" to the Supplier. Merge on Category = UID.

If I've understood you correctly, you'll get what you need coming out of the NotMerged port, which you can then send to a suitable Writer.

David

E
  • edttom
  • Author
  • April 29, 2016

David, thanks for your comment. The FeatureMerger did the job, thanks!

Best

 

Ed

Community Stats

32,154
Posts
122,047
Replies
39,812
Members

Latest FME

Terms & ConditionsCookie settingsAccessibility statement
A product of
Safe Software respectfully acknowledges that we live, learn and work on the traditional and unceded territories of the Kwantlen, Katzie, and Semiahmoo First Nations.