Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
ramsurya
Contributor III
Contributor III

Special character issue while loading data from xlsx file in qlikview

Hi All,

 

I am facing issue while reading xlsx file if column contains '&' it reads text after '&'. as it is third party data download i can't do any changes in xlsx file. as it is i need to read in QLIkview. can you please help me how to read full decription while in qliview.

 

I have checked few scenarios mentioned below:
1) Convert file in xls then it will read full description.

2) I have checked column settings as 'Merge & Center' if i remove it will read full description.

BUt i can't change any setting as it is driectly downloaded from third party tool and need to read in QLikview.

 

Let me k now if you need more details about issue which i am facing .

1 Solution

Accepted Solutions
marcus_sommer

You may try to load the xlsx per ODBC with a sql-statement. There are various postings about Excel & ODBC, here one as a starting point:

xlsb-ODBC-connection-QlikSense 

- Marcus

 

View solution in original post

3 Replies
marcus_sommer

You may try to load the xlsx per ODBC with a sql-statement. There are various postings about Excel & ODBC, here one as a starting point:

xlsb-ODBC-connection-QlikSense 

- Marcus

 

ramsurya
Contributor III
Contributor III
Author

Can we do in Qlikview as well.

marcus_sommer

Yes, it's mostly the same.