Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi ,
Attaching QVF file my requirement is within selected financial year I want to create a dynamic dimension which will identify the active/in-active customer also I need to classify Single/Multi means I want dimension whether customer feed fuel one time (Single) or more than one time Multi.
I have attached QVF & DATA.
Thanks in Adv.
Vikas
Try this, wherein you can see the status by Year for that CARD_ROOT_ID.
Data:
LOAD
CARD_ROOT_ID,
LOYALTY_PROGRAM_TYPE,
"Customer Code",
CARD_ROOT_ID & '|' & "Customer Code" as CustomerCardKey,
PRODUCT_TYPE,
"Sales Value",
"Sales Volume",
TXN_DATE,
text(Year(TXN_DATE)) as Year,
TRANSACTION_COUNT,
CARD_TYPE,
PREVIOUS_CARD_TYPE,
AVG_RSP,
CARD_CREATION_DATE
FROM [lib://BPCL/ROOT CARD Id.xls]
(biff, embedded labels, table is [ROOT CARD Id$]);
Join(Data)
Load CARD_ROOT_ID,
text(Year(TXN_DATE)) as Year,
sum(TRANSACTION_COUNT) as TRANSACTIONS,
if(sum(TRANSACTION_COUNT)=1,'Once','Multiple Time') as Status
Resident Data Group By CARD_ROOT_ID,text(Year(TXN_DATE));