Skip to main content
Announcements
Qlik Introduces a New Era of Visualization! READ ALL ABOUT IT
cancel
Showing results for 
Search instead for 
Did you mean: 
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
Creator
Creator

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