AutoNumber

Sat, 25 Feb 2012 14:55:53 GMT

Hi,

I have a fact table Sales and dimension Table Articles:

Example:

F_Sales:

ID_Ste

ID_Article,

Revenue,

Profit,

Margin,

Devise

D_Articles

ID_Ste,

ID_article,

Code Article,

Caption Article,

Desciption Article,

Type Article

What is the best way to create relationship between Article and Sales ?

MAPPING ... LOAD ???

F_Sales :

LOAD

AutoNumber(ID_Ste,ID_Article) as ID_Article,

ID_Ste

ID_Article,

Revenue,

Profit,

Margin,

Devise

FROM F_SALES;

F_Articles :

AutoNumber(ID_Ste,ID_article) as ID_Article,

ID_Ste,

ID_article,

Code Article,

Caption Article,

Desciption Article,

Type Article

FROM D_ARTICLES;

What is the different between mappping... load on load ... AutoNumber ?

Could you please give me an example ?

Thanks .

AutoNumber

marcohadiyanto — Sun, 26 Feb 2012 15:05:01 GMT

hi.

you can check mapping load on reference manual or help (F1).

if you wanna create a relationship between that two table, the way you do i think it's correct but check the syntax of autonumber on help.

regards,

topic AutoNumber in QlikView

AutoNumber

AutoNumber