How to create a YearMonth from date field ?

[paulyeo11]

Hi All

I have below script , i need to create a field name YearMonth from DATE.

Hope some one can advise me. I keep get error msg. when i try partial reload.

sales:

LOAD Subject,

     [Due Date] as DATE,

     [Item Name],

     Quantity,

     [List Price],

     [Item Comment],

     Discount,

     Description

FROM

(txt, utf8, embedded labels, delimiter is ',', msq);

I have

[qlikview979]

PFA

[Anil_Babu_Samineni]

You have to make your field instead of DATE?

[paulyeo11]

Hi Mahesh

Your approach is quite nice , as it is don't need to create partial load. Thank you

Paul Yeo

[paulyeo11]

Hi Mashesh

Thank you , this is another approach.

Paul