Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
LOAD Date(Date,'DD/MM/YYY') As Date,
Dimension,
TxnType,
WOS as Distribution,
[Seller HQFlag] AS [Outlet Type]
// Region,
// ModelCode
FROM
(
//Left Join
Meess_Temp1:
LOAD
Date(Date,'DD/MM/YYY') As Date,
Dimension,
TxnType,
WOS as Distribution,
[Outlet Type]
// Region,
// ModelCode
FROM
(
i have input like below i attached .i want to get
Out letType D-2 Wk-1 Wk-2
Distribution 4.9 4.8 4.7
like this i want output.
the implementation must be done in scripting side ony.
plz help me
Try Cross Table or generic load.
Your Word file can not be opened..