Discussion Board for collaboration related to QlikView App Development.
Good Morning Everyone, I have a file that is delimited by the character '‹', but in the options of separators, it doesn't exist. It shows me the character '<', it isn't the same.
Is there a form to forced it?
Thanks.
Load the file fields as one field and use SubField to separate the fields.
Load the file fields as one field and use SubField to separate the fields.
Create the load statement with the file wizard. Then manually replace the delimiter in the generated script.
delimiter is '‹'
Have you tried specifying the special character as delimiter:
LOAD @1
FROM
SampleForQlikview.txt
(txt, codepage is 1252, no labels, delimiter is '‹', msq);
You probably need to adapt the codepage, too.
Thanks.. It works..... Have a Nice Day...