topic Re: Problem with a numerical field in SQL in QlikView

Problem with a numerical field in SQL

Anonymous — Thu, 10 Nov 2016 18:40:08 GMT

In the DB, the field has values "999" or "00999".

For example:

Field_A	$
999	10
00999	5
999	5

I make a query to the SQL DB:

TABLE_001:

SQL SELECT

Field_A,

FROM DB."TABLE_001";

Result:

Field_A	$
999	10

But if I add a "Where" in a query.

TABLE_001:

SQL SELECT

Field_A,

FROM DB."TABLE_001"

Where Field_A = '00999';

Result:

Field_A	$
00999	5

I need to make the query and get the values 999 and 00999

Field_A	$
999	10
00999	5
999	5

Thanks!

Re: Problem with a numerical field in SQL

jpenuliar — Thu, 10 Nov 2016 18:59:31 GMT

Try a SQL IN Operator:

Field_A IN('999','00999')

Regards,

Re: Problem with a numerical field in SQL

Anonymous — Fri, 11 Nov 2016 12:22:51 GMT

Holla Jonathan.

The problem is that the field "Field_A" has not only those values (999 and 00999), it has many others.

But with these two I have the incident that you publish.

Re: Problem with a numerical field in SQL

jpenuliar — Fri, 11 Nov 2016 14:22:56 GMT

I amnot sure what you exactly want to achieve, but if you want to load all values matching '999' and '00999' from your SQL result, you can do a "Resident Load" :

Load Field_A resident tab1 where Match(Field_A,'999','00999');

Re: Problem with a numerical field in SQL

Anonymous — Fri, 11 Nov 2016 14:34:03 GMT

No, I need load all values.

Filed_A
CHA20104
COMCRDB
ESC30601
MOE60703
TIG30501
VLO30103
999
0999
16100

Those are the values of the field (In a DB). But when I load in QV the value 00999 is joined with the value 999.

Filed_A
CHA20104
COMCRDB
ESC30601
MOE60703
TIG30501
VLO30103
999
16100

It is understood?

Re: Problem with a numerical field in SQL

marcus_sommer — Fri, 11 Nov 2016 14:59:41 GMT

Try it with:

TABLE_001:

Load *, text(Field_A) as Field_A_New;

SQL SELECT

Field_A,

FROM DB."TABLE_001";

- Marcus

Re: Problem with a numerical field in SQL

Anonymous — Fri, 11 Nov 2016 15:06:16 GMT

WHERE (CAST Field_A AS INT) = '999'

Re: Problem with a numerical field in SQL

Anonymous — Fri, 11 Nov 2016 15:36:31 GMT

This is what I need. Thank @Marcus!!!