help

[#1]

Hi,

i need to know how qlikview make the association between data and how make association between data in differents files for exampe i have 3 tables:CLIENTTS,PRODUCTS,SALES PRODUCTS

[MK_QSL]

Not clear from you question.. Can you please elaborate little more?

Thanks

[lironbaram]

qlikview connects table

via column name

[stevedark]

In your load script rename a field in each table so that it is the same as the name of a field in another table.

Eg.

LOAD

    SaleProductId as ProductId,

Hope that helps,

Steve

[its_anandrjs]

If you load all the 3 tables CLIENTTS,PRODUCTS,SALES PRODUCTS and when loading if there is same field name present then qlikview treat that field name as same field and make an association between then. And if you not want association simply rename the fields like

Load

PRODUCTS as ProductId

From Location;

[#6]

In QlikView association between two tables happens based on common field names.

That means if you have 3 tables Clients,Products and Sales Products

then Clients and Products will associate on a single common field/column name. There should be only one common field between two tables, otherwise you will get synthetic key.

Products and Sales Products table can also associate based on the common field/column name.

if your table does not have a common column  name then as Steve suggested , rename or alias a column in one of the tables so that they match.

Hope this helps.