Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Excel data getting mixed up somehow?

I've been trying to import sheets from an excel spreadsheet and using the 'table files' option to do so. The columns show up in the 'table files' selection part correctly, but then between reloading and putting those columns into a table box, the data gets muddled up and puts data from other columns into the wrong ones. I don't have any idea what's causing this or how to fix it, so help would be great. Thanks.

1 Reply
marcus_sommer

Fields in text-files could contain special chars like tabs and so on, which could cause some problems, but in excel is it rather unlikely ... Put a rowno() command in your load to find these rows and have a closer look on these data parts (sometimes is here a hex-editor helpful).

- Marcus