Hi,
I am trying to query a SQL-database with the universal connector and compare two fields of the same table. But I cannot get it to work.
A simple sample table:
Counter|IndexText |Subject
--------------------------------------------------------------------
500 |blablabla XXX00222222 bla bla blablabla|Document_XXX33333333
501 |blablabla XXX11111111 bla bla blablabla|Document_XXX11111111
=@NL("Rows";"Table";"Counter";"IndexText";"=CONCATENATE(""<>*"";SUBSTITUE(NF(;""Subject"");""Document_"";"""");""*"")")
The result should be 500. All rows, that do not have the XXX-number in the IndexText. I checked the quotation marks over and over again but cannot find a mistake.
Does anyone have any suggestions?