Qlik Community

Community Corner

Discussion board for questions about the Qlik Community, its features, sharing information, general discussions and even some fun. This is for both new and longtime community members. Everyone is welcome!

Highlighted
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.

Tags (3)
1 Reply
MVP & Luminary
MVP & Luminary

Re: Excel data getting mixed up somehow?

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