I want to execute the following SQL code in an Input Data Tool.
select substr(
members,
instr(';'||members,';',1,seq),
instr(';'||members||';',';',1,seq+1) - instr(';'||members,';',1,seq)-1) members
from "CData"."ActiveDirectory"."Group",(select level seq from dual connect by level <= 100) seqgen
where instr(';'||members,';',1,seq) > 0
But when I paste it into the SQL Editor I get this error:
Error: Input Data (1): Error SQLPrepare: Malformed SQL Statement: Expected token ')' but found 7 with value '||' instead at position 76.
Statement:select substr(
members,
instr(';'||members,';',1,seq),
instr(';'||members||';',';',1,seq+1) - instr(';'||members,';',1,seq)-1) members
from "CData"."ActiveDirectory"."Group",(select level seq from dual connect by level <= 100) seqgen
where instr(';'||members,';',1,seq) > 0
Is this an Alteryx limitation or syntax problem or because of the ODBC driver I am using?
When I simplify it to just a simply substr() function I also get an error. Is there a list of supported functions?
