Load PSV files in Qlik

[rupalimane1390]

Hello All,

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

I could not find a way on our community.

[dplr-rn · Accepted solution]

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);

[rupalimane1390]

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.

[dplr-rn · Accepted solution]

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

[rupalimane1390]

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!