topic Re: Text function not working in load script in QlikView

Text function not working in load script

mstoler — Wed, 25 Nov 2020 16:16:04 GMT

Hello,

I have an old script which uses the Text function to convert Periods (201601, etc) to text.

The script has been running for many years. I recently started testing with a new version of SQL Server 2014 and I notice when I apply the Text function to this field I get question marks or undefined values.

Is there an issue with the Text function and new versions of SQL Server or is there a SQL Server setting I need to change?

Thank You,

Re: Text function not working in load script

Anil_Babu_Samineni — Thu, 01 Dec 2016 02:34:46 GMT

I thought so they might change from Text to Convert

CONVERT(VARCHAR(19),GETDATE())

And can we know, Earlier which expression is working for you. So that, I may try same thing in 2014 and then we can discuss to solve the same issue

Re: Text function not working in load script

marcus_sommer — Thu, 01 Dec 2016 06:52:26 GMT

Normally a question mark is a placeholder for fieldvalues which hadn't a string-representation. If you used something like: num/date(Field) or dual(Field, Field) you will see the values. If this don't work please post your script.

- Marcus