topic Re: Load delimiter file into Qlikview in QlikView

Load delimiter file into Qlikview

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

Please help me by loading the attached sample file into qlikview.

Delimiter is Ð|Ð

Re: Load delimiter file into Qlikview

ychaitanya — Tue, 20 Mar 2018 18:52:23 GMT

Can you try replacing the Ð|Ð sequence with ',' and use comma delimited file load, as the above substring is difficult for Qlik to read .

Thanks

Re: Load delimiter file into Qlikview

shilpan — Tue, 20 Mar 2018 19:29:11 GMT

See the script attached

Re: Load delimiter file into Qlikview

MarcoWedel — Wed, 21 Mar 2018 00:07:10 GMT

maybe like this?

LOAD TextBetween(@1,'Ð','Ð') as ROW_ID,
    TextBetween(@2,'Ð','Ð') as CREATED,
    TextBetween(@3,'Ð','Ð') as CREATED_BY
FROM  (txt, codepage is 1252, no labels, delimiter is '|', msq, filters(Remove(Row, Pos(Top, 1))));

hope this helps

regards

Marco