Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi
I have the following script (simplified)
Any ideas?
Regards
Paolo
As troubleshooting respectively as parts of a solution or a workaround you may try to cast this field within the sql to a certain/common type of string or to combine the field in a way like:
chr(1) & '|' & MyField as MyField
to get a definite output for the Qlik-side in which these extras are removed + converted/formatted as wanted.
As troubleshooting respectively as parts of a solution or a workaround you may try to cast this field within the sql to a certain/common type of string or to combine the field in a way like:
chr(1) & '|' & MyField as MyField
to get a definite output for the Qlik-side in which these extras are removed + converted/formatted as wanted.
Yes, this is what I did and it works. But it is weird anyway.
This means the Qlik-side worked as expected and the inconsistence comes from the data-base and/or the driver respectively their combination. Maybe the driver is not suitable (wrong one or not the right release) and/or any configuration isn't set properly. Maybe the FAQ and/or the community from the data-base/driver could deliver any hints.