Skip to main content
Question

Checking ACAD layer with Excel list

  • March 7, 2018
  • 3 replies
  • 27 views
L
Forum|alt.badge.img

Hi,

I'm new at FME so I'm asking for some help. I have autocad layers that contain a three letter code (ex: <Project>-<Beginning>-<End>-<CODE>-...) and I have an Excel sheet that contains a list of Codes.

I'd like to check if the code in the cad layer exists in the excel list. Then fill a report (excel) with a new feature called "CodeCheck" and the value would be Y or N.

I'm using an attributeSplitter to get the code but I can't find a way to check if the code is in my excel file. I must get the matched AND unmatched in my output (only the cad layers).

I tried Testers, filters, change detector,... but nothing end up like I want.

Please, how do I check the code and fill my report ?

Louis.

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

gio
Contributor
Forum|alt.badge.img+15
  • gioContributor
  • Contributor
  • March 7, 2018

@louis_c3

You can merge the excel records unconditionally and then use a tester.

Unconditional merging:

FeatureMerger 1=1, proces duplicates, set a list name. After that use listexploder on the list.

You can also use a Inline Querier to do this. SQL for this is not difficult.

gio
Contributor
Forum|alt.badge.img+15
  • gioContributor
  • Contributor
  • March 7, 2018

@louis_c3

You can merge the excel records unconditionally and then use a tester.

Unconditional merging:

FeatureMerger 1=1, proces duplicates, set a list name. After that use listexploder on the list.

You can also use a Inline Querier to do this. SQL for this is not difficult.

Another method would be to use a feature reader on the excel with a select statement.

 

 

L
Forum|alt.badge.img
  • louis_c3
  • Author
  • March 8, 2018

Thanks @gio ! FeatureMerger is the tool I was looking for ;)

Community Stats

32,182
Posts
122,179
Replies
39,856
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.