Question

How could I execute a SQL "select distinct" command on an ESRI FGDB Table?

3 years ago
March 25, 2022
1 reply
32 views

robertdbuckley
41 replies

I have tried using the unique value transformer but it only accepts a single column. The SQL Executor doesn´t read FDGB. So how could I do an SQL distinct on two columns?

david_r
8354 replies
3 years ago
March 25, 2022

You can always use the DuplicateRemover, it'll have the same effect except that FME will have to read the entire table first.

Reply

Rich Text Editor, editor1

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

We use 3 different kinds of cookies. You can choose which cookies you want to accept. We need basic cookies to make this site work, therefore these are the minimum you can select. Learn more about our cookies.

Basic
Functional

Normal
Functional + analytics

Complete
Functional + analytics + social media + embedded videos + marketing

How could I execute a SQL "select distinct" command on an ESRI FGDB Table?