Skip to main content
  • EN
So I have a multi table joiner that I have been succesful with inside of Toad but I cannot get to excute inside of a SQLite transformer in FME.

 

 

I am essentially wanting to join the Region table to the Entry table if the column Entry.Category contains Region.Region_Name.

 

 

The code I am using is as follows:

 

 

select Entry.Category, REGION.REGION_NAME from Entry join REGION on Entry.Category like ('%' + REGION.REGION_NAME + '%')

 

 

Any help would be very appreciated!

Hi,

Although the SQL syntax is basically standardized, there also are partial differences depending on database engine. In the InlineQuerier, you have to follow SQLite specification, since the transformer uses SQLite database internally.

 

Try using || operator to concatenate string, instead of +.

 

-----

 

select Entry.Category, REGION.REGION_NAME

 

from Entry inner join REGION on Entry.Category like ('%' || REGION.REGION_NAME || '%')

 

-----

 

 

Takashi
Takashi you are the man!!!

 

 

I totally forgot about that as a possibility!!

 

 

Works like a champ now.

 

 

 

-Garrett

Reply


Community Stats

30,108
Posts
114,295
Replies
37,744
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.