topic Re: Issue with delimiter in QlikView

Issue with delimiter

Wed, 25 Nov 2020 16:16:04 GMT

Hi All,

Please help me out

I have a source text file which have delimiter is broken bar(¦) and I am using this as a Pipeline Delimiter in QlikView but it’s not working. Below is the sample example

POLICY NO ¦VE¦ YEAR ¦ TYPE ¦LEAD CLIENT ¦Name

.12345654 ¦01 ¦1980 ¦SPECIALTY ¦xxxxxx ¦xxxxxxx

Regards

Jhanaarthanan

Re: Issue with delimiter

stabben23 — Wed, 15 Feb 2017 12:21:47 GMT

Hi,

try With this, choose another Character set, then change Delimiter

Re: Issue with delimiter

Wed, 15 Feb 2017 12:50:05 GMT

can u pls share ur application

Re: Issue with delimiter

Wed, 15 Feb 2017 14:01:01 GMT

Thanks Manoj for your help this is a very huge data file so i used the power shell coding and broken bar(¦) symbol converted into another symbol and i have extracted the data.

Regards

Balram

Re: Issue with delimiter

Wed, 15 Feb 2017 14:32:50 GMT

Hi,

understood.

if possible can u share few records in xl ..

Re: Issue with delimiter

MarcoWedel — Wed, 15 Feb 2017 23:12:32 GMT

Hi,

if your delimiter does not work, then maybe you could try with something like:

tabInput:
LOAD RecNo() as LineNo,
    Replace(@1,'¦',Chr(9)) as Line
Inline [
POLICY NO ¦VE¦ YEAR ¦  TYPE ¦LEAD CLIENT ¦Name
.12345654  ¦01 ¦1980 ¦SPECIALTY1  ¦xxxxxx ¦xxxxxxx
.12345655  ¦02 ¦1981 ¦SPECIALTY2  ¦yyyyyy ¦yyyyyyy
.12345656  ¦03 ¦1982 ¦SPECIALTY3  ¦zzzzzz ¦zzzzzzz
] (no labels);

tabTemp1:
LOAD Line as Header Resident tabInput Where LineNo=1;

tabTemp2:
CrossTable (ColNum, ColNam)
LOAD 1,* FROM_FIELD (tabTemp1, Header) (txt, utf8, no labels, delimiter is '\t', msq);

mapHeader:
Mapping LOAD ColNum, ColNam Resident tabTemp2;

tabTemp3:
LOAD Line as Values Resident tabInput Where LineNo>1;

tabResult:
LOAD * FROM_FIELD (tabTemp3, Values) (txt, utf8, no labels, delimiter is '\t', msq);

DROP Tables tabTemp1, tabTemp2, tabTemp3, tabInput;

RENAME Fields using mapHeader;

hope this helps

regards

Marco

Re: Issue with delimiter

MarcoWedel — Tue, 21 Feb 2017 17:37:24 GMT

please close your thread if your question is answered:

Qlik Community Tip: Marking Replies as Correct or Helpful

thanks

regards

Marco