friends here i mentioned with some example data
Service_Type:
LOAD distinct
Parent_Entity_Id as "Service Type"
FROM
D:\Entity.qvd
(qvd)
where Parent_Entity_Type = 'SERVICE TYPE';
Financial_Entity:
LOAD
Entity_Id as "Financial Entity Id"
FROM
D:\Entity.qvd
(qvd)
where Entity_Type = 'FINANCIAL ENTITY';
Service_Entity:
LOAD
Entity_Id as "Service Id",
Entity_Name as "Service Name"
FROM
D:\Entity.qvd
(qvd)
Where Entity_Type = 'SERVICE';
Vendor_Entity:
LOAD Entity_Id as "Vendor Id",
Entity_Name as "Vendor Name",
Entity_Type
FROM
D:\Entity.qvd
(qvd)
Where Entity_Type = 'VENDOR';
Category_Entity:
LOAD Entity_Id as "Category Id",
Entity_Number as "Category Number",
Entity_Name as "Category Name"
FROM
D:\Entity.qvd
(qvd)
Where Entity_Type = 'CATEGORY';
Fact_Reservation:
LOAD DISTINCT
Reservation_Number as "Reservation Number",
Reservation_Item_Number,
Reservation_SubItem_Number,
Date(date#(Book_Date,'YYYYMMdd'), 'MM/DD/YYYY') as "Book Date" ,
Date(date#(Travel_Begin_Date,'YYYYMMdd'), 'MM/DD/YYYY') as "Travel Begin Date" ,
Item_Status_RESITTB as "Item Status",
Party_Name as "Party Name",
Brand_Id,
Financial_Entity_Id_RESHDTB as "Financial Entity Id" ,
Date(date#(Service_Begin_Date,'YYYYMMdd'), 'MM/DD/YYYY') as "Service Begin Date",
Service_Duration as "Service Duration",
Service_Id_RESITTB as "Service Id",
Service_Type as "Service Type",
Item_Cost_Exchange_Rate as "Item Cost Exchange Rate",
Item_Cost_Currency as "Item Cost Currency",
Vendor_Id as "Vendor Id",
Number_of_Passengers_RESITTB as "Number of Passengers",
Total_Cost_Amount_RESITTB as "Total Cost Amount",
(Total_Cost_Amount_RESITTB/Item_Cost_Exchange_Rate) as "Cost Vendor Currency",
Category_Id as "Category Id_",
Category_Number as "Category Number"
FROM
D:\Fact_Reservation.qvd
(qvd)
where Service_Type <> 'PACKAGE';
is there any way, shall i load Entity. QVD only once and use with different parameter conditions
like case statement/Switch statement.please help me it is urgent
LOAD Entity_Id as "Category Id",
Entity_Number as "Category Number",
Entity_Name as "Category Name"
from
case1:
where Parent_Entity_Type = 'SERVICE TYPE'
case 2:
Where Entity_Type = 'SERVICE'
case3:
Where Entity_Type = 'VENDOR'
case4:
Where Entity_Type = 'CATEGORY'
