Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello All,
Can we load PSV (Pipe Separated values) file in Qlik?
I could not find a way on our community.
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);
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
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);
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.
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
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!