Question

Checking ACAD layer with Excel list

L
Badge

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.

3 replies

G
Badge +3

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

G
Badge +3

@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
Badge

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

Reply


Community Stats

28,709
Posts
109,481
Replies
36,554
Members
Terms & ConditionsCookie 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.