4 Replies Latest reply: Dec 4, 2012 4:14 PM by Anton van Nijkerk RSS

    Problem connection table

      I have a problem with connection to the differnt table.

       

      Many cash system in our country sending files to our global system, every night makes this system a xml file see attachment.

       

      This xml file import every day to qlikview kassa demo see attachment.

       

      the problem is that the connnection to the different table not work, the ticketnumber must show the site ( cash system) oderdate, time

       

      i can't change the xml

       

      can anyone help me to use the correct settings in the script.

        • Re: Problem connection table
          Celambarasan Adhimulam

          Use Date#(OrderDate,'YYYYMMDD') AS OrderDate

          for the OrderDate field in the Ticket table.

          You had done for the order table but missed to do it in the Ticket table.

           

          Hope it solves the problem.

            • Re: Problem connection table

              thank you,

               

              but when i load the script and select ticketnr he shows me all off the products.

               

              he must show the products they are sold  on this ticket.

               

              the ticket si the key to show sitename products odredate etc.

                • Re: Problem connection table
                  Gysbert Wassenaar

                  You can't join the two tables on order date since many tickets have the same date. So you get a many-to-many join. You need to rename Orderdate to something like Ticketdate in the ticket table and uncomment the %Key_Ticket... field so it joins correctly with Orders.

                   

                  Ticket:

                  LOAD Date#(Date,'YYYYMMDD')  as TicketDate,

                     TicketNr,

                      CentNr,

                      CentName,

                      SiteNr,

                      SiteName,

                      TotTicket,

                      Tot2Pay,

                      Reprint,

                      Kill,

                      B2Table,

                      Void,

                      ChkDiscTot,

                      ChkTotal,

                      AccKind,

                      AccNr,

                      AccName,

                      TableNr,

                      [Paymode/PayLine/PaymNr] as PaymNr,

                      [Paymode/PayLine/PaymName] as PaymName,

                      [Paymode/PayLine/Qty] as [PayLine/Qty],

                      [Paymode/PayLine/Value] as Value,

                     %Key_Ticket_369F651F33B57014  

                  FROM [..\..\..\..\qlikview\nieuwe export hq\FX20121103.xml] (XmlSimple, Table is [Tickets/Ticket]);