Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have a field that is a text field in my SQL table. I went to great lengths to ensure this field gets assigned as text in the database. When I add it to my Qlikview report, some of the values are still showing as scientific notation. I load many other fields into the report and I just do a SELECT * FROM TableName. How can I LOAD the field as TEXT in the script and just call out the field(s) I want to make as text?
My bad, try this
TempTable:
LOAD Num(0) as GLAcct
AutoGenerate 0;
SELECT * FROM dbo.GRIR_Main;
DROP Table TempTable;
May be load like this:
LOAD Num(GLAcct) as GLAcct;
SELECT GLAcct FROM dbo.GRIR_Main;
How do I load all the rest of the fields without specifically listing them all out?
Or do you want to keep it as text?
LOAD Text(GLAcct) as GLAcct;
SELECT GLAcct FROM dbo.GRIR_Main;
May be like this
LOAD *,
Num(GLAcct) as GLAcct1;
SELECT GLAcct FROM dbo.GRIR_Main;
DROP Field GLAcct;
RENAME Field GLAcct1 as GLAcct;
Have not tried this, but you can give this a try
TempTable:
LOAD Num(0) as GLAcct
AutoGenerate 0;
SELECT GLAcct FROM dbo.GRIR_Main;
DROP Table TempTable;
I do want to keep it as text. When I use Num(), I lose some of the data. When I use Text(), I still see scientific notation.
That does not work as I do not get any fields to display.
No fields show up? Not even GLAcct
My bad, try this
TempTable:
LOAD Num(0) as GLAcct
AutoGenerate 0;
SELECT * FROM dbo.GRIR_Main;
DROP Table TempTable;