2 Replies Latest reply: Oct 26, 2017 12:11 PM by Marcel Vinicius de Oliveira RSS

    Transpor dados

    Bruno Zapelli

      Boa tarde pessoal!

       

      Estou iniciando no Qlik e tenho uma dúvida:

       

      Tenho uma base em Excel no seguinte formato:

       

      Data                  Hora          Descrição          Valor

      xx/xx/xxx           xx:xx              A                    #

      xx/xx/xxx          xx:xx               A                    #

      xx/xx/xxx          xx:xx               A                    #

      xx/xx/xxx          xx:xx               B                    #

      xx/xx/xxx          xx:xx               B                    #

      xx/xx/xxx          xx:xx               B                    #

      xx/xx/xxx          xx:xx               B                    #

      xx/xx/xxx          xx:xx               C                    #

      xx/xx/xxx          xx:xx               C                    #

      xx/xx/xxx          xx:xx               C                    #


      Preciso transformar em:


      DataA                  HoraA               A            DataB                  HoraB               B          DataC                  HoraC               C   

      xx/xx/xxx             xx:xx                 #            xx/xx/xxx             xx:xx                 #           xx/xx/xxx             xx:xx                 #

      xx/xx/xxx             xx:xx                 #            xx/xx/xxx             xx:xx                 #           xx/xx/xxx             xx:xx                 #

      xx/xx/xxx             xx:xx                 #            xx/xx/xxx             xx:xx                 #           xx/xx/xxx             xx:xx                 #

      xx/xx/xxx             xx:xx                 #            xx/xx/xxx             xx:xx                 #           xx/xx/xxx             xx:xx                 #

      xx/xx/xxx             xx:xx                 #            xx/xx/xxx             xx:xx                 #           xx/xx/xxx             xx:xx                 #


      Alguma ideia?