topic Re: delimiter is '|' in QlikView

delimiter is '|'

deepakqlikview_123 — Fri, 13 Mar 2015 05:05:32 GMT

Hello All,

Please find attachment.

My delimiter is '|' can you please suggest what to select in custom settings so that I will get each column separately in QVW file.

In file.Please share procedure

Thanks,

Anonymous — Fri, 13 Mar 2015 05:15:14 GMT

When you load the file, choose delimiter as custom. You will get a list of delimeters. Select '|' from this list. See attached.

PrashantSangle — Fri, 13 Mar 2015 05:15:59 GMT

Hi,

Use below code

LOAD @1,
@2,
@3,
@4,
@5,
@6,
@7,
@8,
@9,
@10,
@11,
@12,
@13,
@14
FROM test.txt
(txt, codepage is 1252, no labels, delimiter is '|', msq);

Regards

senpradip007 — Fri, 13 Mar 2015 05:17:33 GMT

PFA. Hope it will help.

amit_saini — Fri, 13 Mar 2015 05:21:04 GMT

Deepak,

Follow:

Thanks,
AS