Skip to main content
Solved

How to translate Access select query to FME?

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

View original
Did this help you find an answer to your question?

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

Reply


Helpful Members This Week

Community Stats

31,182
Posts
118,185
Replies
38,791
Members

Latest FME

Terms & ConditionsCookie settings

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
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.