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

[#1]

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?

[happydays1967]

QlikView can't do direct multiple field joins. Always make sure you have one and only one field with identical name (case sensitive!) between two tables to get a straight join. You might want to consider concatenating two or more fields to achieve this.

Synthetic tables are memory killers and should be avoided at all cost....

HP