Skip to main content
Question

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

  • March 25, 2022
  • 1 reply
  • 82 views
R
Forum|alt.badge.img

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?

1 reply

david_r
Celebrity
  • david_rCelebrity
  • 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.

Community Stats

32,762
Posts
124,237
Replies
41,286
Members
Terms & ConditionsAccessibility 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.