Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
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
swuehl
MVP
MVP

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
Author

Doesn't work!!! sorry

swuehl
MVP
MVP

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
Author

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

Not applicable
Author

ckeck my .qvw

Anonymous
Not applicable
Author

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.

swuehl
MVP
MVP

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
Author

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