Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Not applicable

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?

1 Reply
happydays1967
Contributor

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

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