Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
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
]
Doesn't work!!! sorry
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 |
I was checking my .qvw in other machine and work it perfet but in the server doesn't work any idea!!!!!???
ckeck my .qvw
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.
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
];
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!!!!