Load Script BUG - auto convert Text to Number

[rogeriogyn]

Hello guys,

Take a look at the simple script below:

TAB1:
LOAD * Inline [
CodProd,Prod
0606110047,Prooduto 1
R606110047,Prooduto 2
0606110050,Prooduto 3
];


TAB2:
Load * inline [
CodProd,Qtde,Valor
0606110047,10,500
R606110047,20,600
0606110050,30,900
];

And The Result is:

CodProd	Prod	sum(Qtde)	sum(Valor)
		60	2000
0606110047	Prooduto 1	30	1100
0606110047	Prooduto 2	30	1100
0606110050	Prooduto 3	30	900

The text field value 'R606110047' is auto conveted to '0606110047'.

This is obviously a bug.

And yes, there's a way to fix it. Is to use Text(CodProd).

But we use a qvw to extract, another to transform, and another to show the chart. And I would have to do this in all the qvw files.

And also the field CodProd is used in almost every table.

Another anoying thing, is that we manage all the extract tables within a xls file. And in order to use text(<field>) we have to remove from the excel file and put it direct in the load script. By doing so, we lost our pattern on extract.

Is there a Release that fix this? Is this a known bug? Will it be fixed?

I'm using win7, and Qlikview Desktop 11.20 SR12 64bits

Thanks

[Peter_Cammaert]

I consider this a bug too, but there is probably a WAD-like reason to explain this weird behavior.

In the meantime, I'll try to make everyone even more depressed This

SET MoneyFormat='R$ #.##0,00;-R$ #.##0,00';

RawData:

LOAD * INLINE [

ID    Spec

1     006060417

2     R006060417

3     R$006060417

4     R$ 006060417

5     R$ 006060417,89

6     R$006060417,89

7     R006060417,89

8     006060417,89

](delimiter is '\t');

produces this as straight table output:

Money format strings definitely have a license to freewheel...

P.

[rogeriogyn]

The problem is not the '0' before, is really the money format.

I lost a lot of time with this issue.

I also still think this is a bug.

Anyway, I will change the money format, thats easier.

Thanks all for your time.