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: 
rotero
Creator
Creator

field with number and alphanum source how to format it to string in edit script

hi,

i have this problem

an excel file field name PRODCD but with value of alphanum

if the value of this field contains numeric, automatically excel expect it to be numeric, so if i have other  record with alphanum it will create confusion in loading.

My question is how do i convert it during loading (in edit script) because i have a table with the same field name so that i can get full product name when i reload.

14 Replies
its_anandrjs

Hi,

No autogenerate is for example see the sample file once again.

And see the load statement and Sample atachment also.

load Text(Column) as StringCol;

Temp:

LOAD * INLINE [

    Column

    1234566

    1213sdad

    sdasd4565

    dsd445

    efdfd

    dsds458

    dfdfs885

    yytyty555

    5555

    111

    111

];

Regards,

Anand

rotero
Creator
Creator
Author

im using PE of QV ..

rotero
Creator
Creator
Author

tried this .. tnx..

rotero
Creator
Creator
Author

ok other obsrvation is when i send this to excel...

the prodcd field will be autotically set numeric to those value is all number ... how could i force to set this field to string?

SunilChauhan
Champion
Champion

load Text(trim(Column)) as StringCol;

Temp:

LOAD * INLINE [

    Column

    1234566

    1213sdad

    sdasd4565

    dsd445

    efdfd

    dsds458

    dfdfs885

    yytyty555

    5555

    111

    111

];

Sunil Chauhan