Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
in the file I receive that I want to upload to Qlikview , Æ is used as delimiter. how can I make the file readable to qlikview? thanks
Hi,
you can try like this?
LOAD SubField(ColumnName, 'Æ') AS FieldName RESIDENT TableName;
Hi Devarasu, currently Æ is not yet in any column and it is a supposed separator in a line of text.
Hi,
Would be able to share some mock data and expected results. Thanks
Maybe you can try with the statement like the below
LOAD @1
FROM
[File]
(txt, unicode, no labels, delimiter is 'Æ', msq);
I don't think Æ is a special character and can be used as a delimiter.
May be you can replace all Æ with some other special character or you can share some sample file to check the possibilities to extract the data out of your file.
Hi,
Is it possible for you to upload a sample dataset?
Rgds,
Dinu1