Data Model Issue

[vanderson009]

Hi Community,

I have query regarding data model.

I have product table with productname and sales field, but i dont have month field as like :

but i want to add month field in that table like :

How can i achieve this, please help me.

Thanks,

Villyee

[Gysbert_Wassenaar]

Table1:

LOAD ProductName, Sales

FROM ...

JOIN (Table1)

LOAD * INLINE [

Month

Jan

Feb

Mar

];

[Anonymous]

Would something like this help ?

Data :

LOAD * INLINE [

    ProductName, Sales

    A, 100

    B, 150

    C, 120

];

outer join (Data)

LOAD * INLINE [

    Month

    Jan

    Feb

    Mar

];

[mohammadkhatimi]

Table1:

LOAD ProductName, Sales

FROM ...

JOIN (Table1)

LOAD * INLINE [

Month

Jan

Feb

Mar

Apr

May

];

Hope this Helps you.

Regards,

Mohammad