topic Alfanumerical field in QlikView

Alfanumerical field

Mon, 07 Dec 2009 22:36:01 GMT

On loading from SQL db an alfanumerical filed with an structure like:

ArticleCode Revenue

35 10

035 12

0035 56

Is taking all as 0035

0035 78

There are three diferent articles,

What am I doing wrong?.

Thanks

Alfanumerical field

prieper — Mon, 07 Dec 2009 22:45:10 GMT

Load it with the funtion

TEXT(ArticleCode) AS ArticleCode

Peter

Alfanumerical field

Mon, 07 Dec 2009 22:53:05 GMT

To complete the above answer:

TEXT is a QV function, it will not work in your SQL statement.

So your script should be adapted to something like this:

Articles:

Load text(ArticleCode) as ArticleCode_temp ; SQL SELECT ArticleCode, FROM <ODBC_NAME>;

I've experienced that when using the TEXT function, the resulting field name cannot be the same as the fieldname you are converting to text, therefore the "_temp" I added. I've had the exact same problem (also with article codes), and this solved the problem. (With a resident load, or when working with QVD files, you can rename the field again in a second load.)

Succes,

Yves

Alfanumerical field

Wed, 09 Dec 2009 19:59:05 GMT

SQL SELECT Abreviatura as Descripcion,

Activo,

Articulo,

Subfamilia,

Familia

FROM "mpFCE001_QlikView".dbo.MpArt;

Lost in your indications

After including your

Load

text(Articulo) as Article;

SQL SELECT Articulo

FROM "mpFCE001_QlikView".dbo.MpArt;

I got the Articulo and Article (alfanunerical as I was aiming)

But in diferent tables

I was aiming for:

SQL SELECT Abreviatura as Descripcion,

Activo,

text(Articulo) as Article Subfamilia,

Familia

FROM "mpFCE001_QlikView".dbo.MpArt;

But this would not work, how can I get arround

Alfanumerical field

Wed, 09 Dec 2009 20:39:09 GMT

Correct would be:

New_QV_table_Name:

LOAD

Abreviatura as Descripcion,

Activo,

text(Articulo) as Article Subfamilia,

Familia;

SQL SELECT

Abreviatura,

Activo,

text(Articulo) as Article Subfamilia,

Familia

FROM "mpFCE001_QlikView".dbo.MpArt;

Alfanumerical field

Sat, 12 Dec 2009 01:40:37 GMT

Thanks for your help

Sadly I still not got succes,

With your last indications I got a SQL error text not a sql

thank again

Alfanumerical field

prieper — Sat, 12 Dec 2009 03:40:36 GMT

Should work with


New_QV_table_Name:
LOAD
Abreviatura as Descripcion,
Activo,
text(Articulo) as Article Subfamilia,
Familia;
SQL SELECT
Abreviatura,
Activo,
Articulo,
Familia
FROM "mpFCE001_QlikView".dbo.MpArt;

Peter

Alfanumerical field

Sat, 12 Dec 2009 07:37:38 GMT

Finaly I've got it rigth.

Thanks you all