topic Re: Excel data getting mixed up somehow? in Water Cooler https://community.qlik.com/t5/Water-Cooler/Excel-data-getting-mixed-up-somehow/m-p/477637#M1416 <HTML><HEAD></HEAD><BODY><P>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).</P><P></P><P>- Marcus</P></BODY></HTML> Fri, 09 Aug 2013 11:47:52 GMT marcus_sommer 2013-08-09T11:47:52Z Excel data getting mixed up somehow? https://community.qlik.com/t5/Water-Cooler/Excel-data-getting-mixed-up-somehow/m-p/477636#M1415 <HTML><HEAD></HEAD><BODY><P>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.</P></BODY></HTML> Thu, 08 Aug 2013 13:32:00 GMT https://community.qlik.com/t5/Water-Cooler/Excel-data-getting-mixed-up-somehow/m-p/477636#M1415 2013-08-08T13:32:00Z Re: Excel data getting mixed up somehow? https://community.qlik.com/t5/Water-Cooler/Excel-data-getting-mixed-up-somehow/m-p/477637#M1416 <HTML><HEAD></HEAD><BODY><P>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).</P><P></P><P>- Marcus</P></BODY></HTML> Fri, 09 Aug 2013 11:47:52 GMT https://community.qlik.com/t5/Water-Cooler/Excel-data-getting-mixed-up-somehow/m-p/477637#M1416 marcus_sommer 2013-08-09T11:47:52Z