Adding Column Measure

[vikas_nandanwar]

Hi,

I have auto date month and Week as two separate columns

I require a new column measure to be added to the data calculated as =

Date Month + week

Example

Date= 2 jan

Week = 1

My new column name should be = Month+Week

Answer  = Jan1

Thanks,

Vikas

[kaushiknsolanki]

Hi,

Simply use preceding load in script like below.

Load *,Month&Week  as Newfield;

Load Date,Month,Week from xyz;

In front end (on visualization) you can add dimension as

Month&Week

Regards,

Kaushik Solanki

[vikas_nandanwar]

The below is my script

LIB CONNECT TO '198.7.112';

Join

LOAD GroupNm,

    CategoryNm,

    SubCategoryNm,

    SizeNm as Size,

    QualityNm as Quality,

    OGC,

    Ptype,

    InventoryQty as Qty,

    StockValueInDollar as CostAmount,

    WkClosingdate as TransactionDate,

    DataWeek;

SQL SELECT GroupNm,

    CategoryNm,

    SubCategoryNm,

    SizeNm,

    QualityNm,

    OGC,

    Ptype,

    InventoryQty,

    StockValueInDollar,

    MemoOut,

    MemoIn,

    WkClosingdate,

    DataWeek

FROM dbCertifiedInventory.dbo."vw_DailyInventoryUpload834";

I need to concatenate  -

WkClosingdate as TransactionDate,

   and DataWeek;

[Anil_Babu_Samineni · Accepted solution]

Do you mean this?

LIB CONNECT TO '198.7.112';

Join

LOAD GroupNm,

    CategoryNm,

    SubCategoryNm,

    SizeNm as Size,

    QualityNm as Quality,

    OGC,

    Ptype,

    InventoryQty as Qty,

    StockValueInDollar as CostAmount,

    WkClosingdate & DateWeek as TransactionDate;

SQL SELECT GroupNm,

    CategoryNm,

    SubCategoryNm,

    SizeNm,

    QualityNm,

    OGC,

    Ptype,

    InventoryQty,

    StockValueInDollar,

    MemoOut,

    MemoIn,

    WkClosingdate,

    DataWeek

FROM dbCertifiedInventory.dbo."vw_DailyInventoryUpload834";