topic Load InLine, Numbers like text in QlikView

Load InLine, Numbers like text

MarcoARaymundo — Tue, 02 Apr 2013 12:37:55 GMT

Hi!

I need load fields(ACC_COOR and ACC_VEND) like text.

LOAD * INLINE [

ACCESS, USERID, PASSWORD, ACC_COOR, ACC_VEND

ADMIN, admin, , *, *

USER, user1, , 000048, 000047

];

Any ideia?

Re: Load InLine, Numbers like text

alexandros17 — Tue, 02 Apr 2013 12:40:40 GMT

Use the function text(nnnn)

Re: Load InLine, Numbers like text

kaushiknsolanki — Tue, 02 Apr 2013 12:43:15 GMT

Hi,

Try

LOAD ACCESS,USERID,PASSWORD,Text(ACC_COOR) as ACC_COOR,Text(ACC_VEND) as ACC_VEND INLINE [

ACCESS, USERID, PASSWORD, ACC_COOR, ACC_VEND

ADMIN, admin, , *, *

USER, user1, , 000048, 000047

];

Regards,

Kaushik Solanki