Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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";
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
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;
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";