Discussion board where members can get started with QlikView.
I have got mixed delimeter file with tab delimeter and comma seperated fields in one file, how to load all fileds seperatly?
Pleaae find attached files.
Go to Solution.
LOAD SubField([sn lon], Chr(9), 1) as sn,
SubField([sn lon], Chr(9), 2) as lon,
(txt, codepage is 1252, embedded labels, delimiter is ',', msq);
View solution in original post