I am trying to write SQL statement in WHERE Clause FME in Navigator but it does not work.
NAME IN SELECT CONCAT(''$(',SELECT REPLACE ('Roman Ann Jack',' ',','),')'')
This sql code suppose to be NAME IN '$(NAME)' but NAME is actually list of names derived from published parameter defined as Multi Choice Value. I think I have to replace EMPTY CHARACTER between names to comma character and that should be recognizable as list for FME SQL?! I asked this question before, and got answers that this suppose to work in FME2012 or by writing python script.
But at the moment I am curious about this sql statement and if it is syntax and logic ok?! Can anyone check if whole or just part
SELECT CONCAT(''$(',SELECT REPLACE ('Roman Ann Jack',' ',','),')'')
Thank you very much