topic Re: Load PSV files in Qlik in QlikView

Load PSV files in Qlik

rupalimane1390 — Fri, 15 Nov 2024 23:45:58 GMT

Hello All,

Can we load PSV (Pipe Separated values) file in Qlik?

I could not find a way on our community.

Re: Load PSV files in Qlik

dplr-rn — Wed, 21 Oct 2020 14:44:59 GMT

load the file in script editor using table files button and select | as the delimiter (delimiter-->custome-->|).

you should get a script like below

LOAD Case,
Desc,
Assigned
FROM
[..\Downloads\CommTSF.txt]
(txt, codepage is 28591, embedded labels, delimiter is '|', msq);

Re: Load PSV files in Qlik

rupalimane1390 — Fri, 23 Oct 2020 10:54:24 GMT

Hi,

In your case, file format is txt hence qlik is able to load the file. I am having files of format .psv. When I try to load the file, it does not even fetch it from Table files option in qlikview.

You can see the file format in the attached.

Re: Load PSV files in Qlik

dplr-rn — Fri, 23 Oct 2020 11:07:56 GMT

As long as it is not a proprietary format it should work. did you try changing to 'All Files' and selecting the file in question?

Send me a sample file and i can try too

Re: Load PSV files in Qlik

rupalimane1390 — Fri, 23 Oct 2020 11:14:12 GMT

Aaah, My bad. I did not try loading PSVs with 'All files' option, I should have done that 🙂 It worked !

Thank you so much 🙂 have a great day!