3 Replies Latest reply: Oct 5, 2012 3:33 PM by Siddharth Kulkarni RSS

    Issue while loading data from excel

    Siddharth Kulkarni

      Issue: Trying to load data through an excel table. Table has 2 fields(A,B), around 150 records. The 2nd field(B) shows 0 value  for all 150 records when loaded in qlikview (Also thru transformation), although you can see the real numbers when opened an viewed through excel in the same field. Important: If you open the xls file and just re-save it as is, and then reload, the issue is not seen. Cant send over the file, as the data is highly confidential. If I scramble/save and send, the issue no longer exists Qlikview: 9.0 SR7 Excel: 2007 Please assist, if any one knows the root cause and solution. Regards, Siddharth