Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Not applicable

Load Character

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:

tabla.jpg

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?


8 Replies
MVP
MVP

Re: Load Character

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
]

Not applicable

Re: Load Character

Doesn't work!!! sorry

MVP
MVP

Re: Load Character

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

cod_material des_material astm_material_code
100CST High Temp / CastingA 216 Gr. WCA - UNS J02502
1D2SST Martensitic / CastingA 743 Gr. CA40 (225-275HB) - UNS J91153
Not applicable

Re: Load Character

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

Not applicable

Re: Load Character

ckeck my .qvw

mov
Esteemed Contributor III

Re: Load Character

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

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
] ;

I only had to reload.

MVP
MVP

Re: Load Character

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

];

Not applicable

Re: Load Character

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!!!!


Community Browser