topic Re: Load Character in QlikView

Load Character

Fri, 07 Feb 2014 18:01:21 GMT

Hi Everyone;

I am try to load the next data;

Material:

LOAD * INLINE [
cod_material, des_material, astm_material_code
100 , CST High Temp / Casting , A 216 Gr. WCA - UNS J02502
1D2, SST Martensitic / Casting , A 743 Gr. CA40 (225-275HB) - UNS J91153
]

This is the result:

WHY? the problem is in the column cod_material that doesn't load the '1D2' and read like 100

can you help please!!!!

How I can resolve this? any Idea?

Re: Load Character

swuehl — Fri, 07 Feb 2014 18:03:50 GMT

Use

Material:

LOAD text(cod_material) as cod_material, des_material, astm_material_code INLINE [
cod_material, des_material, astm_material_code
100 , CST High Temp / Casting , A 216 Gr. WCA - UNS J02502
1D2, SST Martensitic / Casting , A 743 Gr. CA40 (225-275HB) - UNS J91153
]

Re: Load Character

Fri, 07 Feb 2014 18:07:59 GMT

Doesn't work!!! sorry

Re: Load Character

swuehl — Fri, 07 Feb 2014 18:20:55 GMT

Seems to work for me. Which version are you using?

cod_material	des_material	astm_material_code
100	CST High Temp / Casting	A 216 Gr. WCA - UNS J02502
1D2	SST Martensitic / Casting	A 743 Gr. CA40 (225-275HB) - UNS J91153

Re: Load Character

Fri, 07 Feb 2014 18:32:54 GMT

I was checking my .qvw in other machine and work it perfet but in the server doesn't work any idea!!!!!???

Re: Load Character

Fri, 07 Feb 2014 18:33:50 GMT

ckeck my .qvw

Re: Load Character

Anonymous — Fri, 07 Feb 2014 19:36:49 GMT

It works for me as is, even without text() function:

I only had to reload.

Re: Load Character

swuehl — Fri, 07 Feb 2014 20:06:07 GMT

Are you using 11.2 SR5 on the other machine?

Then try maybe

Set ExponentNumberNotation = 0;

MATERIAL:

LOAD * INLINE [

cod_material, des_material, astm_material_code

100 , CST High Temp / Casting , A 216 Gr. WCA - UNS J02502

1D2, SST Martensitic / Casting , A 743 Gr. CA40 (225-275HB) - UNS J91153

];

Re: Load Character

Fri, 07 Feb 2014 23:30:57 GMT

Hi Everyone;

I resolve the problem the next way:

I put in the load from SQL:

TEST:

Load

'_'++cod_material,

des_material,

astm_material_code

from materiales;

the input or OUT or Result:

_100 , CST High Temp / Casting , A 216 Gr. WCA - UNS J02502

_1D2, SST Martensitic / Casting , A 743 Gr. CA40 (225-275HB) - UNS J91153

is a bad practicing really but is not possible the moment to change a new version,

Thanks for all !!! Regars!!!!