Split year and month

[Anonymous]

  I have attache my file.I need to spilt as year and month,also month should be in text format.please clear my dbts

[kaushiknsolanki · Accepted solution]

You can try this.

Load Period,

        Year(Makedate(Left(Period,4),Right(Period,2))) as Year,

        Month(Makedate(Left(Period,4),Right(Period,2))) as Month

From Xyz;

Regards,

Kaushik Solanki

[Anil_Babu_Samineni]

Try This too

Table1:

Load Period From Source;

Left Join(Table1)

Load Period,

           Left(Period,4) as Year,

           Right(Period,2) as Month

Resident Table1;

Or

Load Period,

          Year(Period,'YYYY') as Year,

           Month(Period,'Mmm') as Month

From source ;

[antoniotiman]

Hi,

LOAD *,

Year(Date#(Period,'YYYYMM')) as Year,

Month(Date#(Period,'YYYYMM')) as Month

From Table;

Month is Dual Field (Text and Number)

Regards,

Antonio

[Anonymous]

Thanks..Its worked.

[Anonymous]

Year(Date#(Period,'YYYYMM')) as Year,

Month(Date#(Period,'YYYYMM')) as Month

In this,What is the meaning of '#'.My view is fetch the value.am i  right?

[oknotsen]

If your question is now answered, please flag the Correct Answer (via the big "Correct Answer" button near every post) and Helpful Answers (found under the Actions menu under every post).

If not, please make clear what part of this topic you still need help with .