Question

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

  • 25 March 2022
  • 1 reply
  • 9 views
R
Badge

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
Rank
Userlevel 4

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

Reply


Community Stats

28,707
Posts
109,479
Replies
36,552
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.