8 Replies Latest reply: Sep 28, 2016 7:02 AM by Anil Babu RSS

    Error loading Prices in excel

    Eduard Cabanas Gili

      Hi

       

      I have this table in XLSX format

       

       

      Article CodeProveedorTarifaFecha
      10365792PROV001351,95001/01/2016
      21125027PROV001351,66001/01/2016
      21125015PROV001351,95001/01/2016
      21125256PROV001351,66001/01/2016
      21125009PROV001351,78001/01/2016
      21130221PROV001352,90001/01/2016
      21132085PROV001351,85001/01/2016
      21127632PROV001352,34001/01/2016
      10371175PROV001351,15001/01/2016
      10371176PROV001351,56001/01/2016
      21125268PROV001351,69001/01/2016
      21127629PROV001351,69001/01/2016
      21125023PROV001351,33001/01/2016
      21125013PROV001351,06001/01/2016
      21127630PROV001351,69001/01/2016
      10358496PROV001352,45001/01/2016
      21130218PROV001352,13001/01/2016
      21125251PROV001352,45001/01/2016
      21127633PROV001351,71001/01/2016
      21130299PROV001352,30001/01/2016
      10364731PROV001351,61001/01/2016
      10364729PROV001352,52001/01/2016
      10364728PROV001351,31001/01/2016
      10364730PROV001351,58001/01/2016
      10364732PROV001351,34001/01/2016
      21124836PROV001351,65001/01/2016
      10360780PROV001351,65001/01/2016
      21129752PROV001351,46001/01/2016
      10371177PROV001351,69001/01/2016
      10371179PROV001351,26001/01/2016
      21127597PROV001358,00001/01/2016
      21132084PROV001353,00001/01/2016
      10368265PROV001353,00001/01/2016
      10358496PROV001352,95001/01/2016
      10369362PROV001353,44001/01/2016

       

      but when I upload Qlik tranforms the tarifa field (price) in another completly different

       

      Proveedor_TarifaFromItemIdTarifa
      PROV0013501/01/2016103584960.002
      PROV0013501/01/2016103584960.003
      PROV0013501/01/2016103607800.002
      PROV0013501/01/2016103647280.001
      PROV0013501/01/2016103647290.003
      PROV0013501/01/2016103647300.002
      PROV0013501/01/2016103647310.002
      PROV0013501/01/2016103647320.001
      PROV0013501/01/2016103657920.002
      PROV0013501/01/2016103682650.003
      PROV0013501/01/2016103693620.003
      PROV0013501/01/2016103711750.001
      PROV0013501/01/2016103711760.002
      PROV0013501/01/2016103711770.002
      PROV0013501/01/2016103711790.001
      PROV0013501/01/2016211248360.002
      PROV0013501/01/2016211250090.002
      PROV0013501/01/2016211250130.001
      PROV0013501/01/2016211250150.002
      PROV0013501/01/2016211250230.001
      PROV0013501/01/2016211250270.002
      PROV0013501/01/2016211252510.002
      PROV0013501/01/2016211252560.002
      PROV0013501/01/2016211252680.002
      PROV0013501/01/2016211275970.008
      PROV0013501/01/2016211276290.002
      PROV0013501/01/2016211276300.002
      PROV0013501/01/2016211276320.002
      PROV0013501/01/2016211276330.002
      PROV0013501/01/2016211297520.001
      PROV0013501/01/2016211302180.002
      PROV0013501/01/2016211302210.003
      PROV0013501/01/2016211302990.002
      PROV0013501/01/2016211320840.003
      PROV0013501/01/2016211320850.002

       

      thank's

      Eduard