topic load from text file delimiter # in QlikView

load from text file delimiter #

qliklizzy — Wed, 25 Nov 2020 16:16:04 GMT

Could anyone help with importing a text file into QV please?

I have attached a text file I need uploading but it doesn't find the file.

I copied the logic script from another app I have which uses the | delimiter - so I just changed that to # hoping it would work but it still doesn't?

from
\\mtechdown\MTECHDOWN\Medrec\CancelledOPS_daily
(txt, codepage is 1252, embedded labels, delimiter is '|', msq)

thanks

Liz

Re: load from text file delimiter #

ChennaiahNallani — Mon, 10 Sep 2018 08:51:32 GMT

try like below.

LOAD NAME,

AGE,

TH,

DOB,

[OP DATE],

[DIFF BETWEEN OP DATE & CANCEL DATE],

[OP TYPE],

[UNIT No],

FROM

(txt, codepage is 1252, embedded labels, delimiter is '#', msq);

Re: load from text file delimiter #

tresB — Mon, 10 Sep 2018 08:54:31 GMT

The below worked with me:

FROM

(txt, codepage is 1252, embedded labels, delimiter is '#', msq);

Re: load from text file delimiter #

prieper — Mon, 10 Sep 2018 08:55:31 GMT

Hi,

think that you need to choose the separator from the dropdown-menu in the wizard.

Scripting then is OK:

Data:
    LOAD
         NAME,
         AGE,
         TH,
         DOB,
         [OP DATE],
         [DIFF BETWEEN OP DATE & CANCEL DATE],
         [OP TYPE],
         [UNIT No],
         [CANCEL DATE],
         USER,
         [CAN TYPE],
         [CAN TYPE NAME],
         [CAN OP GROUP],
         [OUTCOME TYPE],
         [PT'S CONS],
         SPEC,
         [PROPOSED OP],
         [MAN INTENT],
         [FIN YEAR],
         [ENG/WEL],
         [WAITLIST PRIORITY],
         [WAITLIST PRIORITY MAPS TO],
         [OP CANCEL GROUP],
         [REF SUBSCRIPT]
    FROM
        [test CancelledOPS_daily.TXT]
        (txt, codepage is 1252, embedded labels, delimiter is '#', msq);

HTH Peter

edit: Just replacing '#' for the '|' should work as well - Just try

LOAD * FROM ....

in order to avoid any misinterpretation in the fieldnames.

Re: load from text file delimiter #

qliklizzy — Mon, 10 Sep 2018 09:11:31 GMT

thanks ; I'm still having trouble - I thought I could just switch the | for a #

could it be because I am getting the file from cross server?

it works in my other app though I just changed the filename - so I'm stumped..

thanks

Re: load from text file delimiter #

prieper — Mon, 10 Sep 2018 09:16:42 GMT

What errormessage do you get?

try to load without embedded labels, e.g. 'no labels', just to check, whether it works and that the error is no related to the fieldnames.

Peter

Re: load from text file delimiter #

YoussefBelloum — Mon, 10 Sep 2018 09:19:41 GMT

Was trying it and just replacing the | with # on the code is not enough..

it looks like you can only create the field delimiter using the graphical part, as explained previously.

as for the symbol on the code, it acts on the lines (not the field name)

Re: load from text file delimiter #

qliklizzy — Mon, 10 Sep 2018 09:21:35 GMT

oh my gosh - it was the field name!

thanks

I had PT's CONS not PT'S CONS

grrrr

sorry I should have spotted that!

thanks for all your help