Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for
Search instead for
Did you mean:
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!
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.
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).