Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello,
The below script runs all right when the application is reloaded with de CTRL+R on the developer IDE, but when scheduled on a trigger and reloaded automatically by the server the column 'equipe_responsavel' returns all values with null instead of the right result, anyone can help me? I've tried to reload only this table, and the result is always the same
[TESTE]:
LOAD
nmequiperesponsavel,
SUBFIELD(nmequiperesponsavel,',') AS 'equipe_responsavel';
SELECT DISTINCT
nmequiperesponsavel
FROM vw_sel_tickets_cw;
Yes, it probably is a bug. There was that exact bug on V9 SR7 -- two parm subfield returns nulls. I suspect you are using SR7 on the server and a different build on the desktop.
-Rob
try whit this:
[TESTE]:
NOCONCATENATE LOAD
nmequiperesponsavel,
SUBFIELD(nmequiperesponsavel,',') AS equipe_responsavel;
SQL SELECT DISTINCT
nmequiperesponsavel
FROM vw_sel_tickets_cw;
Hope this helps
MC
Remove the quotes for field name
[TESTE]:
LOAD
nmequiperesponsavel,
SUBFIELD(nmequiperesponsavel,',') AS equipe_responsavel;
SELECT DISTINCT
nmequiperesponsavel
FROM vw_sel_tickets_cw;
Doesn't work...
Doesn't work...
will nmequiperesponsavel field gets value when reloading from trigger
Hi
What is the value you expect? This script will return one line for each subfield token (comma separated) from each source row. It will return nulls for empty tokens (two consecutive commas).
If that's not what you require, then you need to be more specific about what you are getting and what you require, preferably by posting some sample data and a qvw model (reduce in size if its large and scramble confidential fields).
HTH
Jonathan
Try and debug by taking the script part by part
does SELECT DISTINCT filename FROM ... Work, when executed by Publisher?
yes!
I tjink you need to specify what part of your field you want.
subfield(Field,'separator',1) that menas 1st part subfield(Field, 'separator', 2) 2nd part.
What happens if some values don't bring separator cause they are just one part?
Lionel - Messi
Cristiano - Ronaldo
Pele
In the 3rd case, it wont give you anything.
Then use subfield(Field & '-', '-', 1) ------> Concat yourself the separator.
Also, place an example of your records to see how they are coming.
Salutes