1 Reply Latest reply: Mar 19, 2015 11:10 AM by Hans Peter Debets RSS

    why show $Sync 1 Table in Source Table view Mode?

      Qlik Sense 1.1.0 version

       

      my load script//

       

      Sales:

      LOAD

          Region,

          Date("Date",'YYYY-MM-DD') as "Date",

          "Order #" as "Order",

          Customer,

          "Invoice #" as Invoice,

          Products,

          "Sales Qty",

          Revenue,

          Margin,

          "Sales Price"

      FROM [lib://BaseCamp_20150317/Current Year Sales da - APAC.xls]

      (biff, embedded labels, table is Sales$);

       

      Weather:

      LOAD

          Region,

          Date("Date",'YYYY-MM-DD') as "Date",

          "Time",

          Temp,

          "Temp c",

          Windchill,

          Humidity,

          Pressure,

          Visability,

          "Wind Direction",

          "Wind Gusts",

          "Wind Speed",

          Precipitation,

          Events,

          Conditions,

          Latitude,

          Longitude

      FROM [lib://BaseCamp_20150317/Daily European Weather - Date Fix - APAC.xls]

      (biff, embedded labels, table is Weather$);

       

      Internal table view:

       

       

       

      Source table View : The relationship must be established between the two tables Is not that right?